Getting error while shutting down oracle DB instances

Asked By 0 points N/A Posted on -
qa-featured

Hi,

I am system engineer working for a private film.

I mostly support on Unix server that is IBM AIX server for the clients .In one of the server we are using ora11gR2 and ora10gR2 database, when I try to shutdown the DB I am getting an error as “could not open parameter file '/oradata3/oracle11g/ora11gR2/app/ora11gR2/product/11.2.0”.this is the first time I am getting error while shutting down the instances.

I will mention the two database 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”.

Please help.

Thanks.

SHARE
Answered By 0 points N/A #79997

Getting error while shutting down oracle DB instances

qa-featured

 You are not shutting down the instances correctly so it may be the reason you are getting an error .According to your server you are using two database that is ora11g R2 and ora10g R2 ,but you are shutting down the services of other DB in other. Instances are not same with other DB so be careful when you are shutting down the instances.

When you are trying to shutdown instance  by giving command “id” you will be able to see where exactly you are there in the server .You can see if you are inside the server or some other location you can find out the current location. I am giving you one example as “uid=1054(ora11g R2) gid=100(dba) groups=100(dba)” here if you are log in with your user id then you will be able to see yours log id when you give command “id”.

if you want to shut down any Database  service of the server then you need to log in with 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”,Then the instance will be down. Sometime it takes some time for shutting down so when you give the command wait for 2-5 min until you see the full shutting down confirmation.

Login/Register to Answer

Related Questions