Solved

connect to Oracle 11g instance

Posted on 2009-05-08
21
2,443 Views
Last Modified: 2013-11-11
Experts,

        I need to connect to the database instance in Oracle 11g. I'm getting an error Failed to Connect. cant' establish a connection to the server at localhot.localadmin:1158

Here's the url:  https://localhost.localdomain:1158/em/

Thanks, MIssymadi
0
Comment
Question by:missymadi
  • 10
  • 10
21 Comments
 
LVL 40

Expert Comment

by:omarfarid
ID: 24337061
check the ports and see if you have a firewall blocking your connection and that the remote system is running the listener.
0
 

Author Comment

by:missymadi
ID: 24337168
How do I check that in Linux? I
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24357129
Try this
https://localhost:1158/em/

But before this check if the instance is registered by the Listener:

lsnrctl status
lsnrctl services
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24357142
Also the OEM should be up

emctl start dbconsole
0
 

Author Comment

by:missymadi
ID: 24358598
I'm in as root and typed lsnrctl status, and got:

TNS:no listener
TNS:12560:TNS protocol adapter error
TNS-00511: No listener
Linux ERRor 111: Connection refused

Why is the connection refused?
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24361496
Then start the Listener:

lsnrctl start
emctl start dbconsole

Possibly the Oracle instance is also not startted

% sqlplus /nolog
SQL>connect sys/password@your_instance as sysdba
SQL>startup
0
 

Author Comment

by:missymadi
ID: 24364747
I entered lsnrctl start (as root)
I got the error:
Error listening on (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12555:TNS:permission denied
TNS-12560: TNS:protocol adaptor error
TNS-00525 Insufficient privelige for operation
Linux ERROR: Operation not permitted.

Listener failed to start

How do I fix this error?
Also, it seems that when I changed the HOSTNAME all the problems started. I changed the hostname back to localhost.localdomain and now I have these errors. I do need to change the hostname to mission-rh2 to bind to the IP address when this db goes into prduction. The files that I changed are: /etc/sysconfig network and /etc/hosts. I also made a change to the listener.ora file: I added listener.ora location=/u01/app/oracle/product/11.1.0/db_1/network/admin

Thanks!
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24372517
Root can not start the Listener!
Listener should be started from 'oracle' user account.
If you have changed the hostname then go to LISTENER.ORA
file and change the HOST_NAME there appropriatelly.
After that start the Listener.
0
 

Author Comment

by:missymadi
ID: 24378666
I changed the listener file. The listener started, the orcl database mounted and is up. However I still cannot access the db through Oracle Enterprise Manager. The error is failed to connect using the url
https://mission-2:1158

0
 
LVL 47

Expert Comment

by:schwertner
ID: 24382309
https://mission-2:1158/em

But before this check if the instance is registered by the Listener:

lsnrctl services

If it is not mentioned do static registration of the instance:

Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.


In Oracle 11g you have to create from scratch in the listener.ora file the section

SID_LIST_LISTENER =
&..

mentioned above.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:missymadi
ID: 24385690
Here is what my listener.ora looks like:
#
#
#
LISTENER =
   (DESCRIPTION LIST =
      (DESCRIPTION =
         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
         (ADDRESS = (PROTOCOL =TCP)(HOST=missionrh2)(PORT= 1521))
)
)
     SID_LIST_LISTENER =
         (SID_LIST =
               (SID_DESC =
               (SID_NAME = PLSExtProc
               (ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
               (PROGRAM=extproc)
           )
            (SID_DESC=
            (SID_NAME=orcl
            (ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1)
       )

I go to the $ORACLE_HOME/bin directory and run lsnrctl stop and an error is returned bash: "lsnrctl:command not found
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24385870
Seems you use an user that is not the Oracle user (DBA group)
and it has not rights to execute lsnrctl. I am sure it exists there
and you also can see it.

Clarify the name of the 'oracle' user - the same that has installed Oracle
After that give him rights over /u01 and subdirectories:

% chown oracle /u01 -R
0
 

Author Comment

by:missymadi
ID: 24386011
I am using the oracle account. I also entered SU to change to root to see if I could get to the listener service but could not.
What is the exact syntax to give oracle acct rights over the oracle home directory?
0
 

Author Comment

by:missymadi
ID: 24386358
I set my environment variables and found the listener.
Anyway - I ran lsnrctl stop and get the following error
Connecting to (DESCRIPTION..address...protocol ipc...key..extproc1))
TNS-12541 TNS no listener
TNS-12560 TNS protocol adapter error
tNS 00511 no listener
Connecting to desc..address..protocol=tcp...host missionrh2 port=1521

TNS 12541 - tns no listener
tns 12560 TNS protocol adapter error
tns 00511 no listener
linux error 111 connection refused.


why isnt this working?
0
 

Author Comment

by:missymadi
ID: 24386982
listener is now working, I guess I just needed to wait for the settings to take place. Anyway, I started the listener and it is working now. I entered emctl start dbconsole and it returns:
https://localhost.localdomain://1158/em/console/aboutApplication  - An instance of OEM 11g....already running.
However my host name is mission-2? I changed the hostname to mission-2. I still cannot connect to Oracle enterprise manager through Firefox
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24387329
Good!

The next step is to try to recreate the repository (see snppet).

Before this try to use the IP of the host instead the name.
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: 24387589
Things were going good until I got to an error:
SEVERE: Error starting Database Control
Could not complete the configuration. From the logs : WARNING: Error executing /u01/app/oracle/product/11.1.0/db_1/bin/emctl start dbconsole....Error starting db control ...at oracle.sysman.emcp.EMconfigAssistant.main(EMConfigAssistant.java:467)
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24387930
Look here and repeat the steps.
0
 

Author Comment

by:missymadi
ID: 24389031
GREAT! I repeated the emca process and it finally finished! I connected to OEM! Thanks for your help.

One question, mission-rh is on port 5500. Where is the port number set? I thought it would be on 1158?

0
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 24393543
Look in portlist file for actual ports.
Now it will be on 5500, but give a try or check in portlist file.
0
 
LVL 47

Expert Comment

by:schwertner
ID: 24401681
I will also so say GREAT!
Good luck!
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

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…
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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

743 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

17 Experts available now in Live!

Get 1:1 Help Now