1. Copy the backup of the dumpfile to the target server. 2. Create a tablespace in our eg: called TEST.…
Well, most of the oracle DBAs are very much interested in learning Oracle Applications 11i or R12. For that, we…
A database link creates a connection between a local database and a remote database. You might want to create a…
The database does not startup, and gives errors like: ORA-38737: Expected sequence number 2483 doesn’t match 2304 ORA-38701: Flashback database…
The Complex Oracle Data Guard in less than 15 easy steps. Create a physical standby database in less than an…
Sometimes when your running an Oracle database, it becomes necessary to automate some tasks like cleaning your archivelogs. Since in…
How to change the Size of the Redo Log files to improve the log switch frequency in Oracle database. select…
Purpose of this parameter found in sqlnet.ora file: Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If…
How to configure just newly added disks in Solaris 10? It’s really simple. 1. first show all attached targets bash-3.00#…