Home » RDBMS Server » Enterprise Manager » Unable to view Instance Information (Oracle, 11g R2, Windows)
Unable to view Instance Information [message #666127] Mon, 16 October 2017 23:18 Go to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
I've successfully restored RMAN database backups from Production machine to a standalone machine. But After configuring the EM it is not showing instance information (See attached image). EM Configuration & listener/EM status is appended below. Pl guide me how to rectify this issue. Note: I've changed server/domain for security purpose.


EM Configuration:
1. Shutdown the "OracleDBCosolemyserver" service. 

2. Connect in SQLPLUS as sysdba and shutdown database.
	SHUTDOWN IMMEDIATE;

3. Startup the database as:
	STARTUP RESTRICT;

4. Start the dbconsole service from the services panel. 

5. Open sqlPlus and login as SYSDBA. Execute following sequence of scripts:


	EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
	EXEC sysman.setEMUserContext('',5);
	REVOKE dba FROM sysman;

	DECLARE
	    CURSOR c1 IS
	      SELECT owner, synonym_name name
	      FROM   dba_synonyms
	      WHERE  table_owner = 'SYSMAN';
	BEGIN
		FOR r1 IN c1 LOOP
			IF r1.owner = 'PUBLIC' THEN
				EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
			ELSE 
				EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
			END IF;
		END LOOP;
	END;
	/

	DROP USER mgmt_view CASCADE;
  
	DROP ROLE mgmt_user;
  
	DROP USER sysman CASCADE;
  
	ALTER SYSTEM DISABLE RESTRICTED SESSION;

	alter user dbsnmp identified by MANAGER;

6. Carefully edit following commands by changing host name and passwords and run in Command Prompt:

	D:\app\hashmi\product\11.2.0\dbhome_1\BIN\emca.bat -deconfig dbcontrol db -repos drop -silent -DB_UNIQUE_NAME myserver -PORT 1521 -EM_HOME D:\app\hashmi\product\11.2.0\dbhome_1 -LISTENER LISTENER -SERVICE_NAME myserver.domain -SYS_PWD MANAGER -SID myserver -ORACLE_HOME D:\app\hashmi\product\11.2.0\dbhome_1 -DBSNMP_PWD MANAGER -HOST myserver -LISTENER_OH D:\app\hashmi\product\11.2.0\dbhome_1 -LOG_FILE D:\app\hashmi\diag\rdbms\myserver\myserver\trace\emConfig_drop.log -SYSMAN_PWD MANAGER
	
	D:\app\hashmi\product\11.2.0\dbhome_1\BIN\emca.bat -config dbcontrol db -repos create -silent -DB_UNIQUE_NAME myserver -PORT 1521 -EM_HOME D:\app\hashmi\product\11.2.0\dbhome_1 -LISTENER LISTENER -SERVICE_NAME myserver.domain -SYS_PWD MANAGER -SID myserver -ORACLE_HOME D:\app\hashmi\product\11.2.0\dbhome_1 -DBSNMP_PWD MANAGER -HOST myserver -LISTENER_OH D:\app\hashmi\product\11.2.0\dbhome_1 -LOG_FILE D:\app\hashmi\diag\rdbms\myserver\myserver\trace\emConfig_recreate.log -SYSMAN_PWD MANAGER

7. R-start the dbconsole service from the services panel 

8. Install following flash componenets for browser:
	install_flash_player_23_active_x
	install_flash_player_23_plugin
	install_flash_player_23_ppapi

9. Open EM in internet explorer and add link to trusted websites.


Listener Status:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver.domain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
Start Date                10-OCT-2017 15:33:44
Uptime                    6 days 17 hr. 15 min. 20 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   d:\app\hashmi\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\app\hashmi\product\11.2.0\dbhome_1\log\diag\tnslsnr\ISDB\listener\alert\log.xml

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver.domain)(PORT=1521)))
Services Summary...
Service "myserver.domain" has 1 instance(s).
  Instance "myserver", status READY, has 1 handler(s) for this service...
Service "myserverXDB.domain" has 1 instance(s).
  Instance "myserver", status READY, has 1 handler(s) for this service...
The command completed successfully


EMCTL Status:
C:\Windows\system32>emctl status agent
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.4.4
OMS Version       : 10.2.0.4.4
Protocol Version  : 10.2.0.4.4
Agent Home        : D:\app\hashmi\product\11.2.0\dbhome_1\myserver.domain_isdb
Agent binaries    : d:\app\hashmi\product\11.2.0\dbhome_1
Agent Process ID  : 2108
Agent URL         : https://myserver.domain:3938/emd/main
Repository URL    : https://myserver.domain:1158/em/upload/
Started at        : 2017-10-10 15:53:48
Started by user   : SYSTEM
Last Reload       : 2017-10-10 16:00:04
Last successful upload                       : 2017-10-17 08:39:20
Total Megabytes of XML files uploaded so far :    26.87
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    95.23%
Data channel upload directory                : D:/app/hashmi/product/11.2.0/dbhome_1/myserver.domain_isdb/sysman/recv
Last successful heartbeat to OMS             : 2017-10-17 08:49:10
---------------------------------------------------------------
Agent is Running and Ready



C:\Windows\system32>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://myserver.domain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory d:\app\hashmi\product\11.2.0\dbhome_1/myserver.domain_isdb/sysman/log

/forum/fa/13669/0/

[mod-edit: image inserted into message body by bb]
  • Attachment: status.png
    (Size: 12.16KB, Downloaded 6898 times)

[Updated on: Tue, 17 October 2017 03:49] by Moderator

Report message to a moderator

Re: Unable to view Instance Information [message #666238 is a reply to message #666127] Mon, 23 October 2017 01:48 Go to previous messageGo to next message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
Any expert opinion would be appreciated.
Re: Unable to view Instance Information [message #666239 is a reply to message #666238] Mon, 23 October 2017 02:04 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
This happens repeatedly with the DB Console. Don't worry about it, just stop trying to use it. Note that DB Console does not exist in release 12.

Removing and re-installing it will not help, as you have found. I do remember that sometimes it doesn't stop correctly and that did seem to trigger the problem. After stopping it, check that there are no Java processes or perl processes running. It there are, kill them. Then try starting it again. No promises, but that might be the problem.

Re: Unable to view Instance Information [message #666362 is a reply to message #666239] Tue, 31 October 2017 22:51 Go to previous message
1982Hashmi
Messages: 69
Registered: March 2011
Location: Islamabad
Member
The problem was traced to be a network problem instead of database configuration. When I ping the database server using:
ping -a <IP>
It didn't displayed the domain so I re-joined the domain of database server, performed same steps to configure EM and it succeeded.

Thanks.
Previous Topic: OEM Agent not working (going down after login in few minutes)
Next Topic: Metric evaluation error start warning - changing timeout setting ?
Goto Forum:
  


Current Time: Fri Nov 22 11:37:08 CST 2024