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?
Main Topics
Browse All TopicsExperts,
I cannot access my Oracle Enterprise Manager. I get an error Address not found. firefox can't find the server at localhost.localdomain_orcl
Where do I fix this problem?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I found it out on the "net" enter "password" and it will work? (http://blog.vpire.com/?p=
I'll let you know if it worked.
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??
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=(Pro
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
...
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
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
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.em
How do I fix this?
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_ran
Business Accounts
Answer for Membership
by: schwertnerPosted on 2009-05-12 at 07:34:26ID: 24365007
After changing the host address you have to recreate the OEM repository:
---------- ---------- ---------- ---------
.2.0/db_1
---------- ---------- ---------- --------- g perform .2.0/db_1/ cfgtoollog s/emca/TES TDB/emca_2 006-07-24_ 10-08-20-P M.log. ControlUti l stopOMS Config dropRepository Config invoke Config createRepository Config invoke ControlUti l startOMS tConfig performConfiguration tConfig performConfiguration
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
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.EMConfi
INFO: This operation is being logged at /u01/app/oracle/product/10
Jul 24, 2006 10:08:53 PM oracle.sysman.emcp.util.DB
INFO: Stopping Database Control (this may take a while) ...
Jul 24, 2006 10:09:29 PM oracle.sysman.emcp.EMRepos
INFO: Dropping the EM repository (this may take a while) ...
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully dropped
Jul 24, 2006 10:11:23 PM oracle.sysman.emcp.EMRepos
INFO: Creating the EM repository (this may take a while) ...
Jul 24, 2006 10:15:09 PM oracle.sysman.emcp.EMRepos
INFO: Repository successfully created
Jul 24, 2006 10:15:18 PM oracle.sysman.emcp.util.DB
INFO: Starting Database Control (this may take a while) ...
Jul 24, 2006 10:17:21 PM oracle.sysman.emcp.EMDBPos
INFO: Database Control started successfully
Jul 24, 2006 10:17:22 PM oracle.sysman.emcp.EMDBPos
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