Re: logon as SYSDBA question

Yes, when you log in with AS SYSDBA, the password is different As far as I can remember, Oracle Installer asks to specify this password during installation, doesn't it? This password is also known as password for INTERNAL. You need this password to perform startup and shutdown.

If you are absolutely sure that you did NOT specify any password during installation, try "oracle". What kind of Oracle do you have? Is it Oracle Server and Personal Oracle? The difference is that while Oracle Server actually creates database during installation (i.e. executes CREATE DATABASE), Personal Oracle simply copies database files from the installation media, so you cannot specify the password.

You can also try to play with parameters in the Windows Registry. Start Registry editor (regedit.exe ?) and search for ORACLE_HOME, ORACLE_SID.
You'll find some interesting parameters there.

Finally: please note that Oracle on NT is using password file (hidden file in the same directory as initSID.ora and datafiles). Vsevolod

hxn wrote:

> Just finished installing Oracle 8.0.4 on NT 4 box -
> when i logged in from svrmgr30:
> > connect sys/change_on_install
> it works ok - but
> >connect sys/change_on_install as SYSDBA
> returned the error: invalid userid/passwd
>
> How do I log in as SYSDBA (or SYSOPER) ?
>
> Thanks
>
> Henry
Received on Fri May 29 1998 - 10:43:22 CDT