What is the step by step way of changing the INTERNAL & SYSTEM password? it is through ORADIM? or
ORAPWD utility?
Please advise ASAP.
Thanks
Printable View
What is the step by step way of changing the INTERNAL & SYSTEM password? it is through ORADIM? or
ORAPWD utility?
Please advise ASAP.
Thanks
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
This is not exactly true, in fact if I have to say, right or wrong, I would say wrong.Quote:
2.With the orapwd utility create a password file which contains the password for INTERNAL and SYS.
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.
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
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.
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.Quote:
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
In 9i, you cannot even log in from client's SQL*PLUS as SYS. Has anyone noticed that in 9i?
in 9i you need sysdba to access the catalog as well
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
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.Quote:
help me...with method
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.