Monday 10 June 2013


Enterprise Manager configuration in R12
  1. xhost +
  2. xauth list
  3. su – orabr12
  4. xauth add
  5. lsnrctl start br12
  6. sqlplus '/as sysdba' startup
  7. emca -deconfig dbcontrol db -repos drop
  8. emca -config dbcontrol db -repos create
Sid – br12
Port – 1619
Sys pwd – sys
DBSNMP pwd - “A” or “a”
Sysman pwd – sys
leave optional things

SQL> select file_name, bytes, autoextensible, maxbytes from dba_data_files where tablespace_name='SYSAUX';

FILE_NAME
--------------------------------------------------------------------------------
BYTES AUT MAXBYTES
---------- --- ----------
/br12/d02/oracle/R12I/db/apps_st/data/sysaux01.dbf
1391460352 NO 0

SQL> ALTER TABLESPACE SYSAUX ADD DATAFILE '/br12/d02/oracle/R12I/db/apps_st/data/sysaux02.dbf' SIZE 1G AUTOEXTEND ON NEXT 200M MAXSIZE 1G;

Tablespace altered.

SQL> EXIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[orabr12@ebs ~]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Dec 6, 2012 6:00:12 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: br12
Listener port number: 1619
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /br12/d02/oracle/R12I/db/tech_st/11.1.0

Local hostname ................ ebs.xxxx.com
Listener port number ................ 1619
Database SID ................ br12
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y

Dec 6, 2012 6:56:14 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /br12/d02/oracle/R12I/db/tech_st/11.1.0/cfgtoollogs/emca/br12/emca_2012_12_06_18_56_00.log.
Dec 6, 2012 6:56:14 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Dec 6, 2012 6:56:15 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 6, 2012 7:05:07 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 6, 2012 7:05:08 PM

[orabr12@ebs ~]$ emca -repos create

STARTED EMCA at Dec 6, 2012 7:19:38 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: br12
Listener port number: 1619
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 6, 2012 7:19:52 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /br12/d02/oracle/R12I/db/tech_st/11.1.0/cfgtoollogs/emca/br12/emca_2012_12_06_19_19_38.log.
Dec 6, 2012 7:19:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 6, 2012 8:13:50 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 6, 2012 8:13:53 PM

[orabr12@ebs ~]$ emca -config dbcontrol db

STARTED EMCA at Dec 7, 2012 11:47:19 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: br12
Listener port number: 1619
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /br12/d02/oracle/R12I/db/tech_st/11.1.0

Local hostname ................ ebs.xxxx.com
Listener port number ................ 1619
Database SID ................ br12
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 7, 2012 11:47:41 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /br12/d02/oracle/R12I/db/tech_st/11.1.0/cfgtoollogs/emca/br12/emca_2012_12_07_11_47_19.log.
Dec 7, 2012 11:47:44 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Dec 7, 2012 11:49:26 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Dec 7, 2012 11:49:31 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Dec 7, 2012 11:49:31 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Dec 7, 2012 11:50:02 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Dec 7, 2012 11:50:02 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Dec 7, 2012 11:50:23 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Dec 7, 2012 11:50:23 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Dec 7, 2012 11:51:03 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Dec 7, 2012 11:51:03 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://ebs.yantro.com:1158/em <<<<<<<<<<<
Dec 7, 2012 11:51:09 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /br12/d02/oracle/R12I/db/tech_st/11.1.0/ebs.yantro.com_br12/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 7, 2012 11:51:09 AM

[orabr12@ebs ~]$


While starting database and listener using EM it shows following error messages.

Error Message

RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)

Solution :
-------------

[root@ebs ~]# cd /br12/d02/oracle/R12I/db/tech_st/11.1.0/
[root@ebs 11.1.0]# sh root.sh
[root@ebs 11.1.0]# cd bin/
[root@ebs bin]# ll nmo
-rwsr-s--- 1 root dba 23844 May 26 2012 nmo
[root@ebs bin]#

Now everything perfect.

It Shows error message in EM main page

Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)

SQL> select * from dba_users where username='DBSNMP';

SQL> alter user DBSNMP identified by welcome ;

User altered.

SQL> alter user DBSNMP account unlock;

User altered.

SQL> connect dbsnmp/welcome;
Connected.
SQL> connect sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"

Then u can check like the below through EM

Monitoring configuration → Give the correct newly created password(welcome) details of dbsnmp user → test connection

Ref : http://myoracleguide.com/msa/ID%20352585.1%20Grid%20Control%20Shows%20DBSNMP%20Account%20Locked.htm

No comments:

Post a Comment