ORACLE DBA AND LINUX ENGINEERING

: Super User; Joomla!; 10 January 2016; Hits: 1121; Rating:

( 0 Rating )

Layout Builder

No experience required

Drag and Drop Layout Builder

Nulla porttitor accumsan tincidunt. Vivamus suscipit tortor eget felis porttitor volutpat. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat,porttitor accumsan tincidunt. Vivamus suscipit tortor eget felis porttitor volutpat.

Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat porttitor accumsan tincidunt. Vivamus suscipit tortor eget felis porttitor volutpat. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur arcu erat accumsan id imperdiet et, porttitor at sem.

Watch Video

Relax, cover daily tasks

Welcome!

Learn More
BY OWN EXPERIENCE

ORACLE DBA

Learn More
Save you Time and Money

QuickStart Toolbox

Learn More
POWERFUL & USEFUL

FREE KNOWLEDGES

Learn More

Welcome To the Best Oracle DBA Portal Ever! Let's Start

Exadata, RAC

CELL, Control iLo
CELL, Disk Diagnostic

No presence required

Work from any location

Connect via iLo and command line interface

Check current power status

Start or Stop system, including force option. Other useful options

Learn More ...

Failure report

Prepare support information

Check alerts history of the griddisk and physicaldisk

Run Exacheck (detail analysis)

Run Remote Diagnostic Agent (RDA)

Learn More ...

Start Steps to Awesome Oracle DBA

Environment
1st Step
Check current and set which we need

It doesn't matter which operating system we're using

See examples how to check default environment settings from Linux user .bash_profile or Windows register and change them as we need Read More
Connecting through sqlplus
2nd Step
From server or local workstation

We can always use command line interface when make a connection to any Oracle database from the server. Also we can connect using our workstation with Oracle Client and correct tnsnames.ora Read More
Listener
3rd Step
New connections helper

Helps us to make new connections to the database

Without Listener all current connections will continue to work Read More
DB info
Optional
Main database information

Last startup time, SID, Name, Status, Size, Version and parameters Read More
New User, Audit
By request
Users management

Create new user, change password and unlock

Backup and Restore forgotten password using hash

Privileges and Profiles

Audit Read More

› ‹

1
2
3
4
5

File Management

Tablespaces and Datafiles +

How to Show Path and Size? How to Create, Add, Resize, Autoextend and Transfer: the Tablespace, Datafile, Undo and Tempfile Read More
Tempfiles +

Show size, free and used space of the Tempfile. Add new one, and resize. Manage default Temp Tablespace Read More
Controlfile +

Info, Size, Multiplexing and autobackup controlfile Read More
Archivelog +

Show path, daily size, current database mode. Set archivelog or noarchivelog mode. Archivelog deletion policy. Multiplexing. Files format Read More
Flash Recovery Area (FRA) +

Main info. Set new size and path. Disable FRA usage Read More
Redo logs +

Size info, Multiplexing, Standby settings Read More

1

1
2

Articles

Layout Builder

No experience required

TOP Articles

Diagnostic Pack

RMAN

Server Tuning

Increase disk space on ASM ACFS from SAN (Invita)

Exadata, RAC

No presence required

Failure report

Start Steps to Awesome Oracle DBA

Environment
1st Step
Check current and set which we need

1st Step

Check current and set which we need

Connecting through sqlplus
2nd Step
From server or local workstation

2nd Step

From server or local workstation

Listener
3rd Step
New connections helper

3rd Step

New connections helper

DB info
Optional
Main database information

Optional

Main database information

New User, Audit
By request
Users management

By request

Users management

File Management

Tablespaces and Datafiles +

Tempfiles +

Controlfile +

Archivelog +

Flash Recovery Area (FRA) +

Redo logs +

Newsletter

Tag Cloud

Quick Contact

Search