| TNS ***ERROR*** on an AIX pltform [message #348350] |
Tue, 16 September 2008 08:34  |
urian
Messages: 7
Registered: January 2008
Location: Albania
|
Junior Member |
|
|
Hi guys,
I have build a database and created a listener called LISTENER
Now I can access the DB via sqlplus only in this way
ORACLE_SID=DMAN
export ORACLE_SID
and then run the sqlplus.
but I can't connect as usual when I'm within the sqlplus or connect from anothe computer
conn sys/oracle@DMAN as sysdba
**ERROR**
TNS:listener does not currently know of service requested in connect descriptor
my LISTENER.ORA
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oradata/app/oracle)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
SID_DESC =
(SID_NAME = mgwextproc)
(ENVS = EXTPROC_DLLS=/oradata/app/oracle/lib32/libmgwagent.so,
LIBPATH=/oradata/app/oracle/jdk/jre/bin:/oradata/app/oracle/jdk/jre/bin/classic:
/oradata/app/oracle/lib32)
(ORACLE_HOME = /oradata/app/oracle)
(PROGRAM = extproc32)
)
and my TNSNAMES.ORA
DMAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DMAN)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
MGW_AGENT =
(DESCRIPTION=
(ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC)(KEY=EXTPROC)))
(CONNECT_DATA= (SID=mgwextproc) (PRESENTATION=RO)))
I cant even connect from an other computer?????
please can you help me
Thank YOU,
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
