Prev: Need example for 11g's new response file db_install.rsp
Next: Distinct values
From: CS on 4 Aug 2010 09:33
Hi

I reinstalled my database Oracle XE and now when I run it
/etc/init.d/oracle-xe start,
It hangs for a few minutes on : "Starting Oracle Net Listener... " and when
trying to connectto database i get ORA-12505: TNS: listener could not
resolve SID given in connection description.

Any ideas ?

From: gazzag on 4 Aug 2010 09:40
On 4 Aug, 14:33, "CS" <c...(a)gryftechnologia.com> wrote:
> Hi
>
> I reinstalled my database Oracle XE and now when I run it
> /etc/init.d/oracle-xe start,
> It hangs for a few minutes on : "Starting Oracle Net Listener... "  and when
> trying to connectto database i get ORA-12505: TNS: listener could not
> resolve SID given in connection description.
>
> Any ideas ?

Can you post your ${ORACLE_HOME}/listener.ora and ${ORACLE_HOME}/
tnsnames.ora please?

-g
From: joel garry on 4 Aug 2010 11:48
On Aug 4, 6:33 am, "CS" <c...(a)gryftechnologia.com> wrote:
> Hi
>
> I reinstalled my database Oracle XE and now when I run it
> /etc/init.d/oracle-xe start,
> It hangs for a few minutes on : "Starting Oracle Net Listener... "  and when
> trying to connectto database i get ORA-12505: TNS: listener could not
> resolve SID given in connection description.
>
> Any ideas ?

$ oerr ora 12505
12505, 00000, "TNS:listener does not currently know of SID given in
connect descriptor"
// *Cause: The listener received a request to establish a connection
to a
// database or other service. The connect descriptor received by the
listener
// specified a SID for an instance (usually a database instance) that
either
// has not yet dynamically registered with the listener or has not
been
// statically configured for the listener. This may be a temporary
condition
// such as after the listener has started, but before the database
instance
// has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which instances are currently known by the listener by
executing:
// lsnrctl services <listener name>
// - Check that the SID parameter in the connect descriptor specifies
// an instance known by the listener.
// - Check for an event in the listener.log file.

Watch the case of the service name, and the ports you use, too.

What connect string are you using? My guess is you wound up with a
different SID than you had before.

Do the appropriate ps on your system to see all processes, grepping
for lsnr, in case you managed to wind up with multiple listeners
somehow. Also grep for dbw, in case you wound up with multiple
instances somehow. Or none at all.

What does tnsping tell you?

jg
--
@home.com is bogus.
“This is John, I’m a little too depressed to take your call today.
Please leave your message at the gunshot.”
http://www.nytimes.com/2010/07/28/arts/design/28callahan.html
From: CS on 5 Aug 2010 04:54
# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = hpserwer)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

# tnsnames.ora Network Configuration File:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hpserwer)(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)
)
)



Uzytkownik "gazzag" <gareth(a)jamms.org> napisal w wiadomosci
news:3ba0cbb3-e8f0-4b81-b875-e14edd884b82(a)c10g2000yqi.googlegroups.com...
On 4 Aug, 14:33, "CS" <c...(a)gryftechnologia.com> wrote:
> Hi
>
> I reinstalled my database Oracle XE and now when I run it
> /etc/init.d/oracle-xe start,
> It hangs for a few minutes on : "Starting Oracle Net Listener... " and
> when
> trying to connectto database i get ORA-12505: TNS: listener could not
> resolve SID given in connection description.
>
> Any ideas ?

Can you post your ${ORACLE_HOME}/listener.ora and ${ORACLE_HOME}/
tnsnames.ora please?

-g

From: CS on 5 Aug 2010 05:06
My connect string is:
jdbc:oracle:thin:@localhost:1521:XE (its java aplication runing on
server).

tsnspinf for localhost tell :
Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)

tnsping for address 192.168.1.251 (server adddress) :
Used HOSTNAME adapter to resolve the alias
Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.251)(PORT=1521)))
OK (0 msec)

but tns for service name XE failed:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
hpserwer)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = XE)))
and hangs forever.





Uzytkownik "joel garry" <joel-garry(a)home.com> napisal w wiadomosci
news:c9e03240-df40-4892-885f-87d2d5ea15de(a)y32g2000prc.googlegroups.com...
On Aug 4, 6:33 am, "CS" <c...(a)gryftechnologia.com> wrote:
> Hi
>
> I reinstalled my database Oracle XE and now when I run it
> /etc/init.d/oracle-xe start,
> It hangs for a few minutes on : "Starting Oracle Net Listener... " and
> when
> trying to connectto database i get ORA-12505: TNS: listener could not
> resolve SID given in connection description.
>
> Any ideas ?

$ oerr ora 12505
12505, 00000, "TNS:listener does not currently know of SID given in
connect descriptor"
// *Cause: The listener received a request to establish a connection
to a
// database or other service. The connect descriptor received by the
listener
// specified a SID for an instance (usually a database instance) that
either
// has not yet dynamically registered with the listener or has not
been
// statically configured for the listener. This may be a temporary
condition
// such as after the listener has started, but before the database
instance
// has registered with the listener.
// *Action:
// - Wait a moment and try to connect a second time.
// - Check which instances are currently known by the listener by
executing:
// lsnrctl services <listener name>
// - Check that the SID parameter in the connect descriptor specifies
// an instance known by the listener.
// - Check for an event in the listener.log file.

Watch the case of the service name, and the ports you use, too.

What connect string are you using? My guess is you wound up with a
different SID than you had before.

Do the appropriate ps on your system to see all processes, grepping
for lsnr, in case you managed to wind up with multiple listeners
somehow. Also grep for dbw, in case you wound up with multiple
instances somehow. Or none at all.

What does tnsping tell you?

jg
--
@home.com is bogus.
�This is John, I�m a little too depressed to take your call today.
Please leave your message at the gunshot.�
http://www.nytimes.com/2010/07/28/arts/design/28callahan.html

 |  Next  |  Last
Pages: 1 2
Prev: Need example for 11g's new response file db_install.rsp
Next: Distinct values