Re: 9i Enterprise manager - no db restart

Are are databases registering with the listener rather than being manually defined in listener.ora. IIRC, when you shutdown the database it will de-register with the listener and you will no longer be able to it connect over the network.

Joe.

"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
>
Received on Fri Oct 05 2001 - 12:20:04 CDT