background A JAVA program throwed out an error that ” java.sql.SQLException: ORA-28001: the password has expired ” when The program was runing. This error is…
shutdown database service SQL>shutdown immediate; start database to mount mode SQL>startup mount; If you haven’t opened archivelog feature, please execute “alter database arcivelog” to enable…
Swithover important Primary –> standby select open_mode,database_role,switchover_status from v$database; alter database commit to switchover to physical standby with session shutdown; shutdown immediate; startup mount; alter…
step1 enter RMAN command $ rman target / step2 check all archivelog RMAN> crosscheck archivelog all; step3 list all invalid archivelog RMAN> list expired archivelog…
This chapter describes how to optimize connection performance. This chapter contains the following topics: Configuring Session Data Unit Determining Bandwidth-delay Product Configuring I/O Buffer Space…
start/stop database srvctl start/stop database -d instance_name [grid@node1 ~]$ srvctl status database -d devdb Instance devdb1 is running on node node1 Instance devdb2 is running…
For additional information on handling corruption, see the BC expert notes on corruption and see MOSC Note 1088018.1 – Handling Oracle Database Corruption Issues. Also see how to…
Create main tablespace create tablespace TEST datafile ‘/home/oracle/app/oracle/oradata/TEST/test.dbf’ size 1000M autoextend on next 500M maxsize unlimited; Create main temp tablespace create temporary tablespace TEST_TEMP tempfile…