If you did not install Enterprise Manager, you could install manually DbConsole (Enterprise Manager). You have to execute below commands. If dbsnmp user is locked, you have to do unlock this user. Because dbsnmp user will use for EM installation. Install EM Open Command Prompt set ORACLE_HOME=c:\path\to\oracle\home set ORACLE_SID=DB_SID emca.bat -config dbcontrol db Note :…
Category: Administration
RMAN List Command in Oracle
RMAN List Command queries can use for the historical information on the backups. The various options you can use with List command and their uses are discussed below. List Commands Examples RMAN> LIST ARCHIVELOG ALL; RMAN> LIST BACKUP OF ARCHIVELOG ALL; RMAN> LIST BACKUP; RMAN> LIST BACKUP OF DATABASE; RMAN> LIST BACKUP OF DATAFILE 1;…
Show First and Last Value of Data in Oracle
You can show first and last value of data which changes with update. Also you can show all values. Example Select versions_starttime, versions_endtime, salary from employees versions between scn minvalue and maxvalue where last_name=’King’;
Constraint Deferrable Types in Oracle
Constraints’s check time depend on deferrable parameters. If the parameter is set immediate, check time of your query is before the transaction is commit. Also, query will check when you execute query. If the parameter is set deferred, query will check when the transaction is commit; Deferrable initially immediate Deferrable initially deferred
Ocr Voting Disk in Oracle
Oracle Clusterware 10g, formerly known as Cluster Ready Services (CRS) is software that when installed on servers running the same operating system, enables the servers to be bound together to operate and function as a single server or cluster. This infrastructure simplifies the requirement for an Oracle Real Application Clusters (RAC) database by providing cluster…
Install Oracle 10g RAC on Windows Server 2003 x64 on VMware
I will explain how to install Oracle RAC 10g on Windows Server 2003 x64 Edition. I will tell installation step by step. You can find here for wide explain of that installation. 1 – VMware Configuration Add New Bridge Network. Add New Virtual Disks That 1 GB OCR, 1 GB Voting, 30 GB DATA, 30…
RAID (Redundant Array of Independent Disks)
RAID (redundant array of independent disks; originally redundant array of inexpensive disks) is a way of storing the same data in different places (thus, redundantly) on multiple hard disks. By placing data on multiple disks, I/O operations can overlap in a balanced way, improving performance. Since multiple disks increases the mean time between failures, storing…
Create Trigger in Oracle
A database trigger is a stored procedure that automatically executes whenever an event occurs. The event may be insert-delete-update operations. For example, Oracle initiates an ‘AFTER INSERT’ trigger after an insert event has occurred or an ‘AFTER UPDATE’ trigger after an update event has occurred. You can write triggers that fire whenever one of the…
Delete Duplicate Rows Without All Records in Oracle
If you want to delete duplicate rows but not all rows in table, you can use a procedure. For example, you have 10 duplicate rows and you want to delete 9 rows, then you can use procedure to delete process. For instance, you have a table as tmp_table. tmp_table’s columns are id,name,surname,city,phone. You want to…
Start and Stop Instance in Oracle Rac System
You can demand stop one instance in Oracle Rac System. This stop process have to perform step by step. Firstly, stop instance after asm and finally stop applications. The first step is to stop the Oracle instance. When the instance (and related services) is down, then bring down the ASM instance. Finally, shut down the…