其实不需要登录OMS就可以进SQLPLUS的,用DBA previlege就可以,不过注意:
server name应该用你的SID,一般你安装后建立数据库时应该设置成与数据库名相同。
在系统的service 里,你必须启动OracleOraHomeTNSlListener和OracleServiceXXXDB两个services.
再试试?????
如不行,
我猜你的问题源于这几中可能:
1, lisener file不正确,在OraHome---Network----Admin----Listener.ora (还有tnsname.ora里)有这样的format:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pacificsun)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = pacificsun)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = XXXdb) ' XXXdb 为你的 (more...)
Sorry, typo error . The 2 hosts of above
should not be Pacificsun which is my own PC name.
just change them to your own pc name.
just change them to your own pc name.