4 Replies Latest reply: Aug 22, 2013 7:05 AM by Naeem Akhtar Khan RSS

    Repository Creation Utility Problems

    270857
      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