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 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. brunors

Installing Oracle Linux 5.4 – 32 bits on Oracle VM VirtualBox – Part 1

In this section I will explain the first part about the simple installation of Oracle Linux 5.4- 32 bits on Oracle VM VirtualBox. The media can be found on Oracle Software Delivery Cloud – Oracle Linux and Oracle VM  (https://edelivery.oracle.com/linux), when was downloaded on 01 January 2015. After login using your Oracle account (If you don’t have one, you must  do), read the text and mark the options ”     I have reviewed the terms of the License Agreement or the Oracle License Agreement above and accept its terms ” …

How to extract DDL for all tablespaces on Oracle Database

I was needing to extract  DDL for all 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 lines 2000 SQL> set long 99999 SQL> spool ddl_tablespaces.sql SQL> select dbms_metadata.get_ddl(‘TABLESPACE’, tablespace_name) from dba_tablespaces  ; ##HERE WILL BE SHOWN ALL  TABLESPACES DLL ABOUT YOUR DATABASE## SQL> spool off I hope this post can help you! brunors

Oracle 11g Enterprise Manager DB Control Changing Accessibility Mode Disabled to Enabled

I was using the OEM11G, when after the logon with my credential users, I saw the follow message “Accessibility Mode Disabled” as the image below: To solve it, you need to change the status of the accessibility-mode in the file “uix-config.xml”. This file can be found on directory:  $ORACLE_HOME/j2ee/OC4J_EM/applications/em/em/WEB-INF/. Then, you need to do the follow steps: vi $ORACLE_HOME/j2ee/OC4J_EM/applications/em/em/WEB-INF/uix-config.xml (Look the status “inaccessible” in the picture below): Change the status of the accessibility mode in the file  from inaccessible to accessible. After you changed the accessibility mode, save and close…