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
/libawt.so: libXp.so.6: 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 libclntsh.so.11.1: 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 11.5.10.2 environment
Check DISPLAY variable is set
Check REPORTS60_PATH ha sthe location of?? the custom reports rdf files
Issues after upgrading 11.5.10.2 Apps database to 11g Release 2 while running adbldxml.pl 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 adbldxml.pl 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
ADJVAPRG=”/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/bin/java”
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 adbldxml.pl 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
./template/txkcreateACL.sql
./install/CLMTS11G_kens-orasql-001/txkcreateACL.sql
While running autoconfig errors encountered for afdbprf.sh and adcrobj.sh
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 11.2.0.1
10.2.0,4 database has DST version 4 and 11.2.0.1 databass it is version 11.
If we use DBUA version 11.2.0.2 or 11.2.0.3, then the Timezone version is automaticallt upgraded and we do not have to do it manually as in the case of an upgrade to 11.2.0.1.
Follow post to upgrade database time zone version :
https://gavinsoorma.com.au/2011/06/upgrading-to-11g-release-2-and-dst-updates/
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 rwdiag.sh or rwdiag.bat command to list all the reports servers running in our network with the -findall option.
Like:
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=”228.5.6.7″ port=”14021″ timeout=”1000″ retry=”3″/>
to
<multicast channel=”228.5.6.7″ 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
asmdba:x:506:grid,oracle