- 论坛徽章:
- 0
|
大家好!我的系统环境是red hat linux9
数据库:oracle9.2.0.4
现在除了system,sys用户外我又建立了一个用户hat,建立了它的表空间web,
同时给 用户授权grant dba,connect, resource to web。
但是有个问题想请教大家
我使用sqlplus /nolog
conn /as sysdba
startup/shutdown immediate都是正常的。
但是我想使用sqlplus "web/web@boss
就会报错,ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor
下面是我的tnsname.ora 和listener.ora
请大家指教一下为什么使用 sqlplus "web/web@boss"不行。
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
BOSS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.44)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = boss)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rainbowbar)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0//network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0/)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rainbowbar)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
) |
|