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…
Year: 2015
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”…
RMAN backup of archivelog files with ‘skip inaccessbile’ returns error/ RMAN-06061: WARNING: skipping archived log compromises recoverabilit
During a backup execution, I saw this warning “RMAN-06061: WARNING: skipping archivelog compromises recoverability” follow by “RMAN-00600: internal error, arguments [13200] [] [] [] []”. Then, searching in the MOS (My Oracle Support) I found this ID [341337.1] where I got the answer. Basically, you have to do this steps: RMAN> Resync catalog ; RMAN> Crosscheck archivelog all ; RMAN> delete expired archivelog all ; After, run your backup again with “SKIP Inaccessible option”, if failed again, try rerun without “SKIP Inaccessible option”. I hope this post can help you!…
What’s my port number in Oracle Enterprise Manager (OEM)?
I was trying to remember the port number of my Oracle Rac in Oracle Linux. Then, I find this information in $ORACLE_HOME/install/portlist.ini. In this case the port number was 1158 (the default number), but it is important you know about this file because it can help you in other situation. Also you can find this information in $ORACLE_HOME/Oracle_sid/sysman/config/emd.properties by variable REPOSITORY_URL: I hope this post can help you. More informations in : Oracle® Database 2 Day DBA 11g Release 2 (11.2) Part Number E10897-06 brunors
My first Oracle RAC :)
After two weeks that I have been studying a lot … I finally did my first Oracle Rac 🙂 Nobody can possibly know what you might consider easy or difficult. The best way to find out is to try it. brunors
HOW TO EXTRACT DLL FOR TEMPORARY TABLESPACE ON ORACLE DATABASE
I was needing to extract DDL for temporary tablespaces on Oracle Database . Then, I took the information about it using a DBMS_METADATA. Thus, follow how to take this information: SQL> set heading off; SQL> set echo off; SQL> set pages 2000 SQL> set long 99999 SQL> spool tablespace_temp.sql SQL> select dbms_metadata.get_ddl('TABLESPACE', tablespace_name) from dba_temp_files; ##HERE WILL BE SHOW TEMPORARY TABLESPACES DLL ABOUT YOUR DATABASE## SQL> spool off I hope this post can help you! See ya, Bruno Reis brunors
CONNECT USER USING GRANT CONNECT THROUGH
Oracle Database has a grant that you can use to connect through another user. For example, I have the use ”A” and I want to connect with this user through the user ''brunors''. It possible to do it, but you need to give the grant connect through to user ''brunors''. I am going to show how it works now.. Let’s go… SQL> create user brunors identified by <brunors’s password here>; User created. SQL> grant connect , resource , create session to brunors; Grant succeeded. SQL> ALTER USER A GRANT CONNECT…
Get the body of the procedures in Oracle
Follow below get the body of the procedures in Oracle Database: SQL> SELECT text FROM all_source WHERE name='&name' ORDER BY line; brunors