Re: 9i Enterprise manager - no db restart

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