crsctl is Oracle Clusterware management command. You can check, start, stop clusterware with crsctl. crsctl command directory is $GRID_HOME/bin. You can do below operations with crsctl Starting and stopping Oracle Clusterware resources Enabling and disabling Oracle Clusterware daemons Checking the health of the cluster Managing resources that represent third-party applications Integrating Intelligent Platform Management Interface…
Category: Administration
How to Change Oracle Enterprise Manager Port Number
If you want to change Oracle Enterprise Manager port number, you can use “emca -reconfig ports -DBCONTROL_HTTP_PORT ” command, this is simple. You can use to take security measure for Oracle EM. I will give 1820 as port for Oracle EM as example. Change Oracle Enterprise Manager Port
How to Create Oracle Wallet for Encrpytion
Oracle Wallet Manager is a password protected stand-alone Java application tool used to maintain security credentials and store SSL related information such as authentication and signing credentials, private keys, certificates, and trusted certificates. 1- Create Wallet Directory [oracle@testdb ~] cd $ORACLE_HOME [oracle@testdb db_home] mkdir -p ORA_WALLETS 2- Write Wallet Location Information in sqlnet.ora File [oracle@testdb…
How to Move Datafile to Different Directory in Oracle
You can move datafiles to different directory. You have to make offline tablespace or take mount mode database to change datafiles location. System, temporary and rollback tablespace can move only when database is mount mode. Show Tablespaces And Datafiles With Locations SQL> select tablespace_name, file_name from dba_data_files; Change Location Of Normal Datafile SQL> alter tablespace…
How to Drop Oracle Database With RMAN
You can run the following commands to delete the target database files, as well as all backups, copies, and archived logs associated with the database. Drop Oracle Database oracle@oratest~ ]$ rman target / Note : If database is not started, you have to start database with mount mode. If database is started, you have to…
What is Lightweight Job in Oracle
Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. Lightweight jobs have the following characteristics: Unlike regular jobs, they are not schema objects. They have a significant improvement in create and drop time over regular jobs because they do not…
Restore And Recover Oracle 11g R2 Database on Windows 2008 R2 Server
You can restore and recover Oracle 11g R2 Database from RMAN backup on Windows 2008 R2 Server with below operations. You have to execute Command Prompt as Administrator for all operations. Restore and Recover Database Install Oracle software Install Patch Create ORACLE_HOME and ORACLE_SID in Server Environment Path. Copy backup files to C:\orabackup Create Oracle…
Oracle Control Files Content
A control file contains information about the associated database that is required for access by an instance, both at startup and during normal operation. Control file information can be modified only by Oracle Database; no database administrator or user can edit a control file. A control file contains The database name The timestamp of database…
Oracle Flashback Technology
When authorized people make mistakes, you need the tools to correct these errors. Oracle Database provides a family of human error correction technology called Flashback. Flashback revolutionizes data recovery. In the past, it might take minutes to damage a database but hours to recover it. With Flashback technology, the time to correct errors equals the…
Oracle Cold-Offline Backup And Restore
You have to shutdown database to take offline backup. After shutdown database, you can take backup with two way that are rman backup database or copy Data Directory that is include datafiles, redo log files and control files. Offline-Cold Backup Database 1- Take Offline Backup With Rman SQL> shutdown immediate; SQL> startup mount; RMAN> backup…