Tuesday, February 25, 2014

Installing golden gate 11.2.1.0.1

I have installed RHEL5-10 on my VM. So  I used following Golden Gate Version  to install.

Download   golden gate  using following link. This will be a ZIP file.
Oracle GoldenGate V11.2.1.0.1 for Oracle 11g on Linux x86-64 (86 MB).

lets say downloaded file name is ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

Prerequisite :-   RHEL 5.10 64 bit version
                             Oracle Database 11.2.0.3

Oracle DB has been installed to 
                      /u01/app/oracle/product/11.2.0.3/dbhome_1/


Now get  copied the downloaded  golden gate software  to 
                     /u01/app/oracle/product/gg  location (
           you need to create gg folder  as a best practice
                 mkdir -p    /u01/app/oracle/product/gg
)

copy the distribution to the inside /u01/app/oracle/product/gg 

and the unzip the file using command -->

                 unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip


Again extract the tar file 


tar -xf  fbo_ggs_Linux_x64_ora11g_64bit.tar


after extracting  type ls 



.You will see more files in the list.above shown the some.

Then Set the LIBRARY PATH

Type on the terminal as follows  Or else  put this entry on  oracle's .bash_profile

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/product/gg

Verify  that varible is set  properly by entering 
Now you are  already inside the /u01/app/oracle/product/gg folder.
Now run the following command 
$  ./gccsci
Now You are on golden gate environment :).
After this you want to create  the sub directories.
Now  you are done with the Oracle golden gate installation successfully.



Sunday, February 9, 2014

Deinstall Oracle 11g Binary and Re-install the Oracle 11g Binary on Windows

Step 01 :

Go in to ORACLE_HOME/deinstall/    folder and  run deinstall.bat file

it will ask some questions

  • Path for Oracle_Home
  • Database Name
  • Listener Name
Provide the correct answer for those.

Now bat will be finished executing.

Step 02 :

Then need to clear the registry 
goto RUN  window 

type regedit    #appears  a window there 

right side of the window go along the following path 

COMPUTER -->HKEY_LOCAL_MACHINE  --> SOFTWARE --> ORACLE

Right click on oracle and select delete.
Now registry is clear.

Step 03 :

Right click My computer go to Manage  --> shows up a window
Right column of the window there appears a services and applications
Then click on services

there you could see  
      OracleOraDb11g_home1TNSListener
      OracleServiceFIN       #FIN is  sid

stop those services also. 

step 04 :

Go to environment variables in My computer and unset the path of ORACLE_HOME.
Remove oracle_home in path variable :)

Now you are ready to install the new oracle binary :)



Knowledge Base TNS -->ORA-12560: TNS:protocol adapter error

When starting up the database it raised  following  error;

SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

for this I set my ORACLE_SID to the particular database id to this

In the command prompt (cmd) type this  (fin is my database name)
C:\Users\Dell>set ORACLE_SID=FIN  

Now its working fine :)


  • make sure 11g passwords are case sensitive.


---------------------------------------------------------------------------------------------------
C:\Users\Dell>SQLPLUS SYS AS SYSDBA

SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 9 17:37:49 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - Production

SQL> STARTUP
ORA-01081: cannot start already-running ORACLE - shut it down first