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>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

*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 阅读(401) 评论(0)  编辑  收藏 所属分类: Database