Asked By
james k
400 points
N/A
Posted on - 07/01/2011
I am a system engineer working for a private firm. I am mostly into support on a Unix server i.e. IBM AIX server for the clients. In one of the servers, we are using the ora11gR2 and ora10gR2 databases. When I try to shutdown the DB, I am getting an error “could not open parameter file '/oradata3/oracle11g/ora11gR2/app/ora11gR2/product/11.2.0”. This is the first time I am getting an error while shutting down the instances. I will mention the two databases and the instances name as:
“ora11gR2 18974 1 0 01:24:47 ? 0:21 ora_pmon_SOADB”
“ora10gR2 19156 1 0 01:26:02 ? 0:19 ora_pmon_FLEXCJ”
“ora11gR2 19072 1 0 01:25:13 ? 0:19 ora_pmon_FCPBDB”
Error while shutting down oracle DB
You are not shutting down the instances correctly, so because of that, I guess, you are getting that error. According to your server you are using two databases, that is ora11gR2 and ora10gR2, but you are shutting down the services of other DB in other. Instances are not the same with the other DB so be careful when you are shutting down these instances. When you are trying to shut down instances using the command “id”, you will be able to see where exactly you are in the server. You can see if you are inside the server or some other location, it will give you the current location.
I am giving you one example: for “uid=1054(ora11gR2) gid=100(dba) groups=100(dba)”, if you are logged in with your user ID, then you will be able to see your logon ID when you give the command “id”. If you want to shut down any database service of the server, then you need to log onto that server and from there you need to run the command with the instances name. Once you are inside the DB, then give the command “shut down immediate” or “shut abort” which will bring down that instance. Sometimes, it takes time for shutting down, so after you give the command, wait for 2-5 mins until you see the full shutting down confirmation.