Wednesday, 4 December 2013

How to Migrate All the Scripts(Table Scripts,Packages,Host Script,Install Script,LDT Files etc) from one instance to the other instance by running the Install script

I am assuming that i have already created all the scripts(table scripts,packages,host script,install script,ldt files etc).
These all above scripts need to move from one instance to the other instance

step 1:
Open winscp,and login with the credentials to what ever the instance you finally want to move.

step 2:
Create any folder or ask the client for the folder where  i should place the scripts initially

step 3:
If dont have folder,create it and place all the scripts under the folder you created

step 4:
After moving all the scripts,connect to the putty,and navigate to the folder where you have placed the scripts

step 5:
Once you navigate to the folder,convert the shell scripts (i.e. sh files)using dos2unix command i.e.
dos2unix XXRAM_INSTALL_SCRIPT

step 6:
Once the files got converted,run the below query i.e we are going to run the install script,in which it contains all the uploaded commands
with below command it will upload into the istance
syntax:
./<install script name> <user name>/<password> <host name> <sid> <port>

Below are the back end details of the new instance to which we are uploading
install script name:this contains all the uploaded scripts
user name:which ever the instance we are loading ,that instance user name
password:which ever the instance we are loading ,that instance password
host name:which ever the instance we are loading ,that instance host name
Sid:which ever the instance we are loading ,that instance service name
port:which ever the instance we are loading ,that instance port number

Example Syntax:
./XXRAM_INSTALL_SCRIPT apps/appsram abc.def.ghi dev 1111

step 7:
Now go and query it in the instance for verification purpose whether we have successfully uploaded or not!!!!!!!