![]() ![]() Now click add and click next in next screen it will ask service name here you need to add oracle global database name of computer A(Normally I use oracle86 for my installation) now click next next screen choose protocol normally its tcp click next in host name enter computer A's name you can found that in my computer properties. Okay now on computer b go to start menu find configuration under oracle folder click Net Configuration Assistant under that folder when window pop up click Local net configuration option it must be third option. Its quite easy on computer a you don't need to do anything just make sure both system are on same network if its not internet access(for this you need static ip). Used EZCONNECT adapter to resolve the aliasĪttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.12)(PORT=1521))) All rights reserved.ĭ:\oracle11gr2\product\11.2.0\dbhome_1\network\admin\sqlnet.ora Ping the IPv4 address, not the localhost or the 127.0.0.1 Instance "xe", status READY, has 1 handler(s) for this service. ![]() Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.\pipe\EXTPROC1521ipc))) Listener Log File d:\oracle11gr2\diag\tnslsnr\eagleii\listener\alert\log.xml Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Productionĭ:\oracle11gr2\product\11.2.0\dbhome_1\network\admin\listener.ora All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Notice the additional HOST=192.168.1.12 shows up and this is what to make remote connection to work. (note: for me I reboot machine once to make it work) This will end up add an entry to the \product\11.2.0\dbhome_1\network\admin\listener.ora Add the IP address (in my case it is 192.168.1.12) besides of the 127.0.0.1 or localhost. After doing some research, I figured out there is this additional step you have to do: But from another Maclaptop on my home network, it can't connect using either Sql Developer or Sql Plus. I install the Oracle server and it allows to connect from the local machine with no problem. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |