Oracle 11g Error Codes and Solution Suggestions from ORA-00201 to ORA-00300 ORA-00201: control file version string incompatible with ORACLE version string Cause: The control file was created by incompatible software. Action: Either restart with a compatible software release or use CREATE CONTROLFILE to create a new control file that is compatible with this release. ORA-00202:…
Oracle 11g Error Codes and Solution Suggestions from ORA-00101 to ORA-00200
Oracle 11g Error Codes and Solution Suggestions from ORA-00101 to ORA-00200 ORA-00101: invalid specification for system parameter DISPATCHERS Cause: The syntax for the DISPATCHERS parameter is incorrect. Action: Refer to the manual for correct syntax. ORA-00102: network protocol string cannot be used by dispatchers Cause: The network specified in DISPATCHERS does not have the functionality…
Oracle 11g Error Codes and Solution Suggestions from ORA-00000 to ORA-00100
Oracle 11g Error Codes and Solution Suggestions from ORA-00000 to ORA-00100 ORA-00000: normal, successful completion Cause: Normal exit. Action: None ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists…
MsSQL Server Unknown Server Hostname Problem Solution
When you try to connect MsSQL Server database, you can get an error that is Unknown Server Hostname or similar sometimes. You can resolve this problem with a few operation. Suggest If you use SERVERNAME\INSTANCENAME statement, you can try SERVERNAME;instance=INSTANCENAME statement
Oracle 11g Data Guard Failover With Python Script
I wrote a python script to perform failover steps and to take product database IP addresses when product database is down. If you dont use data guard broker or other application for failover operations, you can use this script for failover. My scenario is that I have Oracle 11gR2 2 nodes RAC product database and…
RPM Command Using on Linux Systems
If you connect linux repo, you can use yum install or yum update to manage your package. On the other hand, if you have RPM package, you can use rpm command to manage packages. RPM command has been using for installing, uninstalling, upgrading, listing,querying and checking RPM packages on linux system. You can use rpm…
Move Datafiles Of Tablespaces With RMAN Set Newname in Oracle 11g
You can move datafiles of tablespaces. Scenarios can be asm to file system or file system to file system or file system to file system or asm to asm. Below operations show how to move datafiles. You have to take a backup and database has to be archivelog mode before this operations because of that…
How to Lock and Unlock Users on Oracle Linux / Centos / Redhat
Lock User Method 1 [root@test ~]# passwd -l username Method 2 [root@test ~]# usermod -L username Unlock User Method 1 [root@test ~]# passwd -u username Method 2 [root@test ~]# usermod -U username Check Status of Users [root@test ~]# more /etc/shadow username:!!$6$pmQO0ZPH$POolvCzxe1nsd1OpLkMc6E3cd1ffOkcz224caQs1d/oL.OwscUhYfcas//41sS12.:16531:0:99999:7::: Note : If you see “!!” expression or “!” expression start of password of…
Auto Increment Primary Key With Trigger in Oracle 11g
You can provide auto increment primary with trigger by appling below operations. Create Table SQL> CREATE TABLE TESTUSER.TBL_TEST (id number primary key, name varchar2(100)); Create Sequence SQL> CREATE SEQUENCE TESTUSER.SEQ_TEST_ID START WITH 1 MAXVALUE 999999999 MINVALUE 1 CYCLE NOCACHE NOORDER; Create Trigger For Auto Increment SQL> CREATE OR REPLACE TRIGGER TESTUSER.TRG_AUTO_INC_TEST_ID before insert on TESTUSER.TBL_TEST…
Error Code 80072EE6 Windows Update Error Solution
If you receive a 80072EE6 error code when you download an update from Windows Server Update Services in Windows 7 or Windows Server 2008 R2, your update service location can be wrong. You have to control and change with true. Error 80072EE6 error code when you download an update from Windows Server Update Services. Solution