Re: ORA-28547 error for the second connection

wuhanchenj_at_gmail.com wrote:
> Hi, all,
>
> Sorry to re-post this question here (original one was on dbforums.com).
> It is something urgent.
>
> Currently, I am facing a very weired problem.
>
> I can use SqlPlus to connect to the DB. However, if I try to use
> "connect" command to switch to another login/password with the same DB,
> I always got:
>
> ORA-28547: connection to server failed, probable Oracle Net admin error
>
> I believe the settings on TNS and Listener are good, otherwise I could
> fail in the first login/connect. Also I have tried to have many sqlplus
> to connect to the DB at almost the time, and it was all good, so no
> session limit problem, just none of them allowed me to do the second
> connect.
>
> Can anyone shed some light? I need to run some complex script, which
> needs to do this "connect" thing several times.
>
> Thank you very much for any tips to save my life.
>
> Ben
>
> P.S.
>
> I am using oracle 10gR2, on windows xp sp2 (32 bits), with AMD Athlon
> 64X2 Dual Core 3800+ (does 64 bits cause the problem?)
>
> == listener.ora ==
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
> (PROGRAM = extproc)
> )
> )
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = mypc.mycompany.com)(PORT = 1521))
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> )
>
> == TNSNames.ora ==
>
> CCMDB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = mydb)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )

Your listener is not configured correctly. There are two options:
1. Don't use the listener.ora file
2. Check out this link:
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200630de90ac4122232d4d3fabf3c173830d32a3.e34Tb34Lb34PbO0Lb3eTahiPc3eRe0?messageID=851061&#851061 Received on Wed Dec 20 2006 - 23:50:45 CST