Hi.
Oracle 9.2.0.1.0 on redhat 8.0
when starting the database or using sqlplus I get ORA-12154 : TNS: could not resolve service name.
Any ideas?
I have attached my tnsnames.ora and listener.ora below. both are located in $oracle_home/network/admin.
listener.ora:
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=servo)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=po))))
STARTUP_WAIT_TIME_LISTENER =0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=po.workgroup)
(ORACLE_HOME=/oracle/OraHome1)
(SID_NAME=po)))
tnsnames.ora:
po =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = servo)
(Port = 1521)
)
(CONNECT_DATA = (SID = po)
)
)
my database is called po
the server is servo and can be resolved by name.
the databaes domain is workgroup.
Oracle 9.2.0.1.0 on redhat 8.0
when starting the database or using sqlplus I get ORA-12154 : TNS: could not resolve service name.
Any ideas?
I have attached my tnsnames.ora and listener.ora below. both are located in $oracle_home/network/admin.
listener.ora:
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=servo)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=po))))
STARTUP_WAIT_TIME_LISTENER =0
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=po.workgroup)
(ORACLE_HOME=/oracle/OraHome1)
(SID_NAME=po)))
tnsnames.ora:
po =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = servo)
(Port = 1521)
)
(CONNECT_DATA = (SID = po)
)
)
my database is called po
the server is servo and can be resolved by name.
the databaes domain is workgroup.