SQL> conn sys/passwd@server as sysdba
已连接。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> 不会啊,可以启动啊把你的报错误的信息写出来
已连接。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> 不会啊,可以启动啊把你的报错误的信息写出来
已连接。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
ORA-12523: TNS: 监听程序未找到适用于客户机连接的例程
SQL>
再:startup pfile='D:\Oracle\admin\jpdb\pfile\INIT.ORA'
同时,建议在svrmgrl下执行!
我连接的是远程,是用Net Configuration Assisant连接的,如果数据库一关闭,Net Configuration Assisant就无法连接了,所以无法起动数据库了,不知怎样操作才好,谢谢大家!
ORACLE 例程已经启动。
ORA-12523: TNS: 监听程序未找到适用于客户机连接的例程
重新連接一次SQL> conn sys/aaa@ora as sysdba
就可以了
TNS-12523 TNS:listener could not find instance appropriate for the client connectionCause: The listener could not find any available (database) instances, that are appropriate for the client connection.Action: Run "lsnrctl services" to ensure that the instance(s) are registered with the listener, and have READY status.
报告错误,监听进程不能解析在连接描述符中给出的SEVICE_NAME
用Net Configuration Assisant测试连接也报告监听进程不能解析在连接描述符中给出的SEVICE_NAME。
# TNSNAMES.ORA Network Configuration File: E:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.112.1.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora)
)
)远程服务器的listener.ora# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server01)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = OEMREP)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = OEMREP)
)
)请问要如何改,或要如何进行操作。
tnsnames。ora改一下:
ORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.112.1.10)(PORT = 1521))
)
(CONNECT_DATA =
# (SERVICE_NAME = ora)
(sid=oemrep)
)
)