>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