Tag Archives: Troubleshooting - Page 2

You do not have a current session, please log in before visiting this URL

Posted by on September 3, 2009 No comments

Problem: After installing 11.5.9 Vision instance, the E-Business Suite logon appears, and the user is able to log on as SYSADMIN/SYSADMIN. However, after logging on, the following message appears:

You do not have a current session, please log in before visiting this URL

When trying to troubleshoot the issue with aoljtest.jsp, the user is able to login, but when trying to access all the tests, the following message appears:

"This page can only be accessed through aoljtest.jsp"

Solution:

The domain name of the machine had only one component (localdomain). This was changed to cia.org.tt (at least two components) and the instance wiped and reinstalled.

adalnctl.sh: exiting with status 127

Posted by on September 3, 2009 No comments

Problem: After installing 11.5.9 Vision instance, the apps listener exits with status 127.

Solution: Apply operating system patch 3830807

Metalink Reference:

Subject:  Attempt To Start Listener Exits With Status 127

Doc ID:  299810.1

AutoConfig is exiting with status 4 installing 11.5.9

Posted by on September 1, 2009 No comments

Problem:

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:
<filename>  <phase>  <return code where appropriate>
[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: /u0/oracle/TEST3/test3db/9.2.0/md/demo/orascv/doc
OraSCV.asc              INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/oem_webstage/readme
emreadme.txt            INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/relnotes/em
README_EM.txt           INSTE8
Directory: /u0/oracle/TEST3/test3db/9.2.0/sysman/doc/readme
README_em.txt           INSTE8
AutoConfig is exiting with status 4

Solution: Unset the LANG environment variable.

Metalink Reference:

Subject:  Sun.io.MalformedInputException For OraSCV.asc,emreadme.txt, README_EM.txt And README_em.txt While 11.5.9 Install

Doc ID:  262125.1

jre was not found in oracle.swd.jre/bin/i386/native_threads/jre

Posted by on August 31, 2009 No comments

Problem: After installing Oracle 9.2.0.4, netca and dbca fail with error:

jre was not found in:

/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads/jre

Solution: Change directory to:

/u01/app/oracle/oracle.swd.jre/bin/i386/native_threads

Then create symbolic link to jre:

ln -s java jre

netca can now be launched.

Error in invoking target install of makefile ins_plsql.mk

Posted by on August 31, 2009 No comments

Problem:

While installing Oracle 9.2.0.4 on Oracle Enterprise Linux 4 Update 4, the following error appears:

Error in invoking target install of makefile
/u01/app/oracle/plsql/lib/ins_plsql.mk

Solution:

Applied patch 4198954 (COMPATIBILITY PACKAGES FOR ORACLE ON RHEL 4)

Applying patch 4198954 resolved the installation error.

RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed

Posted by on May 27, 2009 1 comment

Problem:

When cloning the database tier of Illuminat HRMS Production, the process fails on 70% with error:

Beginning database tier Apply - Wed May 27 10:12:21 2009
Log file located at /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
ERROR while running Apply...
 ERROR: Failed to execute adclone.pl
 Please check logfile.
Log file /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log showed:
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
adcrdb.sh started at Wed May 27 10:54:18 AST 2009
The environment settings are as follows ...
       ORACLE_HOME : /u0/oracle/TEST2/test2db/9.2.0
        ORACLE_SID : TEST2
          TWO_TASK :
              PATH : /u0/oracle/TEST2/test2db/9.2.0/Apache/perl/bin:/u0/oracle/TEST2/test2db/9.2.0/bin:/usr/bin:/usr/sbin:/u0/oracle/TEST2/test2db/9.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:../jre/1.3.1/bin:/u0/oracle/testdb/9.2.0/Apache/perl/bin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:.
   LD_LIBRARY_PATH : /u0/oracle/TEST2/test2db/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/oracle/TEST2/test2db/9.2.0/ctx/lib
Executable : /u0/oracle/TEST2/test2db/9.2.0/bin/sqlplus
The log information will be written to
        /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/adcrdb_TEST2.txt
Creating the control file for TEST2_ebusinesstest database ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:54:18 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Database mounted.
BEGIN dbms_backup_restore.zeroDbid(0); END;
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u0/oracle/TEST2/test2db/9.2.0/dbs/MISSING00395'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area  581506100 bytes
Fixed Size                   451636 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
Control file created.
Database altered.
Tablespace altered.
Database altered.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.so'
Library created.
old   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.&libext'
new   2:     '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.so'
Library created.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
exit_code=0
Checking for errors ...
ORA-01119: error in creating database file
ORA-27037: unable to obtain file status
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
The database has not been successfully created. Shutting down the instance ...
SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:57:56 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected.
ORACLE instance shut down.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
.end std out.
.end err out.
---------------------------------------------------------------
                   ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : ebusinesstest
    sDbDomain  : illuminatnm.com
    sDbPort    : 1523
    sDbSid     : TEST2
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null
-------------------ADX Database Utility Finished---------------
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:469)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314)
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
        at java.lang.reflect.Constructor.newInstance(Native Method)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
        at java.lang.Thread.run(Thread.java:479)

Solution:

The cloning process omits two files that were created since the last adpreclone.pl run. Therefore, run preclone scripts (adpreclone.pl) on the production instance before copying files.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

(TRIGGER-1) Trigger defined in the Application Designer and not found in the Database

Posted by on February 7, 2009 No comments

Problem:

After cloning fsdev to fstst, DDDAUDIT was run. It showed the following error:

(TRIGGER-1) Trigger defined in the Application Designer and not found in the Database:
 Record Name Trigger Name
 --------------- ---------------
 CHARTFIELD1_TBL PSICHARTFIELD1_TBL
 CHARTFIELD1_TBL PSUCHARTFIELD1_TBL
 2 Total Rows

Solution:

In GLWEBAPP, launch Application Designer. Log on to FSTST (ensure FSTST ODBC Connection created).

(QUERY-22) Following Queries Were Created Without PUBLIC Access Query Name

Posted by on February 6, 2009 No comments

Problem:

After cloning fsdev to fstst, SYSAUDIT was run. It showed the following error:

(QUERY-22) Following Queries Were Created Without PUBLIC Access Query Name
 -------------------------------
 Oper ID
 -------------------------------
 FJBG_CALENDARS VP1
 FJBG_NAVIGATION VP1
 FJBG_SET_CONTROL_GROUP VP1
 FJBG_TIMESPANS VP1
 4 Total Rows

Solution:

Spoke to consultant (FB). He said that he created these queries and they were set to be private. Therefore, the error could be ignored.

(IBRK-21): Operations with duplicate routings

Posted by on February 1, 2009 Comments Off on (IBRK-21): Operations with duplicate routings

Problem:

After running the SYSAUDIT report, the following errors appear under Integration Broker Audits:

Operation Version Routing
 --------- ------- -------
 QAS_CRASH_MSG VERSION_1 ~GEN_UPG~18727
 QAS_CRASH_MSG VERSION_1 ~GEN~UPG~19278
2 Total Rows

Solution:

In PIA, navigate to PeopleTools > Integration Broker > Service Utilities > Service Administration.
Click on the Routing tab.
Expand Delete Duplicate Routings.
Click Search

The duplicate Routing Definitions appear. The second item will be checked.
Click Delete Tem…
Then click Search again. Ensure that no rows appear.

Build and Alter Step While Applying MP5

Posted by on January 16, 2009 No comments

The Build and Alter step (or ‘chapter’) consists of two tasks:

1. Build and Alter Task_1
2. Build and Alter Task

Under the first task (Build and Alter Task_1), there are two steps:
a. Build Step
b. Run Recreate Tables Script

No action is required for the Build and Alter Task_1 steps. Read the documentation in the right pane, and then mark the steps as Complete.

Under the second task (Build and Alter Task), there are seven steps:
a. Build and Alter Step
b. Run Create Tables Script
c. Run Alter Tables Script
d. Run Create Triggers Script
e. Run Create Views Script
f. Additional Step 02
g. Run Create Indexes Script

The first step (Build and Alter Step) can be run automatically. The step completes with warnings, as there are some records have over 16 keys or some record definitions do not exist. The log file is:
E:/temp/softwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5}/BuildAndAlter.log

The output scripts generated by the Build and Alter Step are located in E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5}

The second step, Run Create Tables Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateTables.sql script in SQL Server Management Studio. The CreateTables.sql script executed successfully in 59 seconds.

The third step, Run Alter Tables Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} AlterTables.sql script in SQL Server Management Studio. The AlterTables.sql script executed successfully in 1 minute 30 seconds.

The fourth step, Run Create Triggers Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateTriggers.sql script in SQL Server Management Studio. The CreateTriggers.sql script executed successfully in less than 1 second.

The fifth step, Run Create Views Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateViews.sql script in SQL Server Management Studio. The CreateViews.sql script executed successfully in 26 seconds.

The sixth step, Additional Step 02 is done by logging into PIA and populating the KEYLIST field.

The seventh step, Run Create Indexes Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateIndexes.sql script in SQL Server Management Studio. The CreateIndexes.sql script executed successfully in 10 seconds.

Note: When these steps were first run against the FSDMO instance, the Create Views step failed because the PTPATCH.DMS script and PATCH849 project were not run against the database.