Unable to view Instance Information [message #666127] |
Mon, 16 October 2017 23:18 |
|
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
[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 #666239 is a reply to message #666238] |
Mon, 23 October 2017 02:04 |
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 |
|
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:
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.
|
|
|