1 2 3 4 Previous Next 46 Replies Latest reply: Jan 21, 2012 9:23 PM by 666373 RSS

    Oracle EBS 12.1.1 Installation - Database Post installation Error

    666373
      Hi,

      I need your help!! I was trying to install Oracle EBS12.1.1 on Linux4 update9. The installation completed but it showed up many installation problems. The problems it notified were in Database Availability, Configuration Upload, HTTP, Help page, Virtual Directory and JSP :(
      Please help me to resolve these issues. Following is the Database Availability log-
      Database Availability
      command: su oracle -c "/d01/oracle/StageR12/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /d01/oracle/VIS/db/tech_st/11.1.0/VIS_anshrenu.env APPS/APPS"
      riwTDBup.sh started at Mon Jan 16 22:56:34 EST 2012
      Parameters passed are : /d01/oracle/VIS/db/tech_st/11.1.0/VIS_anshrenu.env APPS/APPS
      The environment settings are as follows ...
      ORACLE_HOME : /d01/oracle/VIS/db/tech_st/11.1.0
      ORACLE_SID : VIS
      TWO_TASK :
      PATH : /d01/oracle/VIS/db/tech_st/11.1.0/perl/bin:/d01/oracle/VIS/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/d01/oracle/StageR12/startCD/Disk1/rapidwiz/unzip/Linux:/usr/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:.
      LD_LIBRARY_PATH : /d01/oracle/VIS/db/tech_st/11.1.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/d01/oracle/VIS/db/tech_st/11.1.0/lib:/usr/dt/lib:/d01/oracle/VIS/db/tech_st/11.1.0/ctx/lib
      Executable : /d01/oracle/VIS/db/tech_st/11.1.0/bin/sqlplus
      riwTDBup.sh exiting with status 0
      Database ORACLE_HOME connection test has succeeded
      command: su appltest -c "/d01/oracle/StageR12/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /d01/oracle/VIS/inst/apps/VIS_anshrenu/ora/10.1.2/VIS_anshrenu.env APPS/APPS"
      riwTDBup.sh started at Mon Jan 16 22:56:40 EST 2012

      Parameters passed are : /d01/oracle/VIS/inst/apps/VIS_anshrenu/ora/10.1.2/VIS_anshrenu.env APPS/APPS

      The environment settings are as follows ...
      ORACLE_HOME : /d01/oracle/VIS/apps/tech_st/10.1.2
      ORACLE_SID :
      TWO_TASK : VIS
      PATH : /d01/oracle/VIS/apps/tech_st/10.1.2/bin:/usr/bin:/usr/sbin:/d01/oracle/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/usr/bin:/d01/oracle/StageR12/startCD/Disk1/rapidwiz/unzip/Linux:/usr/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
      LD_LIBRARY_PATH : /d01/oracle/VIS/apps/tech_st/10.1.2/lib32:/d01/oracle/VIS/apps/tech_st/10.1.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/d01/oracle/VIS/apps/tech_st/10.1.2/jdk/jre/lib/i386:/d01/oracle/VIS/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/d01/oracle/VIS/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/d01/oracle/VIS/apps/apps_st/appl/sht/12.0.0/lib
      Executable : /d01/oracle/VIS/apps/tech_st/10.1.2/bin/sqlplus
      riwTDBup.sh exiting with status 4

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

      Appreciate your help and time.

      Thanks,
      Anshul

      Edited by: user9959418 on Jan 16, 2012 8:19 PM
        • 1. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
          Hussein Sawwan-Oracle
          This is a generic error, please check the installation log files for details about the error.

          How to locate the log files and troubleshoot Rapid Install for Release 12.0.x and 12.1.x [ID 452120.1]

          Please upload all the log files to any free hosting website and post the link here.

          Thanks,
          Hussein
          • 2. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
            666373
            Thanks for your reply Mr. Hussein. I will get back to you with the required information.

            Thanks,
            Anshul
            • 3. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
              666373
              Hello Mr. Hessein,

              The database logfiles can be seen on the following link. Please let me know if these links does not work.

              http://www.scribd.com/doc/78488580/01161629
              http://www.scribd.com/doc/78488839/ApplyDatabase-01162038
              http://www.scribd.com/doc/78488915/ApplyDBTechStack-01161648
              http://www.scribd.com/doc/78488960/ApplyDBTechStack-01161653
              http://www.scribd.com/doc/78488985/dbInstall
              http://www.scribd.com/doc/78489031/installdbf
              http://www.scribd.com/doc/78489077/make-01161651
              http://www.scribd.com/doc/78489123/Net-Service-Handler
              http://www.scribd.com/doc/78489646/Oh-Clone

              Thanks so much for your help.

              Thanks,
              Anshul

              Edited by: user9959418 on Jan 16, 2012 9:22 PM

              Edited by: user9959418 on Jan 16, 2012 9:23 PM

              Edited by: user9959418 on Jan 16, 2012 9:29 PM
              • 4. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                Hussein Sawwan-Oracle
                I cannot access some files from the links above.

                Could you please put all the files in one zip/tar file and post the link here?

                Thanks,
                Hussein
                • 5. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                  666373
                  Please check the following link. Hope it works. For this you will have to login on to google, i think. If you can suggest me some other better option to share the files please let me know.

                  https://docs.google.com/#folders/0B1b0ySVS3AU5NGY3MzdiOTYtOThhMS00M2FkLTkyMTAtMGRlYmEyZGQ0ZTZh

                  Thanks,
                  Anshul
                  • 6. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                    911518
                    Please i need help with this post Installation errors below(8 in number), am running the installation on windows 7, i used perl to stage my files, installed cygwin instead of MKS toolkit, run my installation without no errors but when i got to post-Innstall ckecks, i got the following errors

                    1. Database Availability

                    command: cmd.exe /c C:\u01\StageR12\startCD\Disk1\rapidwiz\bin\riwTDBup.cmd c:\oracle\VIS\db\tech_st\11.1.0\VIS_hakonix-pc.cmd sqlplus C:\u01\StageR12\startCD\Disk1\rapidwiz\bin\riwTDBup.sql APPS/APPS

                    C:\u01\StageR12\startCD\Disk1\rapidwiz>echo off
                    Tue 01/17/2012
                    11:15 PM
                    "Cannot find environment file "c:\oracle\VIS\db\tech_st\11.1.0\VIS_hakonix-pc.cmd""
                    ERRORCODE = 0 ERRORCODE_END
                    Database ORACLE_HOME connection test has succeeded
                    command: cmd.exe /c C:\u01\StageR12\startCD\Disk1\rapidwiz\bin\riwTDBup.cmd c:\oracle\VIS\inst\apps\VIS_hakonix-pc\ora\10.1.2\VIS_hakonix-pc.cmd sqlplus C:\u01\StageR12\startCD\Disk1\rapidwiz\bin\riwTDBup.sql APPS/APPS

                    C:\u01\StageR12\startCD\Disk1\rapidwiz>echo off
                    Tue 01/17/2012
                    11:15 PM
                    ""
                    "The environment settings are as follows ..."
                    ""
                    " ORACLE_HOME : c:\oracle\VIS\apps\tech_st\10.1.2"
                    " ORACLE_SID : "
                    " TWO_TASK : "
                    " PATH : c:\oracle\VIS\apps\tech_st\10.1.2\bin;c:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\bin;c:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\bin;C:\app\hakorlc\product\11.2.0\dbhome_1\bin;C:\Perl\site\bin;C:\Perl\bin;C:\OraHome_1\bin;C:\OraHome_1\jlib;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\; c:\oracle\client"
                    " LD_LIBRARY_PATH : c:\oracle\VIS\apps\tech_st\10.1.2\lib"
                    ""

                    SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jan 17 23:15:55 2012

                    Copyright (c) 1982, 2005, Oracle. All rights reserved.

                    ERROR:
                    ORA-12541: TNS:no listener


                    connect test returning code 1
                    ERRORCODE = 1 ERRORCODE_END
                    RW-50011: Error: - Apps ORACLE_HOME connection test has returned an error: 1

                    2.Configuration Upload

                    uploading config file at C:\oracle\VIS\db\tech_st\11.1.0\appsutil\conf_VIS.txt
                    Failed upload of config file at C:\oracle\VIS\db\tech_st\11.1.0\appsutil\conf_VIS.txt

                    3. Environment File

                    RW-50016: Error: - Database ORACLE_HOME environment file was not created:
                    File = c:\oracle\VIS\db\tech_st\11.1.0\VIS_hakonix-pc.env Apps ORACLE_HOME environment file passes instantiated variables test:
                    File = c:\oracle\VIS\inst\apps\VIS_hakonix-pc\ora\10.1.3\VIS_hakonix-pc.cmd
                    iAS ORACLE_HOME environment file passes instantiated variables test:
                    File = c:\oracle\VIS\inst\apps\VIS_hakonix-pc\ora\10.1.2\VIS_hakonix-pc.cmd
                    APPL_TOP environment file passes instantiated variables test:
                    File = c:\oracle\VIS\apps\apps_st\appl\VIS_hakonix-pc.cmd
                    ADOVARS environment file passes instantiated variables test:
                    File = c:\oracle\VIS\apps\apps_st\appl\admin\adovars.cmd
                    APPSCONFIG passes instantiated variables test:
                    File = c:\oracle\VIS\apps\apps_st\appl\admin\adconfig.txt


                    4. HTTP

                    checking URL = http://hakonix-pc.www.hakonix.com.ng:8000
                    RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

                    5. Help Page

                    checking URL = http://hakonix-pc.www.hakonix.com.ng:8000/OA_HTML/help
                    RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

                    6. Virtual Directory

                    RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

                    7. JSP

                    checking URL = http://hakonix-pc.www.hakonix.com.ng:8000/OA_HTML/jtfTestCookie.jsp
                    RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

                    8. Login Page

                    RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
                    • 7. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                      Hussein Sawwan-Oracle
                      Anshul,

                      This link prompts for a username/password and I cannot find the file.

                      Thanks,
                      Hussein
                      • 8. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                        666373
                        Hello Mr Hussein,

                        Sorry to hear that even that link did not work. Would it be possible for you to use those mulitple links that i sent in the previous post. I tested all those links, and they are working fine now. I am so sorry for the inconvenience.

                        Thanks,
                        Anshul
                        • 9. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                          Hussein Sawwan-Oracle
                          Hi Anshul,

                          I am able to view the log files now, thanks!

                          The log files show that the database was created successfully, so could you please verify it is up and running.

                          I suspect the error in the log is related to the database listener, so please confirm it is up and make sure you have proper entry in the hosts file.

                          Thanks,
                          Hussein
                          • 10. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                            666373
                            Hello Mr. Hussein,

                            I will check and let you know in 2 hours.

                            Thanks,
                            Anshul
                            • 11. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                              666373
                              Hello Mr. Hussein,

                              I just checked if the Listener is up and running. It is runnning fine. Following is the o/p:

                              lsnrctl status

                              LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 17-JAN-2012 19:45:30

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

                              Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
                              STATUS of the LISTENER
                              ------------------------
                              Alias VIS
                              Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
                              Start Date 16-JAN-2012 20:39:16
                              Uptime 0 days 23 hr. 6 min. 15 sec
                              Trace Level off
                              Security ON: Local OS Authentication
                              SNMP OFF
                              Listener Parameter File /d01/oracle/VIS/db/tech_st/11.1.0/network/admin/VIS_anshrenu/listener.ora
                              Listener Log File /d01/oracle/VIS/db/tech_st/11.1.0/log/diag/tnslsnr/anshrenu/vis/alert/log.xml
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=anshrenu.example.com)(PORT=1521)))
                              Services Summary...
                              Service "VIS" has 1 instance(s).
                              Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...
                              The command completed successfully

                              BUT when i try to connect the the database using sqlplus, I get an error saying "No Listener".

                              Please help and sorry for the late response.

                              Thanks,
                              Anshul
                              • 12. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                                Hussein Sawwan-Oracle
                                Hi Anshul,

                                Do you have proper entry in the hosts file "anshrenu.example.com"? If yes, please bounce the database and the database listener then retry the installation or use -restart option when you run rapidwiz.

                                Thanks,
                                Hussein
                                • 13. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                                  666373
                                  After the above step, i thought to stop and then restart the listener. I could stop it but while restarting it threw an error -
                                  lsnrctl start
                                  LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 17-JAN-2012 19:54:46
                                  Copyright (c) 1991, 2004, Oracle. All rights reserved.
                                  Starting /d01/oracle/VIS/apps/tech_st/10.1.2/bin/tnslsnr: please wait...
                                  TNSLSNR for Linux: Version 10.1.0.5.0 - Production
                                  NL-00280: Message 280 not found; No message file for product=network, facility=NL [d01/oracle/VIS/apps/tech_st/10.1.2/network/log/listener.log]
                                  NL-00278: Message 278 not found; No message file for product=network, facility=NLSNL-00016: Message 16
                                  Listener failed to start. See the error message(s) above...

                                  Hope it will help to resolve this issue and i just did not make it even more worse..
                                  Thanks,
                                  Anshul
                                  • 14. Re: Oracle EBS 12.1.1 Installation - Database Post installation Error
                                    Hussein Sawwan-Oracle
                                    Starting /d01/oracle/VIS/apps/tech_st/10.1.2/bin/tnslsnr: please wait...
                                    TNSLSNR for Linux: Version 10.1.0.5.0 - Production
                                    NL-00280: Message 280 not found; No message file for product=network, facility=NL [d01/oracle/VIS/apps/tech_st/10.1.2/network/log/listener.log]
                                    NL-00278: Message 278 not found; No message file for product=network, facility=NLSNL-00016: Message 16
                                    Listener failed to start. See the error message(s) above...
                                    ORACLE_HOME should point to 11gR1, so source the database env file and try to start the database listener then (you are trying to start the application listener above).

                                    Thanks,
                                    Hussein
                                    1 2 3 4 Previous Next