Re: The internal password!

Hi,

    Thank you for help. As I know, the internal passwd is created when the instance created by the oradimxx.exe. When the instance is created using the line mode of instance manager, there is a parameter -initpwd. If I forgot the passwd, how can I change the internal passwd. Do it work if I set the remote_login_passwordfile to null?

    TIA Man Yeung
yngm_at_chowsangsang.com

Vsevolod Afanasjev wrote:

> No, the password for INTERNAL is not CHANGE_ON_INSTALL.
> This is password for SYS which is not the same as INTERNAL.
>
> As SYS, you can log in in two different ways:
>
> 1. CONNECT SYS/CHANGE_ON_INSTALL
> 2. CONNECT SYS/ORACLE AS SYSDBA
>
> The way #1 gives you all standard SYS privileges
> defined in GRANT (system privilege) is SQL Reference Manual.
>
> The way #2 gives some additional privileges, namely
> the right to:
> STARTUP
> SHUTDOWN
> CREATE DATABASE
> Alternatively, these privileges are available after
>
> CONNECT INTERNAL/ORACLE
>
> The password ("ORACLE") is default on some systems
> (Personal Oracle) where during the installation database is
> not created. Instead, the database files are simply being
> copied from the installation media (CD). (The password is stored
> in SYSTEM tablespace).
>
> If you system is based on "normal" installation, i.e.
> CREATE DATABASE is actually executed, then you should be able
> to specify this password during the installation.
>
> Finally, on UNIX you need to be a member of dba group.
>
> You need to look in OS-dependent documentation, i.e.
> Getting started on Windows95/NT etc.
>
> On Windows, Oracle is typically using password file
> (hidden file in ORACLE_HOME\database, you can see it with
> attrib). Look for values like ORA_PWD_FILE (or ORA_SID_PWD_FILE)
> in Windows registry. This file is greated during installation
> *before* database creation.
>
> However, you cannot recover the password from the file.
> If you already installed Oracle and don't know the password,
> try to login without password (i.e. CONNECT INTERNAL),
> or try ORACLE. If this does not help, you neet to re-install
> it.
>
> Amarendra B Nettem wrote:
> >
> > Man wrote:
> > >
> > > Hi,
> > > Can anyone tell me how to change the password of internal in Oracle
> > > Database. I have search the technical doc Oracle sent me and can find the
> > > answer.
> > >
> > > TIA
> > >
> > > Man Yeung
> > > yngm_at_chowsangsang.com
> >
> > The password for internal is 'CHANGE_ON_INSTALL'.
> > --
> > **********************************************
> >
> > AMARENDRA B NETTEM
> > Certified Oracle DBA (OCP)
> > Whittman-Hart Inc.,
> > Chicago, IL 60656.
> >
> > **********************************************
Received on Wed Apr 01 1998 - 00:00:00 CST