Solved

Cannot access Oracle Enterprise Manager via Foxfire

Posted on 2009-05-11
18
2,674 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
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: 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
 

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

778 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