This discussion is archived
4 Replies Latest reply: Aug 22, 2013 5:05 AM by naeem akhtar RSS

Repository Creation Utility Problems

270857 Newbie
Currently Being Moderated
I am having an unbelievable amount of grief with the Repository Creation Utility.

I have an Oracle 11g database called ORCL running on a server with a static ip address.

I cannot get past the database connection screen

Whatever I try I get

Unable to connect to the database using the provided details.
Please enter a valid hostname and port or check if the listener is up and running.

This happens weather I run rcu remotely or locally.

I know the host and port are reachable because

telnet 192.168.1.5 1521

Returns the following

Trying 192.168.1.5...
Connected to centos5 (192.168.1.5).
Escape character is '^]'.

Which means that port 1521 on 192.168.1.5 is open and there's something listening on port 1521.

This works locally and remotely

I can connect to ORCL both locally and remotely via sqlplus.

The listener is definitely up and running

lsnrctl status returns the following

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-AUG-2009 21:09:36

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centos5.home)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 14-AUG-2009 21:06:34
Uptime 0 days 0 hr. 3 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/111/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/centos5/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos5.home)(PORT=1521)))
Services Summary...
Service "ORCLXDB.home" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "orcl.home" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "orcl_XPT.home" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully

listener.ora
# listener.ora Network Configuration File: /opt/oracle/111/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = centos5.home)(PORT = 1521))
)
)

tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/111/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.home)
)
)

Here is the log entry
2009-08-14 22:01:06.311 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil
.jdbc.JDBCEngine::connect: Connecting to database: user:sys, role:SYSDBA, connectString:(description=(address=(host=192.168.1.5)(protocol=tcp)(port=1521))(connect_data=(service_name=ORCL.HOME)(server=dedicated)))
2009-08-14 22:01:27.174 ERROR rcu: oracle.sysman.assistants.rcu.backend.validation.StepValidator::isConnectionStepValidated: Failed to connect database: Unable to connect to the database using the provided details.
Please enter a valid hostname and port or check if the listener is up and running. 2009-08-14 22:01:27.174 ERROR rcu: oracle.sysman.assistants.rcu.backend.validati
on.StepValidator::isConnectionStepValidated: SQLFatalErrorException: oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Unable to connect to the database using the provided details.
Please enter a valid hostname and port or check if the listener is up and running.

I notice that the service name has been changed to uppercase even though I entered it in lowercase. I've also tried putting the name in uppercase in my tnsnames.ora. No joy.

The rcu will connect to my xe database on another machine without any problems.

Thanks

=====================================
PS
I ended up using a 10g database. The RCU worked without difficulty.

Edited by: tcavanna on Aug 21, 2009 10:32 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points