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 ?

On 4 Aug, 14:33, "CS" <c... (AT) gryftechnologia (DOT) com> wrote:
Can you post your ${ORACLE_HOME}/listener.ora and ${ORACLE_HOME}/
tnsnames.ora please?

-g

On Aug 4, 6:33*am, "CS" <c... (AT) gryftechnologia (DOT) com> wrote:
$ 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/ar...8callahan.html

# 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 (AT) jamms (DOT) org> napisal w wiadomosci
news:3ba0cbb3-e8f0-4b81-b875-e14edd884b82 (AT) c10g2000yqi (DOT) googlegroups.com...
On 4 Aug, 14:33, "CS" <c... (AT) gryftechnologia (DOT) com> wrote:
Can you post your ${ORACLE_HOME}/listener.ora and ${ORACLE_HOME}/
tnsnames.ora please?

-g

My connect string is:
jdbcracle: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=))(ADDRES S=(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=))(ADDRES S=(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 (AT) home (DOT) com> napisal w wiadomosci
news:c9e03240-df40-4892-885f-87d2d5ea15de (AT) y32g2000prc (DOT) googlegroups.com...
On Aug 4, 6:33 am, "CS" <c... (AT) gryftechnologia (DOT) com> wrote:
$ 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/ar...8callahan.html

I solved the problem I had a bad entry in / etc / hosts
I had
192.168.1.251 hpserver
and should be
192.168.1.251 hpserwer

whole day wasted because v instead of w.

THX for answers

U¿ytkownik "CS" <cs (AT) gryftechnologia (DOT) com> napisa³ w wiadomo¶ci
news:4c596c53$0$19161$65785112 (AT) news (DOT) neostrada.pl...

On 5 Aug, 12:31, "CS" <c... (AT) gryftechnologia (DOT) com> wrote:
Or should the entry in tnsnames.ora be "hpserver"? Anyway, no matter;
glad you fixed the problem.

Yes, computers are funny like that

-g

On Aug 5, 4:31*am, "CS" <c... (AT) gryftechnologia (DOT) com> wrote:



I've wasted entire days on VW's, fer sure :-)

jg
--
@home.com is bogus.
What database are you in? http://news.cnet.com/8301-31921_3-20012583-281.html

On 5 Aug, 12:38, gazzag <gar... (AT) jamms (DOT) org> wrote:
I would suggest that you change the entry in /etc/hosts back to what
it was. You might screw something else up. Surely you'd be better
off changing tnsnames.ora instead?

-g