Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting Connection Time out while connecting and with tnsping

MangatJun 11 2013 — edited Jun 12 2013

Hello Experts,

I am new to Oracle world, so please go easy on me.

I installed Oracle 11 XE on Centos 6.4 VM. followed the official installation procedure and database was installed without any errors.

I am able to login to database through sqlplus and able to run sql queries.

Problem comes when i am trying to connect from sql developer or external application. i get Connection Time out error.

Below are the tnsnames.ora and listener.ora file content

# tnsnames.ora Network Configuration File:

XE =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = basevm)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)

-------------

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
      (PROGRAM = extproc)
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = basevm)(PORT = 1521))
    )
)

DEFAULT_SERVICE_LISTENER = (XE)

----------------------------------------------

lsnrctl stat shows service stats as UNKNOWN and tnsping also fails

bash-4.1$ lsnrctl stat

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 11-JUN-2013 02:00:48

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                10-JUN-2013 19:39:03
Uptime                    0 days 6 hr. 21 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/sagbase/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=basevm)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

-----------------

bash-4.1$ tnsping xe

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 11-JUN-2013 02:01:16

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = basevm)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
TNS-12535: TNS:operation timed out

I am stuck and don't know where else to check.

Could you guys please help me out here?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2013

Added on Jun 11 2013

#11g, #error, #installation

7 comments

5,599 views