Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to change the ORACLE ID's password without login to ORACLE DATABASE?

Chen Yingjie
Frequent Advisor

How to change the ORACLE ID's password without login to ORACLE DATABASE?

Can someone advise me how to do that?

Someone advise me if we install the SQL-PLUS to our client PC, we can do that.

Is there another way?
7 REPLIES
Zafar A. Mohammed_1
Trusted Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

From your client PC, connect to server thru telnet and change the passowrd.

If the Oracle ID is Authenticated User then just, telnet to any normal user then change the unix password using passwd command.

If you need more then please write your problem.


Thanks
Zafar
Brian Crabtree
Honored Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

You can also change passwords using OEM with the security module. Connecting through 'sqlplus' and altering the user to change the password is probably the easiest.

Brian
T G Manikandan
Honored Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

To change the ID password without logging into the database,I dont think it is possible.
Anyway,any tool you need to login into the database for any changes in the structure.

If your Qs was to understand like
you are looking to change the password of the user from the PC sqlplus client instead of logging into the server machine which holds the Oracle database.

If that is the case then you can install the SQL-plus client and Net8 utilities on the PC.

Configure the Net8 to connect to the database from the PC.
You can do that by using Network administration menu and choosing the Net8 configuration Assistant.

From the new window you can select the "local net services configuration" to confifure the connection to the database.

Then use SQL-plus to connect to the database and then use

alter user identified by
to change the password
twang
Honored Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

If I understand that you are trying to change oracle account password. It is impossible for you to change password without logging into the database.
Such as OEM, SQLPlus whatever tool you use. You must connect the database and alter user to change password. Oracle has not advised any method to amend it's logical content when the database is down.

Indira Aramandla
Honored Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

Hi,

When you say "ORACLE ID", normally the oracle user (UNIX account) i which belongs to a DBA group is the oracle software (RDBMS) owner. And secondly there will be an oracle account in the database when you create a user called oracle. But the authentication depends on how you created either operation system authenticated or identified by password.

Now if you haev the oracle account operation system authenticated, you need not log on to the database to change the account password. Change it at the opration system level just like any unix user account.

If the Oracle user in the database is identified by a password, then you have to login as system through SQLPLUS or svrmgrl ---> connect....> internal and then change the password.

I hope this helps. Sorry for the delayed reply, office was closed for easter break.

Never give up, Keep Trying
Steven E. Protter
Exalted Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

Strict interpretation of your question. You can't. You must use sqlplus or svrmgl in some form to change an oracle password in the database.

You can telnet to the box running the oracle database. It has a version of sqlplus installed as well.

Then its

sqplus internal

alter user oracle identified by password

You're done.

If by chance you're talking about the OS password for the oracle user, the command is passwd

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Tim Sanko
Trusted Contributor

Re: How to change the ORACLE ID's password without login to ORACLE DATABASE?

Oracle password

Well there are several ways to do this.

Question one: does the oracle database use system or database verification. if system level database verification:
1. login as root,
2. passwd oracle

Did you mean the password for oracle users: sys, system, etc. these will have to be changed from within the database. sqlplus or svrmgrl
after logging in as the
user

you would

alter sys identified by .

Tim