Tags » Oracle

Instance Startup Fails Due To GEN0

Recently a server running both Oracle DB and had to be forced powered cycled due to a NFS issue. Since it wasn’t possible to login to the O/S to shutdown the DBs an instance recovery had to performed on both the 12.1 and 11.2 databases. 543 more words


Meta Characters in Oracle

Meta characters are the characters in a programming language that are interpreted by the programming language to have specific meanings within the language itself.

Meta characters are normally simple characters. 656 more words


Oracle 11g installation on Oracle Enterprise Linux

Oracle 11g installation on Oracle Enterprise Linux 5

  • Add Required User and Groups

>>Switch as root<<

groupadd oinstall

groupadd  dba

groupadd oper

useradd –g oinstall –G dba,oper –d /home/oracle oracle… 740 more words

System Administration

On an eastern hemisphere of the earth; on a cold night, a soul quietly whispered a hesitant prayer. Looking up into the moonlit sky from a window of a dark room, a heart was emptied in agonizing pain with a deep inner cry:

219 more words

Oracle Database Appliance Network change post deployment.

One of the project I recently worked on was changing our ODA’s network to 10gb using SFP+ ports. The test ODA, I used was ODA V1. 197 more words


how to identify a static or dynamic parameter in Oracle

How to identify any parameter as static or dynamic ?

Answer:   Check for v$parameter we can find one column ie. ISSYS_MODIFIABLE

select name, value, issys_modifiable from v$parameter ; 38 more words