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#…
—– Procedure to import table from production system to test system —— 1. Copy the backup(dump) of schema onto /backup_restor_only…
####PSU patching, interim patches ##### Sometimes before moving to a new 10.2.0.* version there are CPU patches released on a…