Oracle Database Administration, Pl SQL, App DBA Discussions

like1

Oracle Apex

What is Oracle APEX???

Oracle Application Express (Oracle APEX), is the low code web application development tool for the Oracle database. Application Express enables you to design, develop and deploy beautiful, responsive, database-driven applications, either on-premises or in the cloud. Using only a web browser and limited programming experience, you can rapidly develop and deploy professional applications that are both fast and secure for any device from desktop to mobile.

Oracle Dataguard

Oracle Dataguard Concepts:

Oracle dataguard consists of one Primary database which is production and one or more standby databases, connected with oracle net.

Primary Database:

Primary database is the one which serves as production.

Standby Database:

Standby databases are always in synch with the primary database and are ready to serve as production in any case where primary is unavailable. Standby databases are of three types:

Oracle Apex

What is Oracle APEX???

Oracle Application Express (Oracle APEX), is the low code web application development tool for the Oracle database. Application Express enables you to design, develop and deploy beautiful, responsive, database-driven applications, either on-premises or in the cloud. Using only a web browser and limited programming experience, you can rapidly develop and deploy professional applications that are both fast and secure for any device from desktop to mobile.

Oracle Dataguard

Oracle Dataguard Concepts:

Oracle dataguard consists of one Primary database which is production and one or more standby databases, connected with oracle net.

Primary Database:

Primary database is the one which serves as production.

Standby Database:

Standby databases are always in synch with the primary database and are ready to serve as production in any case where primary is unavailable. Standby databases are of three types:

New Features in Oracle 12c

  1. Online renaming and relocation of datafile.

    SQL> alter database move datafile ‘location 1 (ASM/ NON-ASM)’ to ‘location 2 (ASM/ NON-ASM)’;

  • OVERWRITE

    SQL> alter database move datafile ‘location 1 (ASM/ NON-ASM)’ to ‘location 2 (ASM/ NON-ASM)’ REUSE;

     

  • KEEP

    SQL> alter database move datafile ‘location1(ASM/NON ASM)’ to ‘location2(ASM/NON ASM)’ KEEP;

  1. Putting multiple indexes on same column

    SQL> create index new_ind on table_name(col1, col2);

Data Dictionary

Data Dictionary
Sys user owns the data dictionary.
Dictionary contains is data about data
They exist in datafiles of system tablespaces and sysaux tablespaces.
Data dictionary reference tables are read only so only SELECT sql is allowed. Even if we own these tables (sys user) we use views in order to rule of the possibilities of corrupting any data dictionary base table.

Automatic Diagnostic Repository(ADR) and ADR Command Interpreter (ADRCI)

ADR - Automatic Diagnostic repository.

$ORACLE_BASE/diag/rdbms/dbname/sid/trace/

Multiple instances can use the same path which will be the central location for alert and trace information

 You just have to define its path in the INIT file

This is an xml file

The Records in the file is:

  • ORA errors (e.g., ORA-…)
  • DDL statements detals
  • Non default init parameters etc..

You can run sql command.

Password file in Oracle

Password file in Oracle is used by it to store password to authenticate users who have administrative privileges. In oracle until a user is not logged in he can’t connect to the databases so storing the passwords for these users in database is not logical.
For the users with administrative rights we have two methods available.:
(i) Using the password file
(ii) Through the operating system (using groups). Any user on the OS under dba group, can login as SYSDBA.

OEM (Oracle Enterprise Manager) Installation and configuration for Standalone Database, Oracle 12c , Linux 5.11 and 6.6

This article describes configuration of OEM (Oracle Enterprise Manager) on a Linux server for standalone database (one instance) Oracle 12c, where database is already created.

DBConsole is no more available for 12c. so for 12c when you run emca/ emctl command it says command not found.

The location for emctl in 12c is <Middleware_Home>/oms/bin

From this location the following command can be successfully run 

No polls have been added to this group.

Recent activity in this group

Group contributors

Contributors