POWERFUL & USEFUL
FREE KNOWLEDGES
Welcome To the Best Oracle DBA Portal Ever! Let's Start
TOP Articles
Diagnostic Pack
1st stage of the express database troubleshooting: sqlplus, sql developer
Read More
Server Tuning
Autostart Oracle, IP Tables, Boot Timeout, Environments
Read More
Increase disk space on ASM ACFS from SAN (Invita)
Case, when we have no free space left in the ASM
Read More
- 1
- 2
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