Page Expired Message Using Oracle EM Cloud Control 12c
A very common and annoying issue you will encounter when using Oracle Enterprise Manager Colud Control 12c is the Page Expired message after certain interval.
Page Expired
“The Page has expired. Click OK to continue.”
By default Session Timeout is set to 45 minutes after which your page expires if there is no activity by your session. This feature is controlled by maxInactiveTime.
To increase the Session Timeout and avoid frequent Page Expired issue you can set this value as per your requirement. Setting its value to -1 will keep your session forever without expiring.
Oracle Enterprise Manager Cloud Control 12c (12.1.0.4) Installation
This article provide steps to install Oracle Enterprise Manager Cloud Control 12c(12.1.0.4) on Linux X86_64bit(RHEL 5) platform in graphical mode.
You should have an Oracle database up and running that can be used as Management Repository, before you start the installation. My Management Repository database is running on the same host where I would be installing OEM Cloud Control 12c(OMS.You can have your repository database running on a different host as well.
Before you begin ensure following prerequisites should be on the host server.
Packages (RPM’s)
make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libaio-0.3.106
glibc-2.5- 12
glibc-common-2.3.4
libstdc++ -4.1.1
setarch-1.6
sysstat-5.0.5
rng-utils-2.0
libXtst-1.0.1-3.1(x86_64)
xorg-x11-utils
ORA-01102 ORA-09968 Error While Starting Oracle Database
You might encounter following error while starting Oracle database. This might happen when database or the server got crashed due to some reason.
SQL> startup ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2232960 bytes Variable Size 285216128 bytes Database Buffers 541065216 bytes Redo Buffers 6590464 bytes ORA-01102: cannot mount database in EXCLUSIVE mode
GoldenGate : ggsci: error while loading shared libraries: libnnz11.so
Following error might encountered while intializing ggsci prompt for Oracle Golden Gate.
[oracle@test1 gg_home]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory
This error is encountered as ggsci is unable to locate lib files which are available under database ORACLE_HOME.
This error can be avoided by two ways.
Read more…
Convert Database To ASM While Upgrading to 11g via RMAN
This article helps you to convert your database residing on filesystem to ASM during 11g upgrade on to a new server. The best part is that the conversion to ASM, migration to new server and upgrade to 11g can all be done simultaneously without having it to break up in phases.
We can recover the database to a new server from the last backup and upgrade the database after restoration via RMAN.
I have used below environment to perform this test.
Source
Hostname : OLXPTEST1
Operating System : OEL 5.3 (32 bit)
Oracle Version : 10.2.0.5
Target
Hostname : OLXTEST2
Operating System : OEL 6.1 (32 bit)
Oracle Version : 11.2.0.2
Grid Infrastructure Version : 11.2.0.2
Read more…
Oracle 11.2 Standalone Database Creation Using ASM Manually
In this article we will see how we can configure 11.2 standalone database with ASM manually. You might have to create ASM instance manually when you want to have allocation unit (AU_SIZE) other than 1 MB(default). For 11.2.0.1 and 11.2.0.2 Grid Installation OUI or AMSCA does not have provision to modify allocation unit while creating the instance. This feature is available from 11.2.0.3 ASMCA.
Following environment was used to test this setup on VMWare.
Operating System : OEL 5.3 (32 bit)
Oracle Version : 11.2.0.2
Grid Infrastructure Version : 11.2.0.2
The approach would remain same for different 11.2 patchset on Linux platform.
We will NOT be covering installation of VMWare, guest OS and VMWare tools in this article. You can find lot of articles helping you to do this.
So lets start with list of tasks that needs to be done to accomplish our goal.
- Install Missing RPM packages
- Add disks at OS level for ASM
- Create oracle user and directories
- Set Kernel Parameters
- Install ASMLib and configure devices
- Install Grid Infrastructure Binaries
- Install Oracle Database Binaries
- Start CSSD service
- Create ASM Service & Instance
- Create Database Service & Instance
ORA-16179 While Changing The Archive Destination
You might encounter ORA-16179 error while changing the archive destination.
SQL> ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 12 Next log sequence to archive 13 Current log sequence 13 SQL> ALTER SYSTEM SET log_archive_dest_1='C:\oracle\db\ora11g\admin\adump'; ALTER SYSTEM SET log_archive_dest_1='C:\oracle\db\ora11g\admin\adump' * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
How To Create Oracle 11g Database Manually on Windows
Below steps will help you to create 11.2.0.1 oracle database manually on windows platform. These steps would remain same on all the Windows version such as XP, Vista etc. Before starting the creation of the database, ensure you have Oracle Database binaries installed.
1. Set up environment variables
C:\>set ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1 C:\>set PATH=%ORACLE_HOME%\bin;%PATH% C:\>set ORACLE_SID=ORA11G
List of Oracle Database Patch Set Updates (PSU)
Below is the list of all the Oracle Patch Set Updates (PSU) for 10gR2, 11gR1, 11gR2 and 12cR1.