Problem: When running AutoConfig on the apps tier on Windows 2008, the following error occurs. Checked D:\ORACLE\PROD\inst\apps\PROD_testsrv2\admin\log\09061418\adconfig.log:
ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
Solution:
Timezone on Windows 2008 is: (UTC-04:00) Georgetown, La Paz, Manaus, San Juan
Shut down database and change time zone to (UTC-04:00) Santiago.
Problem: After laying down R12 filesystem and starting up the database, the following error occurs:
SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1352100 bytes Variable Size 427822684 bytes Database Buffers 629145600 bytes Redo Buffers 13012992 bytes ORA-00205: error in identifying control file, check alert log for more info SQL> startup pfile=D:\ORACLE\MFGP\mfgpdb\11.2.0\database\initMFGP.ora ORA-00401: the value for parameter compatible is not supported by this release
Solution: Oracle Database 11.1.0 comes bundled with R12 and the Oracle Service was created using the 11.1.0 Oracle Home. However, the database was upgraded to 11.2.0. Delete the Oracle service (OracleServiceMFGP) using oradim, and recreate using the oradim in the 11.2.0 Oracle home.
Problem:
When running OUI, it states that patches IZ41855, IZ51456, and IZ52319 are missing.
# instfix -i -k IZ41855 There was no data for IZ41855 in the fix database. # instfix -i -k IZ51456 There was no data for IZ51456 in the fix database. # instfix -i -k IZ52319 There was no data for IZ52319 in the fix database. # oslevel -s 6100-08-01-1245 #
Solution:
These patches can be ignored because AIX 6.1 is patched to the latest level.
Problem:
While installing Oracle Database 11gR2 on AIX 6.1, OUI reports that not enough swap space is available. Oracle Installer reports that the swap size is 4GB. It should be about 7.5GB.
Solution:
Increase swap space by using the ‘extendlv’ command.
Problem:
When creating the Enterprise Manager Database Control repository, the following error is displayed:
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Solution:
Ensure that the IP address and hostname are correctly set, as well as the ORACLE_HOSTNAME environment variable.
Here is a list of some RMAN commands I frequently use:
1. To connect to RMAN without a repository:
rman target /
2. To crosscheck backups:
crosscheck backup;
3. To list expired backups:
list expired backup;
4. To delete expired backups:
delete expired backup;
5. To set a disk destination for backups:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘E:backupDEV1%U’;
6. To include a maximum size of 2GB for backupset pieces:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G FORMAT ‘E:backupDEV1%U’;
7. To execute a backup to the default location:
backup database;
8. To restore and recover datafile 30:
run {
restore datafile 30;
recover datafile 30;
}
Problem:
After applying latest OS updates (October 9, 2012) on Windows XP SP3, Internet Explorer 7 (IE7) can no longer connect to Oracle Enterprise Manager (11g) via SSL (https). Firefox is able to connect to OEM.
Solution:
Update for Windows XP (KB2661254-V2) affecting certificates. Quick fix: from Add/Remove Programs, check ‘Show updates’, remove Update for Windows XP (KB2661254-V2) and reboot.
Note that removing Windows updates may affect your computer’s security. Proceed at your own risk.
*** UPDATE: Oracle has fixed the issue in MOS ID: 1489557.1 (EM Grid Control 11g Console Not Accessible Via Internet Explorer After Applying Microsoft Security Patches On Client PC)
Reference:
Microsoft Security Advisory (2661254): Update For Minimum Certificate Key Length
http://technet.microsoft.com/en-us/security/advisory/2661254
Microsoft Security Advisory (2749655): Compatibility Issues Affecting Signed Microsoft Binaries
http://technet.microsoft.com/en-us/security/advisory/2749655
Read more »
Problem:
After creating an spfile on an 11g instance (11.1.0.7) on R12.1.3 on Windows 2008, it does not automatically appear when the ‘show parameter spfile’ command is issued in SQL*Plus.
Solution:
When the database is started via the Windows Services panel, it seems that the pfile is used by default, even though the spfile may have been created. Stop and start the database via SQL*Plus to see the spfile.
Problem:
When loading data via SQL*Loader into a table on an 11g database, the following message appears:
SQL*Loader-404: Column CHAR present more than once in APPS.TMP_HRDPV_CREATE_IN_CWK's INTO TABLE block.
Solution:
In the SQL*Loader control file, the column names had comma after them. There should be whitespace, and then CHAR followed by comma.
Problem:
Unable to connect to SQL:
F:oracleVIS12dbtech_st11.1.0>sqlplus / as sysdba SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 27 11:31:04 2012 Copyright (c) 1982, 2008, Oracle. All rights reserved. ERROR: ORA-12518: TNS:listener could not hand off client connection
Solution:
Increase PROCESSES initialization parameter.
Use the following command to check the value of the PROCESSES initialization parameter in SQL*Plus:
show parameter processes
If the database was started using an spfile, then the following command can be used to change the PROCESSES initialization parameter to 500:
alter system set processes=500 scope=spfile;
If the database was started using a pfile, then the value of the processes parameter must be changed in the pfile and the database bounced.
[amazon asin=0071780262&template=iframe image&chan=default] [amazon asin=1565922379&template=iframe image&chan=default] [amazon asin=1430236620&template=iframe image&chan=default]
Recent Comments