| STARTUP-SHUTDOWN in Oracle 9.2.0 [message #72515] |
Tue, 08 July 2003 10:09  |
lily
Messages: 44
Registered: September 2000
|
Member |
|
|
I am using oracle 9.2.0 database (64 bit) on sun solaris.
I need to create a standby database. (I have done this in Oracle 8.1.7.)
Now, how do I shutdown and start an Instance in 9.2.0?
I am new to 9.2.0. Is svrmgrl works from Unix prompt?
If not, then how do I startup or shutdown an Instance?
thanks,
lily,
|
|
|
|
| Re: STARTUP-SHUTDOWN in Oracle 9.2.0 [message #72518 is a reply to message #72515] |
Thu, 10 July 2003 11:02  |
Navtej
Messages: 19
Registered: July 2003
|
Junior Member |
|
|
Set the enviornemet like ORACLE_HOME,ORACLE_SID,PATH and
LD_LIBRARY_PATH
FOR STARTUP
sqlplus /nolog
sql > connect / as sysdba
SQL > startup
FOR SHUTDOWN
sqlplus /nolog
SQL > Shutdown imeediate;
svrmgrl is obseleted in 9i
|
|
|
|
|
|
| Re: STARTUP-SHUTDOWN in Oracle 9.2.0 [message #72529 is a reply to message #72515] |
Fri, 11 July 2003 05:03 |
Shesh
Messages: 16
Registered: July 2003
|
Junior Member |
|
|
Hi,
In 9i there is no SVRMGRL or CONNECT INTERNAL.
Instead you have to login as sys with sysdba priv.
you can use
$sqlplus /nolog
SQL> connect sys as sysdba
Password: <Enter the Password>
SQL> Startup Nomount/Mount
bye
shesha
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
