on 08-21-2008 2:57 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.