Problem: When starting emctl for first time after reboot on Linux, the following message appears:
Timezone mismatch: The agentTZRegion value (GMT) in /u01/app/oracle/product/10.2.0/db_1/localhost.localdomain_ORCL/sysman/config/emd.properties does not match the current environment TZ setting().
The dbconsole cannot run with this mismatch.
Solution:
Run:
emctl resetTZ agent
Then run:
emctl start dbconsole
You may need to stop the agent (but it says it is not running):
emctl stop agent
Problem: When attempting to log on to SQL*Plus as ”/ as sysdba’, the following error appears:
ERROR: ORA-12162: TNS:net service name is incorrectly specified
Solution: Set ORACLE_SID=ORCL
export ORACLE_SID=ORCL
Problem: While performing full export of production database, the following error is encountered:
. . exporting table WF_NOTIFICATION_OUT EXP-00056: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [kopi2_readlen083], [], [], [], [], [], [], []
Solution:
Cause:
Bug 3041387 ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KOPI2_READLEN083]
ORA-600 [kopi2_readlen083] can occur while enqueueing an object with an immediate embedded NULL.
This issue is fixed in Oracle Server 9.2.0.5 (Server patch set release) and in Oracle Server 10g.
Patch 3041387 is also available on Metalink.
Fix:
Please apply Oracle Server patch 3041387.
Metalink Reference:
Doc ID: 279647.1: Workflow Notifications Show Ora-00600 With Argument [Kopi2_readlen083] With Oracle Server 9.2
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]
This document details steps to start PeopleSoft on the Peoplesoft2 server.
Step 1: Boot up the PeopleSoft server and log on as the Administrator user.
Step 2: From the Start menu, load Microsoft Virtual PC.
Step 3: Select Windows 2000 Peoplesoft2, and click Start.
The virtual machine starts and Windows 2000 Professional boots.
Step 4: After booting, click OK to log on as the ILLUMINAT user.
Step 5: Start the Tuxedo application server. Open Command Prompt and change directory to C:PT849appserv.
Run psadmin and start the EPDMO Application Server.
Enter the items shown in bold below.
C:>cd pt849 C:PT849>cd appserv C:PT849appserv>psadmin PSADMIN -- Tools Release: 8.49 Copyright (c) 1988, 2003, Oracle. All rights reserved. -------------------------------- PeopleSoft Server Administration -------------------------------- 1) Application Server 2) Process Scheduler 3) Search Server 4) Service Setup q) Quit Command to execute (1-4, q): 1 -------------------------------------------- PeopleSoft Application Server Administration -------------------------------------------- 1) Administer a domain 2) Create a domain 3) Delete a domain 4) Import domain configuration q) Quit Command to execute (1-4, q) : 1 Tuxedo domain list: 1) EPDMO 2) VASU Select domain number to administer: 1 -------------------------------- PeopleSoft Domain Administration -------------------------------- Domain Name: EPDMO 1) Boot this domain 2) Domain shutdown menu 3) Domain status menu 4) Configure this domain 5) TUXEDO command line (tmadmin) 6) Edit configuration/log files menu 7) Messaging Server Administration menu 8) Purge Cache 9) Preload File Cache 10) Clean IPC resources of this domain q) Quit Command to execute (1-10, q) : 1 ------------------------------- PeopleSoft Domain Boot Menu ------------------------------- Domain Name: EPDMO 1) Boot (Serial Boot) 2) Parallel Boot q) Quit Command to execute (1-2, q) [q]: 1 Attempting to boot bulletin board... tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc. Portions * Copyright 1986-1997 RSA Data Security, Inc. All Rights Reserved. Distributed under license by BEA Systems, Inc. Tuxedo is a registered trademark. No bulletin board exists. Entering boot mode. INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level (none) INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000 INFO: Licensed to: Oracle-Peoplesoft-ISV Booting admin processes ... exec BBL -A : process id=3004 ... Started. 1 process started. Attempting to boot ... INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level (none) INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000 INFO: Licensed to: Oracle-Peoplesoft-ISV Booting server processes ... exec PSWATCHSRV -A -- -ID 54448 -C psappsrv.cfg -D EPDMO -S PSWATCHSRV : process id=2500 ... Started. exec PSAPPSRV -s@..psappsrv.lst -s@..psqcksrv.lst -sICQuery -sSqlQuery:SqlRequ est -- -C psappsrv.cfg -D EPDMO -S PSAPPSRV : process id=1248 ... Started. exec PSAPPSRV -s@..psappsrv.lst -s@..psqcksrv.lst -sICQuery -sSqlQuery:SqlRequ est -- -C psappsrv.cfg -D EPDMO -S PSAPPSRV : process id=300 ... Started. exec PSAPPSRV -s@..psappsrv.lst -s@..psqcksrv.lst -sICQuery -sSqlQuery:SqlRequ est -- -C psappsrv.cfg -D EPDMO -S PSAPPSRV : process id=304 ... Started. exec PSSAMSRV -A -- -C psappsrv.cfg -D EPDMO -S PSSAMSRV : process id=3112 ... Started. exec PSMONITORSRV -A -- -ID 54448 -C psappsrv.cfg -D EPDMO -S PSMONITORSRV : process id=3092 ... Started. exec WSL -A -- -n //PEOPLESOFT2:7000 -z 0 -Z 0 -I 5 -T 60 -m 1 -M 3 -x 40 -c 500 0 -p 7001 -P 7003 : process id=3028 ... Started. exec JSL -A -- -n //PEOPLESOFT2:9000 -m 5 -M 7 -I 5 -j ANY -x 40 -S 10 -c 100000 0 -w JSH : process id=1184 ... Started. exec JREPSVR -A -- -W -P C:PT849appservEPDMOjrepository : process id=3208 ... Started. 9 processes started. -------------------------------- PeopleSoft Domain Administration -------------------------------- Domain Name: EPDMO 1) Boot this domain 2) Domain shutdown menu 3) Domain status menu 4) Configure this domain 5) TUXEDO command line (tmadmin) 6) Edit configuration/log files menu 7) Messaging Server Administration menu 8) Purge Cache 9) Preload File Cache 10) Clean IPC resources of this domain q) Quit Command to execute (1-10, q) : q -------------------------------------------- PeopleSoft Application Server Administration -------------------------------------------- 1) Administer a domain 2) Create a domain 3) Delete a domain 4) Import domain configuration q) Quit Command to execute (1-4, q) : q -------------------------------- PeopleSoft Server Administration -------------------------------- 1) Application Server 2) Process Scheduler 3) Search Server 4) Service Setup q) Quit Command to execute (1-4, q): q C:PT849appserv>
Step 6: To start the web server, click Start > Programs > Oracle – peoplesoftAS > Start SOA Suite.
Step 7: Oracle Application Server starts. Click Close.
Step 8: PeopleSoft is now accessible. On your laptop, point your web browser to http://peoplesoft2:8000/ps/signon.html and log on as user VP1.
Note: Do not log off the desktop of the PeopleSoft2 virtual machine as this will close the application server.
In a patch’s README file, the prerequisite patches and patch levels that must be in place before that patch is applied are listed. Patches are indicated by a patch number (usually seven digits long), for example, 4712852. Patch levels are usually of the form 11i.<PRODUCT CODE>.<LETTER>, for example, 11i.GL.H.
To determine if a particular prerequisite patch has already been applied to the system, query the AD_BUGS table.
Step 1: Source the environment to load SQL*Plus. Either the applications tier environment or database tier environment can be sourced.
[applmgr@appslinux /]$ cd /u2/oracle/vis2appl/ [applmgr@appslinux vis2appl]$ . APPSORA.env
Step 2: Load SQL*Plus:
[applmgr@appslinux vis2appl]$ sqlplus apps/apps
Step 3: To determine whether a particular patch has been applied, query the BUG_NUMBER column of the AD_BUGS table for the patch number. For example, to determine if the patch 4712852 has been applied to the system, issue this SQL query:
SQL> select bug_number, creation_date from ad_bugs where bug_number = '4712852'; BUG_NUMBER CREATION_DATE ------------------------------ ------------- 4712852 16-MAR-07
If the query returns a row, the patch has been applied, whereas if the query does not return any rows, then the patch has not been applied.
Step 4: To determine the patch level of a product, query the PATCH_LEVEL columns of the FND_PRODUCT_INSTALLATIONS table. For example, to determine the patch level for the GL product, issue this SQL query:
SQL> select patch_level, status from fnd_product_installations where patch_level like '%GL%'; PATCH_LEVEL S ------------------------------ - 11i.GL.H I
In web browser, navigated to http://shrivastava.test.int:7777/pls/apex. Received message:
Forbidden You don't have permission to access /pls/apex/apex on this server. ---------------------------------------------------------- Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at SHRIVASTAVA.TEST.INT Port 7777
Solution:
Password in the dads.conf (C:oracleproduct10.2.0http_1Apachemodplsql confdads.conf ) file is incorrect. Confirm by logging on to SQL*Plus as user APEX_PUBLIC_USER. Correct password, then bounce Apache web server.
Problem:
After configuring TNS names on the client, tried to connect to new 11.5.10.2 instance but failed.
Solution:
Managed SQL Access enabled. To disable, follow these steps:
Step 1: Login to E-Business Suite with the ‘System Administrator’ Responsibility.
Step 2: Go to : Profile –> System
Step 3: Query the Profile “SQLNet Access’ at Site Level.
Step 4: Set the Profile with the Value : ALLOW_ALL
Step 5: Save and Exit Oracle Applications
Step 6: Run Autoconfig on the 9i ORACLE_HOME
cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME
adautocfg.sh
Step 7: Bounce the 9i SQLNet Listener :
cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME
addlnctl.sh stop <SID>
addlnctl.sh start <SID>
Metalink Reference:
Subject: 11.5.10 New Features : Managed SQL*Net Access from Hosts
Doc ID: Note:291897.1
Problem:
After installing Oracle Applications 11.5.10.2, submitted Active Users report. Concurrent request fails with message
‘REP-3002: Error initializing printer’
Solution:
To implement the solution, please execute the following steps:
1. Define a dummy printer on the server to be defined as local printer.
2. Set this dummy printer to be the default.
3. Make the following updates in the registry, before making any changes to the registry you should always make a backup copy:
Complete path Regedit:
HKEY_USERSS-1-5-...............SoftwareMicrosoftWindows NTCurrentVersionDevices
You will find String value with name as the newly defined printer
Same goes to:
HKEY_USERSS-1-5-...............SoftwareMicrosoftWindows NTCurrentVersionPrinterPorts
You will find String value with name as the newly defined printer
HKEY_USERSS-1-5-...............SoftwareMicrosoftWindows NTCurrentVersionWindows
You will find String value with name “Device” and has value including the printer name as defined
All the above string values should also be set under the following paths for the valid printer to be seen by all users
HKEY_USERS.DEFAULTSoftwareMicrosoftWindows NTCurrentVersionDevices HKEY_USERS.DEFAULTSoftwareMicrosoftWindows NTCurrentVersionPrinterPorts HKEY_USERS.DEFAULTSoftwareMicrosoftWindows NTCurrentVersionWindows
Problem:
After installing Oracle Applications E-Business Suite 11.5.10.2 on Windows, the post installation checks (HTTP Check, JSP Check, PHP Check) fail.
Solution:
Install Microsoft XML (msxml3.msi) located in downloadsXML.
Recent Comments