Tuesday, August 31, 2010

Instructions to download Cobol 5 for PeopleSoft

* Go to E-Delivery, http://edelivery.oracle.com, and login by providing the requested information.

* On the search page, select the following from the drop down menus:
o Select a Product Pack = PeopleSoft Enterprise
o Platform = Linux x86

* On the search results page, scroll down and click on the Third Party – Micro Focus 5.0 for PeopleSoft Enterprise Media Pack link.

* On the download components page, download the following files associated with Server Express for Linux x86.
o V14660-01, PeopleSoft Enterprise COBOL Quick Reference Guide - Version 9
o B45429-01, Micro Focus Server Express 5.0 Wrap Pack 4 Extras Install Documentation for PeopleSoft and Runtime Licenses (Read "Readme" file located on this disk for instructions) (CD)
o B45428-01, Micro Focus Server Express 5.0 Wrap Pack 4 for PeopleSoft Documentation CD
o B45424-01, Micro Focus Server Express 5.0 Wrap Pack 4 for PeopleSoft for Red Hat Linux and SuSE Linux (CD) (installation files)

* Please note that the installation CD (B45424-01) contains .tar files which are the correct file extension for Linux install files.

Sunday, August 29, 2010

ORA-16014: log 4 sequence# 20 not archived, no available destinations

RAC environment with ASM.

While try to open the database, got the following error:

SQL> alter database open;alter database open*ERROR at line 1:ORA-16014: log 4 sequence# 20 not archived, no available destinationsORA-00312: online log 4 thread 2:'+PASS_DATA/upstrprd_prime/onlinelog/group_4.266.720285169'ORA-00312: online log 4 thread 2:'+PASS_FLASH/upstrprd_prime/onlinelog/group_4.260.720285169'

Looks like some online log files are corrupted.

The solution:

SQL> alter database clear unarchived logfile group 4;
Database altered.
SQL> alter database open;alter database open*ERROR at line 1:ORA-16014: log 3 sequence# 21 not archived, no available destinationsORA-00312: online log 3 thread 2:'+PASS_DATA/upstrprd_prime/onlinelog/group_3.265.720285169'ORA-00312: online log 3 thread 2:'+PASS_FLASH/upstrprd_prime/onlinelog/group_3.259.720285169'
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> alter database open;
Database altered.
SQL>

Perform a backup after open the database.

Wednesday, August 25, 2010

PeopleTools 8.49 installation on ZLinux

JAVA 6 is installed.

Got the following errors when installing:

Verification failed for /opt/ibm/java-s390x-60 using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm
Verifying... /opt/ibm/java-s390x-60/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/ibm/java-s390x-60 using the JVM file /tmp/istemp19471236113223/sunjre15.jvm
JVM specified with -is:javahome cannot be verified with the JVM files specified with the launcher. Environment Variables will be checked next...
Checking the environment variables specifed in the JVM files to find the JVM...
Verifying... /usr/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
$JDK_HOME is not defined in the shell environment specifed in the JVM FILE sunjdk15.jvm
$JAVAHOME is not defined in the shell environment specifed in the JVM FILE sunjdk15.jvm
A jvm found at /opt/ibm/java-s390x-60/bin/java
Verifying... /opt/ibm/java-s390x-60/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/ibm/java-s390x-60/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
Verifying... /usr/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
$JDK_HOME is not defined in the shell environment specifed in the JVM FILE sunjre15.jvm
$JAVAHOME is not defined in the shell environment specifed in the JVM FILE sunjre15.jvm
A jvm found at /opt/ibm/java-s390x-60/bin/java
Verifying... /opt/ibm/java-s390x-60/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/ibm/java-s390x-60/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
No JVM can be found using the shell environment variable. Searching JVM will continue with Path Hints specified in the JVM Files...
--------------------------------------------------------------------------------------------
Searching a JVM using /tmp/istemp19471236113223/sunjdk15.jvm
Verifying... /opt/IBMJava2-s390-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/IBMJava2-s390-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
Verifying... /opt/IBMJava2-s390x-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/IBMJava2-s390x-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
Verifying... /opt/IBMJava2-s390-142/jre/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/IBMJava2-s390-142/jre/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
Verifying... /opt/IBMJava2-s390x-142/jre/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/IBMJava2-s390x-142/jre/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
Verifying... /opt/IBMJava2-s390-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/IBMJava2-s390-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
Verifying... /opt/IBMJava2-s390x-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.version
Verification failed for /opt/IBMJava2-s390x-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjdk15.jvm.
--------------------------------------------------------------------------------------------
Searching a JVM using /tmp/istemp19471236113223/sunjre15.jvm
Verifying... /opt/IBMJava2-s390-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/IBMJava2-s390-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
Verifying... /opt/IBMJava2-s390x-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/IBMJava2-s390x-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
Verifying... /opt/IBMJava2-s390-142/jre/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/IBMJava2-s390-142/jre/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
Verifying... /opt/IBMJava2-s390x-142/jre/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/IBMJava2-s390x-142/jre/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
Verifying... /opt/IBMJava2-s390-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/IBMJava2-s390-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
Verifying... /opt/IBMJava2-s390x-142/bin/java -cp /tmp/istemp19471236113223/Verify.jar Verify java.vendor java.version
Verification failed for /opt/IBMJava2-s390x-142/bin/java using the JVM file /tmp/istemp19471236113223/sunjre15.jvm.
Extracting bundled JRE...
checking disk space on the parition /tmp/istemp19471236113223 for /tmp/istemp19471236113223/linux-sun-1.5.0.bin
60962 512 bytes disk blocks required.
Cheking for disk quotas...
USER=mukeshb
LINE=
WORDS=0
Disk quota command not enabled.
44082520 512 bytes disk blocks available on the partition /tmp/istemp19471236113223
Disk space check on the parition /tmp/istemp19471236113223 succeeded.
checking disk space on the parition /tmp/istemp19471236113223 for /tmp/istemp19471236113223/linux-sun-1.5.0.bin
Bundled JRE is not binary compatible with host OS/Arch or it is corrupt. Testing bundled JRE failed.

Solution: install JAVA 5.

Data pump problem ORA-39071: Value for EXCLUDE is badly formed.

I tried to use datapump to import a whole database but I want to include sys and system. I specified exclude=schema:sys,system and got the following errors:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options

ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00920: invalid relational operator
ORA-06512: at "SYS.KUPM$MCP", line 2687


Solution: "exclude=schema:\"='SYS'\"" "exclude=schema:\"='SYSTEM'\""

Reference Oracle note 734324.1 .