Forgot your password?    
+ Reply to Thread
Results 1 to 5 of 5

Thread: Exiting with status 100 to instantiate the tnsnames.ora template

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40

    Question Exiting with status 100 to instantiate the tnsnames.ora template

    I did ./rapidwiz -restart and the installation started. but after a few seconds installation dialouge disappears. I checked the log file and found the below thing.
    could you please have a look into it and suggest what could be the concern.

    FYI- all checks were okay none was crossed.


    ---------------------------------------------------------------
    ADX Database Utility
    ---------------------------------------------------------------

    getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
    getConnection() -->
    sDbHost : localhost
    sDbDomain : localdomain
    sDbPort : 1528
    sDbSid : PROD
    sDbUser : APPS
    Trying to connect using SID...
    getConnectionUsingSID() -->
    JDBC URL: jdbcracle:thin:@localhost.localdomain:1528:PROD
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName
    getConnectionUsingServiceName() -->
    JDBC URL: jdbcracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(H OST=localhost.localdomain)(PORT=1528))(CONNECT_DAT A=(SERVICE_NAME=PROD)))
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName.DomainName
    getConnectionUsingServiceName() -->
    JDBC URL: jdbcracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(H OST=localhost.localdomain)(PORT=1528))(CONNECT_DAT A=(SERVICE_NAME=PROD.localdomain)))
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Connection could not be obtained; returning null

    -------------------ADX Database Utility Finished---------------

    Could not get connection to the database.
    Exiting with status 100 to instantiate the tnsnames.ora template


    What could be the issue ??
    Cheers !
    pk.ora

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Give proper information.
    1. What you want to try to do?
    2. What you are installing?
    3. What version of the OS, Oracle Product etc?
    4. Which step you received this step?

    By looking, what you have given looks like the current process try to get connection from Database, but not able to connect.It could be of many reason..
    Regards,
    -Amit

  3. #3
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40

    Database Availability Check failed ??

    Hi Amit,

    I am installing 11.5.10 on RHEL5. I have passed all primary checks but at the very first step of installation when i moved forward to start installation. within a few second the progress bar disppears. I checked the logfile for the same and above are the contents from logfile which looked odd to me.

    I have completed installation successfully just by changing the POOL Port information earlier I was using 8 now I tried with 2 and re-created the configuration file rather using the old one. and it throughs the installation.

    Now I am stuck in one more place. here are the details

    after installation at the time of Validate system configuration ... it fails for the Database availability check
    I chekced the information why it fails and below are the things I noticed .............. I have attached the screenshot for the same to make more sense for what I am talking about.


    Database Availability Check

    command : su orclmgr -c "/u02/apps11i/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /u02/appsinstall/dbtier/paproddb/9.2.0/PAPROD_localhost.env APPS/APPS"

    RW-50011: Error: - Database ORACLE_HOME connection test has returned an error: 126 command : su applmgr -c "/u02/apps11i/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /u02/appsinstall/appltier/paprodora/8.0.6/PAPROD_localhost.env APPS/APPS"

    RW-50011: Error: - Apps ORACLE_HOME connection test has returned an error: 126


    Screenshot.jpg

    Hope, I was clear about the issue. ??
    Cheers !
    pk.ora

  4. #4
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40

    Database Availability Check Resolved :)

    Hey I resolved this .....

    1) I tried executiong the command after changing the user ( I created for my dbtier, below in bold). FYI - wizard was using APPS/APPS. (see above error)

    -bash-3.1$ su orclmgr -c "/u02/apps11i/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /u02/appsinstall/dbtier/paproddb/9.2.0/PAPROD_localhost.env orclmgr/oracle"

    2) It asked me for password , I entered password of my dbtier user.

    3) I got an error .... this

    bash: /u02/apps11i/startCD/Disk1/rapidwiz/bin/riwTDBup.sh: /bin/sh^M: bad interpreter: No such file or directory

    4) Well known error to me .. I did the below thing to fix this

    i) vi /u02/apps11i/startCD/Disk1/rapidwiz/bin/riwTDBup.sh
    ii) :set fileformat=unix and hit enter.
    iii) wq
    iv) came to Validate System Configuration dialouge ( given in above screenshot) and hit Retry button and all done. (all check are cleared now)

    resolved.jpg


    Thanks
    Cheers !
    pk.ora

  5. #5
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    good to hear that..!!
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. To find the current status of database
    By devesh_ocp in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 04-25-2012, 11:02 AM
  2. redolog file status
    By devesh_ocp in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 04-24-2012, 10:54 PM
  3. Create Database Template Using DBCA.
    By ajaychandi in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 0
    Last Post: 04-18-2012, 05:49 PM
  4. Apply the latest AutoConfig Template patch in 11i
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-03-2011, 05:46 PM
  5. When AutoConfig script exits with non-zero status?
    By Amit in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 11-01-2011, 03:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics