Solved

Cannot access Oracle Enterprise Manager via Foxfire

Posted on 2009-05-11
18
2,672 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
ID: 24365007
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
ID: 24365520
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
ID: 24365635
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
ID: 24365678
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
ID: 24367810
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
ID: 24367891
The emca log has the following : Config: ORA -12541 TNS no listener.
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24372414
Then start the Listener

lsnrctl start
lsnrctl status
0
 

Author Comment

by:missymadi
ID: 24375878
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
ID: 24376003
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:missymadi
ID: 24377719
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
ID: 24378143
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
ID: 24379395
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
ID: 24382276
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
ID: 24385160
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
ID: 24385635
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
ID: 24386050
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
ID: 24421357
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
ID: 24423563
Good news!
Good luck!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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…

863 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

26 Experts available now in Live!

Get 1:1 Help Now