Install Oracle Grid 11.2.0.3 Infrastructure it is an operation that you have to do the prerequisites in the section Installing and Upgrading from Oracle documetation before continue installing the Oracle Grid infrastructure. Then go to stage area to grid file and do the follow operation: unzip p10404530_112030_Linux-x86-64_3of7.zip In the grid directory, run the runInstaller and start the installation: In the “Download Software Update” section, select “Skip software update” option and click in “Next”. Click “Install and Configure Oracle Grid Infrasctruture for a Cluster”. Click “Advanced Installation” and “Next” . In…
Month: June 2015
MENU FOR ORACLE DATABASE ON IBM AIX
When you have several databases in the same server using also the same user, it is common human errors because wrong Oracle environmental variables configuration. Then below has a script that you can put in .profile file of the user own of Oracle Database files on IBM AIX: EDITOR=vi export EDITOR clear echo “Please choose the instance number” echo ” ” cont=0 awk -F: ‘ ! /^#|^$|^*/ {print $1,$2}’ /etc/oratab | while read par1 par2 do cont=`expr $cont + 1` inst[$cont]=$par1 orahome[$cont]=$par2 echo ” [ $cont ] ${inst[$cont]} ( ${orahome[$cont]}…
Configure Services using Policy Managed Method on Oracle RAC 11G
On the Oracle Real Application Clusters (Oracle RAC) 11G you can create services for clients use to connect to one or several instances using either Oracle Enterprise Manager or SRVCTL. Moreover, it is important you know the managed methods for configure the services and what are the activities that you can do in a service.The activities are show below: Delete a service Check the status of a service Start or stop a service for a database or an instance Map a service to a consumer group Enable or disable a…
Configure Services using Manual Managed Method on Oracle RAC 11G
On the Oracle Real Application Clusters (Oracle RAC) 11G you can create services for clients use to connect to one or several instances using either Oracle Enterprise Manager or SRVCTL. Moreover, it is important you know the managed methods for configure the services and what are the activities that you can do in a service.The activities are show bellow: Delete a service Check the status of a service Start or stop a service for a database or an instance Map a service to a consumer group Enable or disable a…
Configure archiving in Oracle Real Application Clusters (RAC) 11G
Configure archiving in Oracle RAC it is similar to configure archiving to a Oracle Single Instance. But on Oracle RAC you have to stop the instances for the database and configure . I will show an example in the environment where the database it is named bd. First, you have to stop the database: srvctl stop database -d bd After check the status: Start one instance in mount state. startup mount Configure archiving and opening the database: Start the instance where the state is down (In our case bd2) and…
Create Enterprise Manager User in OEM Grid Control 11G
Using Oracle Enterprise Manager, you can 3 types of authentication schemes: Repository-Based Authentication: Default authentication option. SSO-Based Authentication:The single sign-on authentication. Enterprise User Security Based Authentication: Users for Oracle database in LDAP server. Therefore, OEM has 3 types of acess: Super Administrator: Can do anything. Administrator: Can do what you define. Repository Owner: Database administrator for the Management Repository. To create use in OEM it is very easy, you have to do the follow steps: Go to OEM Grid Control Page Click “Setup” -> Click “Administrators” -> Click “Create” ->…
Creating alerts in OEM DB Control 11G
In the Oracle Enterprise Management you can create alerts for users. This alerts can be OS_BASED (using scripts) or SQL_BASED (using PL/SQL queries). In this post I will show an example about this alerts. OS_BASED: For to do an alert using scripts , before you must do a script to put it in the OEM metrics. Then, I will use a script from Oracle’s Documentation: #!/usr/bin/perl # Description: 5-min load average. # Sample User Defined Event monitoring script. $ENV{PATH} = “/bin:/usr/bin:/usr/sbin”; $DATA = `uptime`; $DATA =~ /average:s+([.d]+),s+([.d]+),s+([.d]+)s*$/; if (defined $2)…
Creating notifications using Oracle Enterprise Manager (OEM) DB Control 11G
There are several types to do a notification using Oracle Enterprise Manager as notification by e-mail, by script, by PL/SQL , SNMP and so on. Here I will show how to do a notification to an e-mail and another notification to a script in a server that OMS (Oracle Management Service) is located. Then … hands-on : In OEM click “Setup” -> “Notification Methods” . In this section you have to complete some informations: Outgoing Mail (SMTP) Server = “smtp.brunors.com:587″ User Name = “open2kg@brunors.com” Password / Confirm Password = “XXXXXXXXXX”…