Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Remote startup
Yep, that's it. I guess I better read the whole Net Services Administrator's
Guide to get myself familiar with all the parameters and configurations.
Thanks a lot,
vlad
"Patrice Castet" <patrice.castet@___nospaaaaam____in-fusio.com> wrote in
message news:3e6d9e3f.691232609_at_read.news.fr.uu.net...
> it is probably you don't have the right configuration in your
> listener.ora file, so when started the database register itself into
> the listener process, therefore you can reach it.
> As it is probably not statically declared in listener.ora file, you
> can't log in once stopped.
> It would explain this behaviour.
>
>
> On Tue, 11 Mar 2003 07:00:32 GMT, "vlad" <bulk_at_sfatcu.com> wrote:
>
> >Hello.
> >
> >I'm using Oracle 9.2 on Windows 2000. I'm trying to start the database
> >remotely. However, I'm finding that I am not able to connect to a
database
> >that's not at least mounted. Here's some output from a console on the
remote
> >computer:
> >
> >SQL> connect vlad/pass_at_vlad01 as sysdba
> >Connected.
> >SQL> shutdown immediate
> >Database closed.
> >Database dismounted.
> >ORACLE instance shut down.
> >SQL> connect vlad/pass_at_vlad01 as sysdba
> >ERROR:
> >ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> >descriptor
> >Warning: You are no longer connected to ORACLE.
> >SQL>
> >
> >Once I shut it down, I'm not able to connect any more. I have to go the
> >database server, and do this:
> >
> >SQL> connect vlad/pass as sysdba
> >Connected to an idle instance.
> >SQL> startup mount
> >ORACLE instance started.
> >
> >Total System Global Area 72,424,008 bytes
> >Fixed Size 453,192 bytes
> >Variable Size 50,331,648 bytes
> >Database Buffers 20,971,520 bytes
> >Redo Buffers 667,648 bytes
> >Database mounted.
> >SQL>
> >
> >Only now (after mounting the database) can I connect remotely:
> >SQL> connect vlad/pass_at_vlad01 as sysdba
> >Connected.
> >SQL>
> >
> >Is that the appropiate behavior? Seems like a bummer not to be able to
start
> >the database remotely. Afterauto, I can shut it down.
> >
> >vlad
> >
> >
> >
> >
> >
>
Received on Tue Mar 11 2003 - 23:56:13 CST