cancel
Showing results for 
Search instead for 
Did you mean: 

ORacle instance

Former Member
0 Kudos

When i am trying to install the opatch , it is asking to check whether oracle instances are runn ing, if running i need to stop the oracle instances

Can some one help me to shutdown the oracle instances.

thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

Hello,

just execute the following commands:

> shell> su - <SID>adm

> shell> stopsap

or

> shell> su -ora<SID>

> shell> sqlplus "/ as sysdba"

> SQL> shutdown immediate;

Regards

Stefan

Former Member
0 Kudos

I trying to stop as u said

i get SQL> shutdown immediate;

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

HP-UX Error: 2: No such file or directory

thanks

stefan_koehler
Active Contributor
0 Kudos

Hello,

> ORA-01034: ORACLE not available

> ORA-27101: shared memory realm does not exist

If you get this ora message, your instance is already down. Maybe you have executed the stopsap before.

You can check this too by executing the following command:

> shell> ps -fu ora<SID>

If you don't see any ora_XXX processes ... your instance is down.

Regards

Stefan

former_member182034
Active Contributor
0 Kudos

Dear Rama,

ORA-01034: ORACLE not available

its mean that your DB is already shutdown

and

if u r facing this problem then plz restart your system and check the Oracle services are automatic and started then connect with Oracle instance with these commands:

C:\ sqlplus "/as sysdba"

SQL> startup

regards,

jamil

Former Member
0 Kudos

yes