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 閱讀(420) 評論(0)  編輯  收藏 所屬分類: Database
          主站蜘蛛池模板: 中阳县| 宝鸡市| 周至县| 怀柔区| 太谷县| 通河县| 甘德县| 鸡西市| 汝城县| 西昌市| 武胜县| 邢台市| 乌海市| 辽宁省| 仙居县| 西乌珠穆沁旗| 江口县| 汕尾市| 茌平县| 孝昌县| 江山市| 长海县| 若尔盖县| 全州县| 娄烦县| 玛沁县| 辽宁省| 额济纳旗| 安西县| 桐城市| 内丘县| 商城县| 营口市| 合肥市| 开远市| 望谟县| 绥德县| 昌吉市| 定边县| 高尔夫| 昆山市|