Oracle 10g for NT start, close

xiaoxiao2021-03-06  90

1. Start ORACleServiceorCl in the service.

Or run oracle.exe orcl

2. Start instance:

SQLPlus Sys / Aaaaaaa As Sysdba

SQL> Startup

*************************************************** **********

D: /> SQLPLUS SYS / AAAAAAA ASDBA

SQL * Plus: Release 10.1.0.2.0 - Production on Saturday Aug 200 19:42:29 2004

Copyright (C) 1982, 2004, Oracle. All Rights Reserved.

Connected to an iDLE Instance.

SQL> StartupoPoracle Instance Started.

Total System Global Area 134217728 bytesFixed Size 787808 bytesVariable Size 61864608 bytesDatabase Buffers 71303168 bytesRedo Buffers 262144 bytesDatabase mounted.Database opened.SQL> select * from scott.a;

ID Name ---- --------------------------------- -------------------------------------------------- 01 three CHINA, Shandong, China

SQL>

*********************************************************************************************************** **********

3. Close

SQL> Shutdown

4. Stop the corresponding service (OraclesErviceorCl).

Note:

Open Port 1521 with lsnrctl start

Look at the status LSNRCTL Status

Close Lsnrctl Stop

转载请注明原文地址:https://www.9cbs.com/read-122522.html

New Post(0)