ORACLE NETWORKING
This article will tell you how to connect to an Oracle database through Different server Or Different Machine
For this Scenario I used VMWare Work Station ACE Edition.
1) First Install Linux and then ORACLE 10g R2 on VMware Machine.
(clickhere to know How to Install Linux on VMWare)
(clickhere to know how to Install Oracle10g on Linux)
Note: While Installing Oracle Software. You will find option like Install Software only. Click On it. We will create Database later.
2) In this case I created Linux server called Primary
Note: IP Address of Primary Machine is 192.168.2.151 and in active mode And host name is Primary.dbasagar.com, use same IP address and hostname at the time of installing linux , only if you are using Bridged network
3)Now goto VMware storage location on your host (C:\Users\Administrator\Documents\Virtual Machine)
You will find folder called Primary ( Since my machine name is Primary)
Create a folder called Standby
4) Copy all files on Primary folder and paste those into Standby
5) Open standby folder and open vmware configuration file as shown in fugure
find line name DisplayName, Chang primary to Standby
6) Now Go to VMware press ALT+F and the click on open. Go to Standby local open vmdk file as shown
in figure
Now you have a two virtual machines called Primary and standby. Then Power on Standby Machine and leave Primary Power off. we need to change certain parameters
And log in as root user
7) Go to Applications --> system settings --> Network
a) Double click on eth0
A new window will open - change IP address 192.168.2.151 to 192.168.2.152 ( Since we just copied
whole content of Primary to standby)
b) on same window you have tab called Hardware Device as show in figure, click on in and click Probe for
once to change MAC address finally click OK
c) Now click on DNS tab on Main window as show in figure and change Host name from
Primary.dbasagar.com to Standby.dbasagar.com
d) Now click on Devices tab and finally click on activate and then YES and click on OK
Your eth0 device is now active mode. Close Net configuration window and log off and log in again as root user
8) Open Terminal and issue following commands
# hostname
#vi /etc/hosts
make entries as show in figure
9) Now power on Primary Machine and log in as root user and Open Terminal and issue following
commands
# hostname
#vi /etc/hosts
make entries as show in figure
10) Now log out of Root user and log in as oracle on both Machines
Create database called PROD using DBCA tools (on Primary Machine)
(Clickhere to know how to create database using DBCA)
11) Connect to database as sysdba (on Primary Machine)
12) Open another Terminal
Is below command as shown in figure
$ netca
Listener Configuration --> Add --> Listener Name [ PROD ] --> TCP --> PORT 1521 --> Next --> Finish
13) Now Issues netmgr command to make entries on tnsname.ora
$netmgr
click on listeners --> PROD --> Database services -->
add database make entires PROD and PROD --> again click on add database --> Save and EXIT
14) Again issue netca
Local Net service configuration --> add --> Name --> PROD --> TCP --> Host Name and PORT 1521 --> YES, Perform test --> test successful--> NEXT --> Finish
15) Now Ping TNS using below command
$tnsping PROD
16) Go to Directory $ORACLE_HOME/network/admin
edit tnsnames.ora as show in figure
copy selected content and past it into Standby machine tnsnames.ora file and save it
17) Now Ping TNS using below command
$tnsping PROD
We are all set. Now testing
18) Go to Primary machine
log In as as sysdba
create a user called sagar and grant roles as shown in figure
19) Now go to Standby and log In sagar user
$ sqlplus sagar/sagar@PROD
Yes... Now you are connected to Database PROD which is located at Primary Machine through Standby Machine
20) create a table called test and insert some records in it and issue commit;
21) Now go to Primary Machine. check that records are stored are not as a sys user or Sagar user
In this way we can connect to database as remotely. In this way only developers will connect to database
Thanks
Sagar
This article will tell you how to connect to an Oracle database through Different server Or Different Machine
For this Scenario I used VMWare Work Station ACE Edition.
1) First Install Linux and then ORACLE 10g R2 on VMware Machine.
(clickhere to know How to Install Linux on VMWare)
Note: While Installing Oracle Software. You will find option like Install Software only. Click On it. We will create Database later.
2) In this case I created Linux server called Primary
Note: IP Address of Primary Machine is 192.168.2.151 and in active mode And host name is Primary.dbasagar.com, use same IP address and hostname at the time of installing linux , only if you are using Bridged network
3)Now goto VMware storage location on your host (C:\Users\Administrator\Documents\Virtual Machine)
You will find folder called Primary ( Since my machine name is Primary)
Create a folder called Standby
4) Copy all files on Primary folder and paste those into Standby
5) Open standby folder and open vmware configuration file as shown in fugure
find line name DisplayName, Chang primary to Standby
6) Now Go to VMware press ALT+F and the click on open. Go to Standby local open vmdk file as shown
in figure
Now you have a two virtual machines called Primary and standby. Then Power on Standby Machine and leave Primary Power off. we need to change certain parameters
And log in as root user
7) Go to Applications --> system settings --> Network
a) Double click on eth0
A new window will open - change IP address 192.168.2.151 to 192.168.2.152 ( Since we just copied
whole content of Primary to standby)
b) on same window you have tab called Hardware Device as show in figure, click on in and click Probe for
once to change MAC address finally click OK
c) Now click on DNS tab on Main window as show in figure and change Host name from
Primary.dbasagar.com to Standby.dbasagar.com
d) Now click on Devices tab and finally click on activate and then YES and click on OK
Your eth0 device is now active mode. Close Net configuration window and log off and log in again as root user
8) Open Terminal and issue following commands
# hostname
#vi /etc/hosts
make entries as show in figure
9) Now power on Primary Machine and log in as root user and Open Terminal and issue following
commands
# hostname
#vi /etc/hosts
make entries as show in figure
10) Now log out of Root user and log in as oracle on both Machines
Create database called PROD using DBCA tools (on Primary Machine)
(Clickhere to know how to create database using DBCA)
11) Connect to database as sysdba (on Primary Machine)
12) Open another Terminal
Is below command as shown in figure
$ netca
13) Now Issues netmgr command to make entries on tnsname.ora
$netmgr
click on listeners --> PROD --> Database services -->
add database make entires PROD and PROD --> again click on add database --> Save and EXIT
14) Again issue netca
Local Net service configuration --> add --> Name --> PROD --> TCP --> Host Name and PORT 1521 --> YES, Perform test --> test successful--> NEXT --> Finish
15) Now Ping TNS using below command
$tnsping PROD
edit tnsnames.ora as show in figure
copy selected content and past it into Standby machine tnsnames.ora file and save it
17) Now Ping TNS using below command
$tnsping PROD
We are all set. Now testing
18) Go to Primary machine
create a user called sagar and grant roles as shown in figure
19) Now go to Standby and log In sagar user
$ sqlplus sagar/sagar@PROD
Yes... Now you are connected to Database PROD which is located at Primary Machine through Standby Machine
20) create a table called test and insert some records in it and issue commit;
21) Now go to Primary Machine. check that records are stored are not as a sys user or Sagar user
In this way we can connect to database as remotely. In this way only developers will connect to database
Thanks
Sagar
Thanks for sharing your innovative ideas to our vision. I have read your blog and I gathered some new information through your blog. Your blog is really very informative and unique. Keep posting like this. Awaiting for your further update.If you are looking for any Regression Analysis related information, please visit our website Regression Analysis Tutorial
ReplyDeletebuy weed online
ReplyDeletebuy moonrock online
buy pain relief pills online
Buy Adderall Online
buy weed online
buy moon rocks online
https://k2incenseonlineheadshop.com/
ReplyDeleteinfo@k2incenseonlineheadshop.com
Buy liquid incense cheap
Buy liquid incense cheap For Sale At The Best Incense Online Shop
K2 Spice Spray | Liquid K2 | Liquid Spice | K2 Spray for sale
Buy weed online - Weed for sale
ReplyDeleteOrder marijuana online - Buy weed online
Buy Hybrid Weed strain online
sativa weed for sale
where to buy liquid herbal incense
ReplyDeletebuy herbal incense with debit card
buy herbal incense overnight shipping
strongest liquid incense
buy herbal incense online cash on delivery
liquid herbal incense 2020
k2 spray that get you high for sale
buy herbal net
super strong herbal incense
herbal incense paper
joker herbal incense
herbal incense uk
herbal incense recipes
buy herbal incense online cash on delivery
smoking blend oils review
buy shatter online in united states
buy shatter online cheap usa
mail order dabs usa
cbd online dispensary
buy firebars online
mail order concentrates
extracts shatter
15 shatter canada
buy herbal incense overnight shipping
buy herbal incense online cash on delivery
buy herbal incense with debit card
buy herbal incense online overnight shipping
cheap strong herbal incense
super strong herbal incense
most potent herbal incense on the market
trusted herbal incense sites 2020
Buy Dank Vapes Online | Dank Vapes Full Gram Cartridges.Buy Dank Vapes Online - Vape pens & Cartridges USA and .
This is great. Thanks for sharing. Also, check this out if you are looking for professional website or logo design services:
ReplyDeleteBuy Logo
First I want to tell you Thank you for sharing it with us.
ReplyDeleteI am really Happy and impressed to see this blog!
law essay writing help