Oracle Start Stop command

Http://www.blogjava.net/liaojiyong/archive/2007/10/26/156094.html

1. Start the database:

Oracle @ suse92: ~> Sqlplus/nolog SQL * Plus: Release 9.2.0.4.0-production on Fri Jan 20 02:29:37 2006 copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. SQL> connect/As sysdbaconnected to an idle instance. SQL> startuporacle instance started. total system global area 135352820 bytesfixed size 455156 bytesvariable size 109051904 bytesdatabase buffers 25165824 bytesredo buffers 679936 bytesdatabase Mo Unted.2. Shut down the database: Oracle @ suse92: ~> Sqlplus/nolog SQL * Plus: Release 9.2.0.4.0-production on Fri Jan 20 02:29:37 2006 copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. SQL> connect/As sysdbaconnected to an idle instance. SQL> shutdwon abort; 3. Start the listener Oracle @ suse92: ~> LSNRCTL start4. Stop the listener Oracle @ suse92: ~> LSNRCTL stop5. View listener status Oracle @ suse92: ~> LSNRCTL> Status LSNRCTL> exit ----------------------------------------------------------------- more detail: Http://www.softone.com.cn/serve04_03.aspIii. Oracle instance startup and Shutdown

1. Use SQL * Plus to start and terminate an instance

1.1 Local startup
Enter:
Sqlplus/nolog
Connect/As sysdba
Startup

1.2 Local Shutdown
Enter:
Sqlplus/nolog
Connect/As sysdba
Shutdown

1.3 remote start
Enter in the command prompt (this method must be performed first to close the database, see 1.4. Remote Shutdown (requires that the remote database be started), in E: /Oracle/ora81/sysman/ifiles directory to generate a de_test_zcb_8112.ora file and then start the database using this file ):
Sqlplus/nolog
Connect internal/ORACLE@TEST.SOFTONE.COM as sysdba
Startup File = E:/Oracle/ora81/sysman/ifiles/de_test_zcb_8112.ora
This path is the remote start service path. Generally, it is in the local installation directory of Oracle/ora81/sysman/ifiles.
Internal is the username, Oracle is the password, and test. softone. com is the remote service connection string.

1.4 Remote Shutdown
Enter:
Sqlplus/nolog
Connect internal/ORACLE@TEST.SOFTONE.COM as sysdba
Shutdown
Internal is the username, Oracle is the password, and test. softone. com is the remote service connection string.

2. Start and terminate an instance using the Server Manager.

2.1 local startup
Enter:
Svrmgrl
Connect internal
Startup

2.2 local Shutdown
Enter:
Svrmgrl
Connect internal
Shutdown

2.3 remote start
Enter in the command prompt (this method must be performed first to close the database, see 2.4. Remote Shutdown (requires that the remote database be started), in E: /Oracle/ora81/sysman/ifiles directory to generate a de_test_zcb_8112.ora file and then start the database using this file ):
Svrmgrl
Connect internal/ORACLE@TEST.SOFTONE.COM as sysdba
Startup
Pfile = E:/Oracle/ora81/sysman/ifiles/de_test_zcb_8112.ora
Internal is the username, Oracle is the password, and test. softone. com is the remote service connection string.
This path is the remote start service path. Generally, it is in the local installation directory of Oracle/ora81/sysman/ifiles.

2.4 Remote Shutdown
Enter:
Svrmgrl
Connect internal/ORACLE@TEST.SOFTONE.COM as sysdba
Shutdown