在终端里以oracle用户登陆;
lsnrctl start 启动监听器
svrmgrl 进入管理器
connect internal 连接用户
startup 启动数据库
exit 退出
sqlplus 进入sqlplus
lsnrctl start 启动监听器
svrmgrl 进入管理器
connect internal 连接用户
startup 启动数据库
exit 退出
sqlplus 进入sqlplus
把错误信息列出来。
[oracle@xxxx oracle]$ lsnrctl start
LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 03-NOV-2003 18:34:01
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /u01/app/oracle/product/8.1.7/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lhf2004)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Start Date 03-NOV-2003 18:34:02
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /u01/app/oracle/product/8.1.7/network/log/listener.logThe listener supports no services
The command completed successfully[oracle@xxxx oracle]$ sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Nov 3 18:34:34 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: system/manager@orcl
ERROR:
ORA-12154: TNS:could not resolve service name
lsnrctl start 启动监听器
2、
svrmgrl 进入管理器
connect internal 连接用户
startup 启动数据库
exit 退出
3、
sqlplus 进入sqlplus老大,你仅仅启动了监听器,还没有启动数据库!!!
哎 ~ oracle 太复杂了~