Installing Oracle 11gR2 on 64 bit OEL or Red Hat 5.x

Need these RPM’s:

  • libaio-devel-0.3.106 (i386)
  • libaio-devel-0.3.106 (x86_64)
  •  sysstat-7.0.2
  •  unixODBC-2.2.11 (i386)
  • unixODBC-2.2.11 (x86_64)
  •  unixODBC-devel-2.2.11(i386)
  • unixODBC-devel-2.2.11(x86_64)


 Installing Oracle 10g R2 on Linux 64 bit

Need these RPM’s otherwise you will get this error when running the installer

/ cannot open shared object file: No such file or directory

  • libXp-1.0.0-8.1.el5.x86_64.rpm
  • libXp-devel-1.0.0-8.1.el5.i386.rpm

 Resolving the APP-FND-01931 error

If you get the error like this and you are on Windows 7 with IE9

Error: APP-FND-01931: Your session is no longer valid or your logon information could not be reestablished from your session

Go to Security > Custom Level > Scripting > Enable XSS filter  – Set it to Disable


ggci cannot restore segment prot after reloc: Permission denied

 After installing GoldenGate 11g on Linux x86-64, we were getting this error whenever we issued the ggsci command.

We found that this was because when the machine was built, the System Administrator had configured SELinux to ‘enforcing’.

To fix this we can do the following:

temporary fix – as root

/usr/sbin/setenforce 0

 Or to make the change permanent, edit the /etc/selinux/config file and change SELINUX=enforcing to SELINUX=disabled. We may to reboot the machine for this change to take effect.


WARNING OGG-01194  EXTRACT task LOAD2 abended : There is no trail to reposition to when doing direct load task

The cause was that the GoldenGate user did not have the privileges needed to insert rows into the target database.

It was solved by grant the insert any privilege: grant insert any table to ggs_owner;


Error: The requested URL was not found, or cannot be served at this time

Running custom reports using a environment

Check DISPLAY variable is set

Check REPORTS60_PATH ha sthe location of?? the custom reports rdf files


Issues after upgrading Apps database to 11g Release 2 while running and adconfig on database tier


JRE_TOP not found at its desired location /u01/app/oracle/product/11.2.0/dbhome_1/jre/1.1.8

Needed to point jtop to the 10g ORACLE_HOME jre location as the 11g ORACLE_HOME does have the jre directory

perl tier=db appsuser=apps_applfnd jtop=/u01/app/oracle/product/10.2.0/db_1/jre/1.4.2

ERROR: Unable to set CLASSPATH
     JDBC Driver jars and zips are missing in /u01/app/oracle/product/11.2.0/dbhome_1/jdbc/lib directory.

Change ADJVAPRG variable defined in environment file on database server to point to jdk directory and not the jre directory which is not present in the 11g ORACLE_HOME


Perl 5.8 and 5.10 version conflicts

Perl lib version (5.10.0) doesn’t match executable version (v5.8.8)

11g comes with Perl 5.10  while 10g and 11.5.10 use Perl 5.8. Autoconfig and exited with errors related to perl versions.

By default it was using perl in /usr/bin which was perl 5.8

Had to create a symbolic link to point to perl residing in the Oracle 11g home

 perl -> /u01/app/oracle/product/11.2.0/dbhome_1/perl/bin/perl

 Issue when running autoconfig because APPS user was not named APPS – in our case it is APPS_APPLFND

ORA-44416: Invalid ACL: Unresolved principal ‘APPS’
ORA-06512: at “SYS.DBMS_NETWORK_ACL_ADMIN”, line 252

Had to edit template files under $ORACLE_HOME/appsutil and change all occurences of APPS to APPS_APPLFND in the file txkcreateACL.sql


 While running autoconfig errors encountered for and

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

This is because the Database Time Zone Upgrade was not performed when the database was upgraded from 10g to

10.2.0,4 database has DST version 4 and databass it is version 11.

If we use DBUA version or, then the Timezone version is automaticallt upgraded and we do not have to do it manually as in the case of an upgrade to

Follow post to upgrade database time zone version :


Error while starting 10.1.2 Reports Server – Server repserver_xxx already exists in the network

This problem can occur if you have say two environments like UAT and PROD in the same network subnet and the report servers have been configured with the same name.

We can run the or rwdiag.bat command to list all the reports servers running in our network with the -findall option.


  rwdiag.bat -findall

If we cannot use different names for the reports server in both environments, we need to edit the rwnetwork.conf file located under the $ORACLE_HOME/reports/conf directory and change the port number from the default 14021 to say 14022.  First stop opmnctl before making the change and then start opmn. Remember to take a backup of the rwnetwork.conf file.

for example change this line

<multicast channel=”″ port=”14021″ timeout=”1000″ retry=”3″/>


<multicast channel=”″ port=”14022″ timeout=”1000″ retry=”3″/>


 RMAN ASM Migration and receiving ORA-01031, ORA-15001 and ORA-19504 errors

RMAN-03009: failure of backup command on ch4 channel at 06/25/2012 14:47:11
ORA-19504: failed to create file “+DATA”
ORA-01031: insufficient privileges
ORA-15001: diskgroup “DATA” does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges

This was because 11gR2 Grid Infrastructure role seperation was being used and the Oracle Database software owner (oracle) was not a member of the asmdba group.

The Grid Infrastructure owner(grid) was member of both asmadmin as well as asmdba groups.

Problem was fixed by making oracle a member of the asmdba group.

uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),506(asmdba) context=user_u:system_r:unconfined_t

[visionr12:oracle:/home/oracle:] id
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba) context=user_u:system_r:unconfined_t

[root@pdemvoel100 ~]# usermod -G dba,asmdba oracle

[root@pdemvoel100 ~]# cat /etc/group |grep asmdba