Re: Remote startup

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. After all, I can shut it down.
>
>vlad
>
>
>
>
>
Received on Tue Mar 11 2003 - 02:31:18 CST