用命令行 oracle启动停止命令

1、启动数据库:

oracle@suse92:~>sqlplus/nolog

SQL*Plus:Release9.2.0.4.0-ProductiononFriJan2002:29:372006

Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.

SQL>connect/assysdba

Connectedtoanidleinstance.

SQL>startup

ORACLEinstancestarted.

TotalSystemGlobalArea135352820bytes

FixedSize455156bytes

VariableSize109051904bytes

DatabaseBuffers25165824bytes

RedoBuffers679936bytes

Databasemounted.

2、关闭数据库:

oracle@suse92:~>sqlplus/nolog

SQL*Plus:Release9.2.0.4.0-ProductiononFriJan2002:29:372006

Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.

SQL>connect/assysdba

Connectedtoanidleinstance.

SQL>shutdwonabort;

3、启动监听器

oracle@suse92:~>lsnrctlstart

4、停止监听器

oracle@suse92:~>lsnrctlstop

5、查看监听器状态

oracle@suse92:~>lsnrctl

LSNRCTL>status

LSNRCTL>exit

相关推荐