Jcat
宠辱不惊,闲看庭前花开花落~~
posts - 173,comments - 67,trackbacks - 0

>sqlplus /nolog              Just startup SQL*PLUS but haven't connected to DB

>sqlplus / as sysdba      Use os authentication

>sqlplus user/pwd         Use db authentication


SQL>startup                  Startup Oracle service (should startup TNSListener at first)

SQL>shutdown

SQL>connect user/pwd                        Local connection

SQL>connect user/pwd@host:1521    Remote connection *1* *2* *3*

SQL>connect system/pwd                   The pwd is the SYSTEM password that you set upon installation of Oracle Database XE.


>lsnrctl status               View listener status

>lsnrctl start

>lsnrctl stop

>lsnrctl reload

>lsnrctl services


>emctl start dbconsole  

>emctl start agent       start up the EM Grid Control facility

>isqlplusctl start         start up the iSQL*Plus server

Note
*1* Logging in to the Oracle Database XE host computer with an ssh (or telnet ) session and then starting SQL Command Line (or other Oracle command-line utility) is considered a local connection, even though you start the ssh (or telnet ) application on a remote computer.

*2* The remote computer must have Oracle client software installed.

*3* Only Oracle Database XE Client supports the notion of a default database service. If you connect remotely from any Oracle client software other than Oracle Database XE Client, you must include the XE service name.


 

posted on 2006-07-09 11:18 Jcat 阅读(409) 评论(0)  编辑  收藏 所属分类: Database

只有注册用户登录后才能发表评论。


网站导航: