Wednesday, May 25, 2011

Change wallet password using orapki

This task can be performed through OWM (Oracle Wallet Manager)

[oracle@vmxdb01 wallet]$ ls -ltr
total 12
-rw-------. 1 oracle oinstall 1838 May 25 20:21 ewallet.p12
-rw-------. 1 oracle oinstall 1915 May 25 20:21 cwallet.sso
-rw-r--r--. 1 oracle oinstall 9 May 25 20:22 password.txt
[oracle@vmxdb01 wallet]$ orapki wallet change_pwd -wallet $ORACLE_HOME/wallet
Oracle PKI Tool : Version 11.2.0.2.0 - Production
Copyright (c) 2004, 2010, Oracle and/or its affiliates. All rights reserved.

Enter wallet password: Easy2rem

New password:
Enter wallet password: Never4get

[oracle@vmxdb01 wallet]$
[oracle@vmxdb01 wallet]$ ls -ltr
total 12
-rw-r--r--. 1 oracle oinstall 9 May 25 20:22 password.txt
-rw-------. 1 oracle oinstall 1838 May 25 20:25 ewallet.p12
-rw-------. 1 oracle oinstall 1915 May 25 20:25 cwallet.sso
[oracle@vmxdb01 wallet]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed May 25 20:26:12 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 627732480 bytes
Fixed Size 1345992 bytes
Variable Size 452986424 bytes
Database Buffers 167772160 bytes
Redo Buffers 5627904 bytes
Database mounted.
Database opened.
SQL> select count(*) from e;

COUNT(*)
----------
107

SQL> exit