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
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.
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
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;
TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation IBM/AIX RISC System/6000 Error: 1: Not owner
I was trying to start the Listener when … Welcome to LSNRCTL, type “help” for information. LSNRCTL> set curr LISTENER_DB Current Listener is LISTENER_DB LSNRCTL> start Starting /oracle/PIQ/112_64/bin/tnslsnr: please wait… TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production System parameter file is /oracle/DB/112_64/network/admin/listener.ora Log messages written to /oracle/diag/tnslsnr/host/listener_db/alert/log.xml Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=DB.WORLD)) TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation IBM/AIX RISC System/6000 Error: 1: Not owner Then, I check whether the directory /var/tmp/.oracle or /tmp/.oracle there are in the server. After that, I renamed…
Example using sec_case_sensitive_logon to case sensitivity on Oracle Database
Oracle Database has a parameter that you can define case sensitivity on users’s logon. This parameter is called SEC_CASE_SENSITIVE_LOGON and has default setting to TRUE (enabling case sensitivity). Then, follow an example using this parameter: SQL> conn /as sysdba Connected. SQL>show parameters sec_case NAME TYPE VALUE ——————————- ———- ————————- sec_case_sensitive_logon boolean TRUE SQL> create user brunors identified by techdatabasket; User created. SQL> grant connect, resource, create session to brunors; Grant succeeded. SEC_CASE_SENSITIVE_LOGON = TRUE: SQL> conn brunors/techdatabasket Connected. SQL> show user USER is “BRUNORS” SQL> conn brunors/TECHDATABASKET ERROR: ORA-01017:…
How to extract DDL for all users on Oracle Database
I was needing to extract DDL for all users 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> set lines 2000 SQL> spool ddl_users.sql SQL> select dbms_metadata.get_ddl(‘USER’,username) FROM dba_users; ##HERE WILL BE SHOWN ALL DLL USERS OF YOUR DATABASE## SQL> spool off I hope this post can help you!
How to extract DDL for all roles on Oracle Database
I was needing to extract DDL for all roles 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 ddl_roles.sql SQL> select dbms_metadata.get_ddl('ROLE', ROLE) from dba_roles; ##HERE WILL BE SHOW ALL ROLES DLL ABOUT YOUR DATABASE## SQL> spool off I hope this post can help you! See ya, Bruno Reis.