Re: beginner: login to closed base

From: Ed Stevens <nospam_at_noway.nohow>
Date: Tue, 12 Oct 2004 11:46:11 -0500
Message-ID: <3e2om057napfu2gh0i9e4fk275o7u9iini@4ax.com>

On Tue, 12 Oct 2004 18:34:12 +0200, vertigo <ax178_at_wp.pl> wrote:

>Hello
>Oracl 9.2. I created database test. I configured & started listener.
>I want to start test instance. I need to login using SQLPlus, and type
>STARTUP command. But my problem is that i can not login to that instance
>because listener do not see it (because it is not started yet).
>I tried:
>sqlplus sys/passwd_at_test
>and received:
>ORA-12500: TNS: can not find dedicated server process.
>
>How can i login to closed database to STARTUP it ?
>
>Thanx
>Michal

OS? Assuming some flavor of Windoze ... and assuming that you are logged on to the machine with a user id that is a member of the local group ORACLE_DBA

C:> set oracle_sid=test
C:> sqlplus "/ as sysdba" Received on Tue Oct 12 2004 - 11:46:11 CDT