oracle 11g 01017,oracle 11G OEM 出现问题 ORA-01017: inv

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

FYI

How to Change DBSNMP Password in Database 10g and 11g Monitored by DB Control [ID 259387.1]

31/05/2012 in 10g OEM Grid Control

Applies to:

Enterprise Manager for Oracle Database – Version: 10.1.0.4 to 11.2.0.1 – Release: 10.1 to 11.2

Enterprise Manager Base Platform – Version: 10.1.0.4 and later [Release: 10.1 and later]

Information in this document applies to any platform.

Purpose

How to change the password of the 10g or 11g Database user DBSNMP when the database is monitored through the DB Control.

Scope and Application

All database administrators using the DB Control to monitor their 10g or 11g Database.

How to Change DBSNMP Password in Database 10g and 11g Monitored by DB Control

To change the password of the user DBSNMP you must strictly follow the steps below, otherwise the 10g or 11g DB Control used to manage your database will not function properly.

Note: For DB Control Release 10.2.0.3 and higher installed on Windows 2008 / Vista, emctl commands may fail with the error “Permission Denied“. Please consult the note below to fix this error:

Document 1164293.1 – Executing Any EMCTL Command on Windows 2008 / Vista Returns “Permission denied” Error

Stop the standalone dbconsole

On Unix – DB Control Release up to 11.1.x

$ export ORACLE_SID=

$ emctl stop dbconsole

On Unix – DB Control Release 11.2.x and higher

$ export ORACLE_SID=

$ export ORACLE_UNQNAME=

$ emctl stop dbconsole

On Windows – DB Control Release up to 11.1.x

Stop the Windows Service OracleDBConsole

Or

Open a DOS Command Window and type

C> set ORACLE_SID=

C> set ORACLE_HOME=

C> cd %ORACLE_HOME%/bin

C> emctl stop dbconsole

On Windows – DB Control Release 11.2.x and higher

Stop the Windows Service OracleDBConsole

Or

Open a DOS Command Window and type

C> set ORACLE_SID=

C> set ORACLE_UNQNAME=

C> set ORACLE_HOME=

C> cd %ORACLE_HOME%/bin

C> emctl stop dbconsole

Check that the DB Control is stopped

On Unix

$ emctl status dbconsole

On Windows

Check the status of the Windows Service OracleDBConsole

Or

Open a DOS Command Window, cd to the database $ORACLE_HOME\bin and type

C> emctl status dbconsole

Connect to the database as a user with DBA privilege with SQL*Plus and execute

SQL> alter user dbsnmp identified by ;

Check the new password

SQL> connect dbsnmp/[@database_alias]

Go to $ORACLE_HOME/host_sid/sysman/emd

Save the file targets.xml to targets.xml.orig

Edit the file targets.xml with your favorite texteditor

Search for the line:

” encrypted=”TRUE“>

Replace the encrypted value by the new password value

Replace TRUE by FALSE

Restart the standalone dbconsole

On Unix – DB Control Release up to 11.1.x

$ export ORACLE_SID=

$ emctl start dbconsole

On Unix – DB Control Release 11.2.x and higher

$ export ORACLE_SID=

$ export ORACLE_UNQNAME=

$ emctl start dbconsole

On Windows – DB Control Release up to 11.1.x

Start the Windows Service OracleDBConsole

Or

Open a DOS Command Window and type

C> set ORACLE_SID=

C> set ORACLE_HOME=

C> cd %ORACLE_HOME%/bin

C> emctl start dbconsole

On Windows – DB Control Release 11.2.x and higher

Start the Windows Service OracleDBConsole

Or

Open a DOS Command Window and type

C> set ORACLE_SID=

C> set ORACLE_UNQNAME=

C> set ORACLE_HOME=

C> cd %ORACLE_HOME%/bin

C> emctl start dbconsole

Check that the password has been encrypted

Edit the file targets.xml

Search for the line: ” encrypted=”TRUE”>

Check that the password VALUE is encrypted

Check that the value of ENCRYPTED is TRUE

Note: In case of RAC DB, the dbsnmp password should be changed in targets.xml not only for instances(oracle_database), but also for rac_database target. The file targets.xml needs to be updated on all the RAC Cluster nodes.