Home » RDBMS Server » Networking and Gateways » SID
SID [message #309708] Fri, 28 March 2008 09:24 Go to next message
dramos
Messages: 2
Registered: March 2008
Junior Member
HELP!!!

I have the error ORA-28547 when i try to connect to TOAD 8.5.

WHY?


--- TNSNAMES.ORA ---
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dramos.Servinave.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

--- LISTENER:ORA ---
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = dramos.Servinave.local)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

---

Thanks!!!
Re: SID [message #309709 is a reply to message #309708] Fri, 28 March 2008 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
28547, 0000, "connection to server failed, probable Oracle Net admin error"
// *Cause:   A failure occurred during initialization of a network connection
//           from a client process to the Oracle server:  The connection
//           was completed but a disconnect occurred while trying to
//           perform protocol-specific initialization, usually due to
//           use of different network protocols by opposite sides
//           of the connection.  This usually is caused by incorrect
//           Oracle Net administrative setup for database links or external
//           procedure calls.   The most frequent specific causes are:
//           --  The connection uses a connect string which refers
//               to a Heterogeneous Services agent instead of
//               an Oracle server.
//           --  The connection uses a connect string which includes
//               an (HS=) specification.
// *Action:  Check Oracle Net administration in the following ways:
//           --  When using TNSNAMES.ORA or an Oracle Names server, make sure
//               that the client connection to the ORACLE server uses
//               the correct service name or SID.
//           --  Check LISTENER.ORA on the connection end point's host machine
//               to assure that this service name or SID refers
//               to the correct server.
//           --  Confirm in TNSNAMES.ORA or the equivalent service definition
//               that the connect string does NOT contain (HS=).
//
Re: SID [message #309710 is a reply to message #309709] Fri, 28 March 2008 09:35 Go to previous messageGo to next message
dramos
Messages: 2
Registered: March 2008
Junior Member
I am sure that i'm not using Heteregeneous Service. But i don´t sure that client connection to the ORACLE server (local host) uses the correct service name or SID. In fact, what is the correct service name or SID?
Re: SID [message #309742 is a reply to message #309708] Fri, 28 March 2008 11:44 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>In fact, what is the correct service name or SID?
Why are YOU asking us?
Do you think we (TINW) are mindreaders?
Why do YOU expect us to know the SID of YOUR database?

If you are desperate, you could try "ID10T".
Previous Topic: reconfigure of listener port from 1527 to 1521
Next Topic: TNSNAMES.ORA
Goto Forum:
  


Current Time: Thu Dec 05 19:29:18 CST 2024