Environment information:
Oracle Grid Infrastructure 12c - 12.1.0.2.0
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Oracle Grid Infrastructure with three nodes:
node1 - running instance TESTDB1
node2 - ( instance TESTDB2 should be relocated on this node )
node3 - running instance TESTDB2
Hello :)
We as DBA all the time thinking how to avoid doing the same task twice by implementing different kind of improvement like automation scripts.
Case from today is following...
For internal purposes there are requirements to implement process for Oracle DB account creation and password creation with special mask.
This user account management process have been created by using 1 function and 1 procedure, function will generate password in randomly by using special password mask and procedure for actual user creation.
By simple search in google I found following idea for password generate function http://www.moeding.net/archives/27-Another-PLSQL-password-generator.html
Start with the implementation of:
1. Procedure for user creation..
2. Function for passowrd generate
During the BGOUG event I have discovered a lot of new features which should be tested and validated and this make me drive to install new version of Oracle 12cR2 :)
You can simple download - Oracle Database 12c Release 2 Enterprise Edition and Oracle Database 12c Release 2 Standard Edition from following link -> http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
In order to install Oracle Software there are requirement to install Linux or other supported OS/platform and configure as per the vendor pre-requisites
Very useful starting point for all required pre-requisites - https://oracle-base.com/articles/12c/oracle-db-12cr2-installation-on-oracle-linux-6-and-7
In the past days some of my colleagues just ask me... "Do you know where i can find Jan PSU for 11.2.0.4 database" ???
Hmm... Good question it should be in the Metalink.. BUT Oracle set "there's no database/GI PSU for this cycle", check the below Metalink
Will there be a Jan 2017 11.2.0.4 Database/Grid Infrastructure PSU? (Doc ID 2224560.1)
After a lot of work today, i try to get some time to share very short finding which is very useful in order to prevent the max process on ASM instance.
There was an issue with one of the newly created Oracle GI 12c - 12.1.0.2 due to massive migration and ASM instance report error ORA-00020: maximum number of processes. This problem lead to a lot of unnecessary communication for downtime in order to fix ASM instance by adding more processes :)