Posts Categorized: Pythian

Simple and Quick Way to Get SQL_ID of Query in Oracle

If you need to get SQL_ID of a query from a busy system, which has similar queries scattered all around, it becomes a hassle to get what you are looking for. If the query for which you are getting SQL_ID is big, or contains lots of apostrophes or other not-so-nice characters, then it becomes more…

Log Buffer #340, A Carnival of the Vanities for DBAs

Education is everything. Education can pull you out of poverty, it can propel you into upper echelons. Education can make you see what’s truly important in the life. Education can enable you to appreciate the people. Blogging is all about education. This Log Buffer brings education about database arena from the blogs.

In-Place Upgrade failure from SQL Server 2008 SP1 to SQL Server 2008 R2

Recently I was trying to upgrade SQL Server 2008 to SQL Server 2008 R2. The upgrade failed with error message below.   TITLE: Message Details —————————— The Instance ID ‘MSSQLSERVER’ is already in use by SQL Server instance ‘MSSQLSERVER.INACTIVE’. To continue, specify a unique Instance ID. —————————— BUTTONS: OK ——————————     Brief Background of…

Silent Installation of RAC 12c database

Nowadays everyone is installing #db12c in different variants, posting screenshots, talking about a better tool to run GUI through. However I could not find posts about silent installation of GI and RDBMS. Yes, installation without sleek graphical interfaces, just pure command line in terminal. Thinking about RAC Attack at OOW13 I decided to install a…

Log Buffer #339, A Carnival of the Vanities for DBAs

Tablogs are the blogs written, read, and managed on tablets. They are not only growing in numbers, but the volume of content is also immense. So much ease and so much power through touches ensure that you only spend time creating and learning. This Log Buffer edition appreciates that.

Breaking News: Oracle E-Business Suite Release 12.2.2

Oracle E-Business Suite Release 12.2.2 is out! Big times ahead of us folks! My team is planning to blog about it a lot. Stay tuned. This is my prediction: Online patching a game-changer in Oracle E-Business Suite 12.2 Oracle Press Release Steven Chan’s blog You can get it from e-delivery site. Yury PS: If any of you…

Duplication: divide et impera

For me, every Monday morning starts with the same routine. I refresh some QA databases from PeopleSoft production one. Even though the process is almost fully automated (all commands are automatically generated) it takes several hours to perform the final steps because DUPLICATE FROM ACTIVE DATABASE performs image copies to the destination server. I am…

Page 22 of 205« First...10...2021222324...304050...Last »