ORA-01033:ORACLE initialization or shutdown in progress. 或 ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor 这两个错误是在你什么操作的时候出现的?你说的本地服务名是指用net assistant或者net manager配置的那个本地服务名吗?如果是的话,为什么联本地数据库还要配置本地服务名呢?
提示:实例启动不了。 但数据库服务和监听服务已启动。(这是怎么回事)在sqlplus中就是连不上。启动不了。一连接就出现一下错误:ORA-01033:ORACLE initialization or shutdown in progress. 或 ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor
当然是服务器,ORA-12514错误是什么意思,是不是无法处理参数,可我参数是对的
TNS TNS-12514 TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptorCause: The SERVICE_NAME in the CONNECT_DATA was not found in the listener's tables.Action: Check to make sure that the SERVICE_NAME specified is correct.
如果非要配置的话,你可以把
tnsnames.ora
listener.ora
sqlnet.ora
都贴出来,让大家看看
全局:web.domain
SID : web在没有局域网的情况下,无法正常连接数据库,INSTANCE无法装载。我将所有HOST改为了127.0.0.1或主机名,都不行。大家请帮帮忙!
2。 检查
tnsnames.ora
listener.ora
sqlnet.ora HOST
3。检查服务线程中的数据库是否已经启动
4。svrmgrl
connect internal
startup mount
alert web open
把listener.ora删掉 不用他 也不用配置
配置tnsnames.ora为
ONE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oneoracle) // 和服务器上的 init 文件中的 SERVICE_NAME 参数值匹配
)
)先启动lsnrctl 再启动实列sql>connect sys@one
tnsnames.ora中的SERVICE_NAME 写错了
改为SERVICE_NAME = one_oracle
或
ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor
这两个错误是在你什么操作的时候出现的?你说的本地服务名是指用net assistant或者net manager配置的那个本地服务名吗?如果是的话,为什么联本地数据库还要配置本地服务名呢?
但数据库服务和监听服务已启动。(这是怎么回事)在sqlplus中就是连不上。启动不了。一连接就出现一下错误:ORA-01033:ORACLE initialization or shutdown in progress.
或
ORA-12514:TNS:listener could not resolve SERVICE_NAME given in connect descriptor
TNS:listener could not resolve SERVICE_NAME given in connect descriptorCause: The SERVICE_NAME in the CONNECT_DATA was not found in the listener's tables.Action: Check to make sure that the SERVICE_NAME specified is correct.