Posts Tagged ‘oracle’
Copying Oracle Scheduler jobs with Arguments
Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due to following scenarios 1)Runaway jobs – When Scheduler job is running [Read More]
11g: Multiple failed login attempt can block New Application connections
In Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per Bug 7715339 – Logon failures causes “row cache lock” waits – Allow disable of logon [Read More]
V$SQL_SHARED_CURSOR in 11.2.0.2
Oracle 11.2.0.2 has introduced new column “REASON” to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which can cause multiple child cursors). As per documentation [Read More]
BUG:10082277: Database Connections failing with ORA-4031
A short write-up on a problem faced in few newly upgraded databases to 11.2.0.1 : I faced this issue in couple of databases which were recently upgraded to 11gR2, the problem is so severe that even connecting using “/ as sysdba” is not working and erroring out [Read More]
BUG: Creating 11gR2 RAC Using VMware On Toshiba Laptop
I was setting up 11gR2 RAC grid infra on my new Toshiba L745 series laptop on OEL5.4, the installation was going very smoothly but suddenly the VMWare machines crashed while performing remote operations on second node with following message: <span [Read More]
10.2 CRS startup issue
Today I faced a strange issue with CRS post host reboot. CRS was not coming up and we could see following message in $ORA_CRS_HOME/log/<hostname>/client/clsc*.log cat clsc26.log Oracle Database 10g CRS Release 10.2.0.4.0 Production Copyright 1996, 2008 Oracle. All [Read More]
ORA-00132 while starting 11gR2 database
Short post on a error which can take lot of time to debug. You have upgraded a database and after restoring all files (init,tnsnames) try to startup 11g database and it fails with following error SQL> startup nomount ORA-00119: invalid specification for system parameter [Read More]
Retrieving Database SID,Port information from Grid Control repository
This is short posting on sql which can be used to get Hotsname,SID,Port information for databases registered in Grid Control repository. This information can be used to create a tns entries and we can further use it to run a sql on all these databases. set pages 999 lines [Read More]
ORA-01722 with Full Table Scan
My application developers approached me with an issue which is very unique to me. They were complaining about a query which was failing with ORA-01722 “invalid number” after an upgrade to 11.1.0.7 from 10.2.0.4. The syntax of the query is like: select max(a) [Read More]
Renaming Diskgroup containing Voting Disk and OCR
Recently encountered a issue where we had to rename a diskgroup for 11.2 RAC containing OCR and Voting Disk.At this moment we had not created database . I had done similar activity on 11.2 Single instance having database files (see this post) using renamedg. Therefore we [Read More]
Physical Corruption: ORA-1578 part 3
Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database files. Saurabh had earlier written articles on ora-1578. http://askdba.org/weblog/2008/04/physical-corruption-ora-1578-part-1/ [Read More]
DBMS_SCHEDULER jobs not running?
I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite old and many of you would have already seen it. But for others and also for my future reference I am mentioning it here [Read More]
Downloading Oracle Software directly to Server
This article is based on Pythian’s aricle DOWNLOADING FROM OTN DIRECTLY TO YOUR DATABASE SERVER. Article tell’s about using lynx (text based web browser available on linux) to generate the cookies file which can be then used with wget to download software. But [Read More]
11gR2: Steps to Rename ASM Diskgroup with DB files
11gR2 introduced renamedg utility to rename diskgroups. I would discuss renaming a diskgroup on a Standalone Grid Infrastructure installation with Oracle Restart. Before you use the command, ensure that ASM diskgroup is dismounted. Below is syntax for the command. You can [Read More]
ORA-27146 Errors while starting up Database
Short post on a issue faced by me, while starting up a cloned database SQL> startup nomount ORA-24323: value not allowed ORA-27146: post/wait initialization failed This database environment was cloned and was being started for first time after cloning. Running hcve [Read More]
