Cannot access Oracle Enterprise Manager via Foxfire

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?
missymadiAsked:
Who is Participating?
 
schwertnerConnect With a Mentor Commented:
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
 
schwertnerCommented:
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
 
missymadiAuthor Commented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
missymadiAuthor Commented:
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
 
missymadiAuthor Commented:
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
 
missymadiAuthor Commented:
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
 
missymadiAuthor Commented:
The emca log has the following : Config: ORA -12541 TNS no listener.
0
 
schwertnerCommented:
Then start the Listener

lsnrctl start
lsnrctl status
0
 
missymadiAuthor Commented:
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
 
schwertnerCommented:
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
 
missymadiAuthor Commented:
I'm not sure by what you mean about network component of Linux - do you mean the etc/sysconfig and etc/hosts files?
0
 
schwertnerCommented:
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
 
missymadiAuthor Commented:
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
 
schwertnerCommented:
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
 
missymadiAuthor Commented:
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
 
missymadiAuthor Commented:
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
 
missymadiAuthor Commented:
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
 
schwertnerCommented:
Good news!
Good luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.