Solved

Cannot access Oracle Enterprise Manager via Foxfire

Posted on 2009-05-11
18
2,664 Views
Last Modified: 2013-11-11
Experts,
 
      I cannot access my Oracle Enterprise Manager. I get an error Address not found. firefox can't find the server at localhost.localdomain_orcl. I was able to access the db fine yesterday. Then I changed the host address and now I cannot access the db. I tried setting the Oracle environment then seeing if the agent was running using emctl. I get an error "$ORACLE_HOME/bin/emctl EM Configuration issue. /u01/app/oracle/product/11.1.0/db_1/mission01 not found.

Where do I fix this problem?
0
Comment
Question by:missymadi
  • 11
  • 7
18 Comments
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
After changing the host address you have to recreate the OEM repository:

To recreate the configuration files and repository for Database Console, run:
$ emca -config dbcontrol db -repos recreate

STARTED EMCA at Jul 24, 2006 10:08:20 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: TESTDB
Database Control is already configured for the database TESTDB
You have chosen to configure Database Control for managing the database TESTDB
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Password for SYS user: change_on_install
Password for DBSNMP user: manager
Password for SYSMAN user: manager
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1

Database hostname ................ linux3
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jul 24, 2006 10:08:50 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/TESTDB/emca_2006-07-24_10-08-20-PM.log.
Jul 24, 2006 10:08:53 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jul 24, 2006 10:09:29 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 24, 2006 10:15:09 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jul 24, 2006 10:15:18 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 24, 2006 10:17:21 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 24, 2006 10:17:22 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://linux3:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 24, 2006 10:17:22 PM
0
 

Author Comment

by:missymadi
Comment Utility
I got to the DBSNMP user and entered the default password of DBSNMP but an error is returned:
ORA-01034: ORACLE not available

how do I fix this so I can continue?
0
 

Author Comment

by:missymadi
Comment Utility
I found it out on the "net"   enter "password"   and it will work? (http://blog.vpire.com/?p=952)

I'll let you know if it worked.
0
 

Author Comment

by:missymadi
Comment Utility
The emcl started but stopped in the middle with an error:
oracle.sysman.emcp.EMconfig perform
SEVERE: Database instance unavailable
Could not complete the configuration.
0
 

Author Comment

by:missymadi
Comment Utility
I did some research and found that I need to start the listener and db instance - which makes sense!
lsnrctl start
Then
sqlplus /nolog
conn sys/password as sysdba
sql>startup
Database mounted and opened.

SO, I tried the $ORACLE_HOME/bin/emca -config dbcontrol d -repos recreate. I am still receiveing an error SEVERE: Listener is not up. Start the Listener and run EM Config Ass. again.  I re-ran the lsnrctl start again and it says "already running". What is happening??
0
 

Author Comment

by:missymadi
Comment Utility
The emca log has the following : Config: ORA -12541 TNS no listener.
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
Then start the Listener

lsnrctl start
lsnrctl status
0
 

Author Comment

by:missymadi
Comment Utility
I tried to start the listener but get a message "TNS-01106: Listener using listener name LISTENER has already been started  
When I enter lisnrctl status I get:
Connecting to (DESCRIPTION=(ADDRESS=(Protocol=IPC)(KEY=EXTPROC1)))
TNS-12541 : TNS: no listener
TNS-12560 TNS:protocol adapter error
TNS-00511: No listener
Linux ERRoR:2. No such file or directory
Connecting to (DESCRIPTION ADDRESS PROTOCOL=TCP HOST=localhost (PORT=1521))))
STATUS of LISTENER
...
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
...
listening endpoints summary
     Description address protocol =ipc KEY=EXTPROC1521))))
     Description address protocol=tcp HOST=127.0.0.1)(PORT=1521))))
The listener supports no services
the command completed successfully

Could you give me some advice on the listener.ora, TNSNAMES.ora and SQLNET.ora and how they should be set up when a hostname is changed? I think this is where I am encountering a lot of the errors.

THAnks, MISsymadi
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
There is nothing special.
1. Go to the network component of Linux and change the host settings there.
   In every distribution of Linux there are different utilities that do this.
   Restart the machine and check if it is visible.

2. Go to LISTENER.ORA and edit the HOST = with the new host name

 ......

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = fsjk.bg.post.int)(PORT = 1521))
    )
  )

3. Start Listener as Oracle user
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:missymadi
Comment Utility
I'm not sure by what you mean about network component of Linux - do you mean the etc/sysconfig and etc/hosts files?
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
There are GUIs that put the changed computer name and/or IP in many config files.
In Novel Linux the tool is called YAST2. I do not know what is your distribution.
But find on the Google the name of the GUI.
Otherwise find a description in which files to put the values.
0
 

Author Comment

by:missymadi
Comment Utility
I put the values in the files, etc/sysconfig and etc/hosts file.
Now when I run emca I get "SEVERE, failed to allocate ports in the specified range.....oracle:sysman.emcp.exception failed to allocate ports in the specified range for the following processes JMS, RMI, DBCONTROL 5500-5519

How do I fix this?
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
Read the installation manual
There is a parameter
portlist range

that should be set appropriatelly.
But I point you the whole document because I suspect other parameters
are not set good enough.

Also look for firewalls, antiviruses
For Red Hat
 

Configure the kernel.

Edit /etc/sysctl.conf.

Add the following to the file:

# Kernel paramaters required by Oracle 11gR1

fs.file-max = 6553600

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

Open in new window

0
 

Author Comment

by:missymadi
Comment Utility
I followed the installation manual and passed the settings as "succeeded" during install of Oracle 11g. No firewalls or antivirus is blocking the ports.
ANy other ideas?
0
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
Comment Utility
OK!
Now recreate the OEM repository
To recreate the configuration files and repository for Database Console, run: 

$ emca -config dbcontrol db -repos recreate
 

STARTED EMCA at Jul 24, 2006 10:08:20 PM

EM Configuration Assistant, Version 10.2.0.1.0 Production

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 

Enter the following information:

Database SID: TESTDB

Database Control is already configured for the database TESTDB

You have chosen to configure Database Control for managing the database TESTDB

This will remove the existing configuration and the default settings and perform a fresh configuration

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

Listener port number: 1521

Password for SYS user: change_on_install

Password for DBSNMP user: manager

Password for SYSMAN user: manager

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

-----------------------------------------------------------------
 

You have specified the following settings
 

Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1
 

Database hostname ................ linux3

Listener port number ................ 1521

Database SID ................ TESTDB

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ...............
 

-----------------------------------------------------------------

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

Jul 24, 2006 10:08:50 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/TESTDB/emca_2006-07-24_10-08-20-PM.log.

Jul 24, 2006 10:08:53 PM oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may take a while) ...

Jul 24, 2006 10:09:29 PM oracle.sysman.emcp.EMReposConfig dropRepository

INFO: Dropping the EM repository (this may take a while) ...

Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this may take a while) ...

Jul 24, 2006 10:15:09 PM oracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Jul 24, 2006 10:15:18 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ...

Jul 24, 2006 10:17:21 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Jul 24, 2006 10:17:22 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is http://linux3:1158/em <<<<<<<<<<<

Enterprise Manager configuration completed successfully

FINISHED EMCA at Jul 24, 2006 10:17:22 PM

Open in new window

0
 

Author Comment

by:missymadi
Comment Utility
I tried to run the EMCP but it still fails on the port error. The exact error is
ORACLE: sysman.emcp.exception Failed to allocate ports in the specified range for the following process JMS, RMI, DBCONTROL 5500-5519, EM Agent 3938.

How do I fix this?
The sysctl.conf file reads net.ipv4.ip_local_port_range=1024 6500
0
 

Author Comment

by:missymadi
Comment Utility
I found the error. I had built this on a VM then moved it to another server. BUT I still had my IP address for the VM in etc/hosts file. Once I removed the ip address and let DNS take over in the new environment, Oracle Enterprise Manager opened.
0
 
LVL 47

Expert Comment

by:schwertner
Comment Utility
Good news!
Good luck!
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now