Re: 9i Enterprise manager - no db restart

TNS-12519 TNS:no appropriate service handler found

Cause: The listener could not find any available service handlers that are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections

Have you set up automatic instance registration for the instance in question?

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"pklosky" <member_at_dbforums.com> wrote in message
news:3bbc7c1f$3_at_usenetgateway.com...


> Howard,

>

> Thanks for the suggestion to set up the Management Server. I have no

> idea what this would involve, but suspect there is some document or book

> somewhere that describes it.

>

> As far as the need for a Management server, my experience with 8.1.6 is

> that it is not required, at least in the scenarios I've run. In general,

> I've used it over our LAN to start and stop a second host. About the

> only requirement I've found is that the "listener" must be running,

> sometimes requiring a "lsnrctl start" command.

>

> Ron,

>

> Thanks for the "connect sys/xxx as sysdba" command. This is a help, as

> it allows me to connect as sys. Previously, there was no requirement to

> have the "as sysdba" clause in order to simply connect as sys, which was

> a help in granting execute on sys.dbms_pipe, for example.

>

> As far as the startup goes, I'm still having trouble. The problem looks

> to be that the listener will not establish a service handler. About the

> only commands I know with the listener are "lsnrctl stop/start/status"

>

> SQL> shutdown

> Database closed. Database dismounted. ORACLE instance shut down.

> SQL> startup

> ORACLE instance started. ORA-12519: TNS:no appropriate service

> handler found

>

> Peter

>

>

>

> --

> Posted via dBforums

> http://dbforums.com

>