changing sys & system password

[Ablakios]

What is the step by step way of changing the INTERNAL & SYSTEM password? it is through ORADIM? or
ORAPWD utility?

Please advise ASAP.
Thanks

[rohitsn]

Hi,
INTERNAL is a proxy user which in turns comes to be SYS.In order to change the password of INTERNAL and SYS user perform the following steps

1.Remove the old password file which resides in
$ORACLE_HOME/database directory.

2.With the orapwd utility create a password file which contains the password for INTERNAL and SYS.

orapwd file=c:\orant\dbs\passwd.ora password= entries=10

To change the password for SYSTEM give the following command

Connect as sys
sql>alter user system identified by ;

In case of any help please be free to ask me at rohitsn@altavista.com

Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[julian]

2.With the orapwd utility create a password file which contains the password for INTERNAL and SYS.

This is not exactly true, in fact if I have to say, right or wrong, I would say wrong.

The password file is meant for INTERNAL not for SYS. Let me explain it with an example:

You have the default password for SYS change_on_install. Then you connect as SYS:

$sqlplus /nolog
SQL>connect sys/change_on_install
Connected.

Now create the password file:

$orapwd file=orapwABC password=xyz entries=3

Now, try again:

$sqlplus /nolog
SQL>connect internal
Connected.

Startup the instance

SQL>connect sys/change_on_install
Connected.

connect sys/change_on_install as sysdba
Now you get ORA-01017: invalid password

The difference is that SYS connecting as SYSDBA is like INTERNAL, they both use the password file, SYS however, uses its own password.

[Ablakios]

Thanks for all the input but can someone who really did change his/her password and infact has confirmed password changed.
Idid follow the step with ORAPWD. utility and ORADIM but when I connect with internal /oracle I expect login error not to be gracefully connected.

Please send me a step by step to clean cut procedure that works. I REALLY NEED YOUR HELP...please
Thanks

[julian]

If you are in the DBA's group, you will not be prompted for password when you connect as INTERNAL. Even if you have the password file. I assumed you knew that.

[Ablakios]

Yes I know that. but the point I'm trying to make over is that when you change internal password with ORAPWD utility it shouldn't connect you gracefully just by typing INTERNAL.
I renamed the PWD_SID in the orant bin and create a password file and connected with both new password and INTERNAL/ORACLE.

I expect to error login when entered
SQLPLUS> INTERNAL/ORACLE

[julian]

Originally posted by Ablakios
Yes I know that. but the point I'm trying to make over is that when you change internal password with ORAPWD utility it shouldn't connect you gracefully just by typing INTERNAL.
I renamed the PWD_SID in the orant bin and create a password file and connected with both new password and INTERNAL/ORACLE.

I expect to error login when entered
SQLPLUS> INTERNAL/ORACLE

Well, that's not the case with INTERNAL :-) Upgare to 9i, there you will not have that problem. There is no INTERNAL.

In 9i, you cannot even log in from client's SQL*PLUS as SYS. Has anyone noticed that in 9i?

[pando]

in 9i you need sysdba to access the catalog as well

[vijay8282]

I am running SAP on Oracle 8i/NT

My SAP admn wans me to change the oracle standard passwords. I understand that I can change the passwords as

SYSTEM
SQLPLUS>connect SYSTEM/manager
connected

SQLPLUS>password
New password - i'll enter new password


SYS
SQLPLUS>connect SYS/change_on_install
connected

SQLPLUS>password
New password - i'll enter new password


INTERNAL
I need to create new pwd file or Can i change like as i do with system.


help me...with method

[julian]

help me...with method

You should try to understand that login as SYS is not the same as INTERNAL. INTERNAL is same as SYS as SYSDBA. And if you are in the DBA's group you will not be propted for password, you don't need one. That is how Oracle works.

Since you use NT, I suggest you comment out the line SQLNET_AUTHENTICATION_SERVICES in your sqlnet.ora file. Then you will be asked for password.