Home » RDBMS Server » Networking and Gateways » TNS ***ERROR*** on an AIX pltform (10.2.0.1 IBM AIX V:5.3)
TNS ***ERROR*** on an AIX pltform [message #348350] Tue, 16 September 2008 08:34 Go to next message
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,
Re: TNS ***ERROR*** on an AIX pltform [message #348393 is a reply to message #348350] Tue, 16 September 2008 10:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(HOST = localhost)
Totally problematic.
Re: TNS ***ERROR*** on an AIX pltform [message #348394 is a reply to message #348393] Tue, 16 September 2008 10:55 Go to previous messageGo to next message
urian
Messages: 7
Registered: January 2008
Location: Albania
Junior Member

I changed it but no results
Re: TNS ***ERROR*** on an AIX pltform [message #348395 is a reply to message #348350] Tue, 16 September 2008 10:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: TNS ***ERROR*** on an AIX pltform [message #348505 is a reply to message #348394] Wed, 17 September 2008 01:01 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

stop and start listener services.

And Your database is OPEN stage.?
Previous Topic: tns listener
Next Topic: Oracle Client on Vista Home premium
Goto Forum:
  


Current Time: Fri Mar 29 00:33:10 CDT 2024