Oracle/oracle 登陆到oracle用户中后,在提示符下打入以下命令:
bash-2.05$sqlplus /nolog
正常启动:
sql>conn sys/sys as sysdba;
sql>startup
打开监听程序
bash-2.05$lsnrctl
LSNRCTL> start
查找tns文件
bash-2.05$ cd $HOME/product/9.2/network/admin/ tnsnames.ora
tns:
WAPGW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wapgw)
)
)
使用pl/sql developer 登陆:
用户名:sys
密码:sys
数据库: wapgw
Connect as :sysdba