Re: can't logon as SYSDBA ....

In order for you to logon as SYSDBA on Oracle 8.0.4, there are few things that you need to set. First in the INIT.ORA file you need to have the line remote_login_password=exclusive. If you running under the UNIX platform, you need to create the password file under the $ORACLE_HOME/dbs directory. To create the passowrd file run the following command.

   $> orapwd file=$ORACLE_HOME/dbs/orapw<SID> password=<password>

      entries=<no.of users who will be granted SYSDBA or SYSOPER>

Restart your database, connect as SYSTEM or SYS, grant SYSDBA or SYSOPER to the users.

In article <75l8bh$h0$1_at_sharon.cilea.it>,   "Diego Peroni" <peroni_at_cefriel.it> wrote:
> Anyone can help me to logon in Oracle 8.0.4 as SYSDBA or SYSOPER ?
> I'm able to connect as normal user without big problems, but i can't shut
> down or start up Oracle istance (mount, no mount, open) as normal user.
>
> In Enterprice Manager File|Preference I've changed my role to SYSDBA but
> when I try to connect as SYSDBA it's impossible
>
> In Security Manager I've given all privileges to the normal user ....but
> nothing
>
> I've changed the pass to the SYS user but nothing to do when I try to
> connect.... I can connect as SYS user just as normal user......WHY?
>
> Please Help me
> Thanks,
> Diego
>
>

--
Oscar Koay
Systems Engineer
ISC Technology Sdn. Bhd.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 19:33:04 CST