configure clients [message #455592] |
Wed, 12 May 2010 04:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
moradoracle
Messages: 7 Registered: May 2010
|
Junior Member |
|
|
hello all
i installed oracle 9i db
how can i configure this server 2 be client and server on same time
i try 2 configure tnsnames.ora but it fail also
urgently please
|
|
|
|
|
|
|
|
|
Re: configure clients [message #455614 is a reply to message #455611] |
Wed, 12 May 2010 04:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You've told us next to nothing.
And as already asked - stop using IM speak - u, wt etc.
What did you do to the tnsnames.
What errors are you getting?
|
|
|
Re: configure clients [message #455616 is a reply to message #455614] |
Wed, 12 May 2010 05:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
moradoracle
Messages: 7 Registered: May 2010
|
Junior Member |
|
|
oh now i understand sorry
i modify tnsnames and add to the file the host name for other database server and it give me
TNS operation failed
when i connect to the same server it work correctly
|
|
|
|
Re: configure clients [message #455628 is a reply to message #455592] |
Wed, 12 May 2010 05:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
moradoracle
Messages: 7 Registered: May 2010
|
Junior Member |
|
|
this is the original
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = morad-pc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = morad-pc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
---------------------------------------------
i modify this
ORCL1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.104)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
|
|
|
Re: configure clients [message #455638 is a reply to message #455608] |
Wed, 12 May 2010 05:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gregor
Messages: 86 Registered: March 2010 Location: Germany
|
Member |
|
|
Hi,
- it may be, that you have two TNS_NAME.ORA.One for Client-Software, one for Server.. ( you can set TNS_ADMIN=<PATH> in the envirement, to use only one TNS_NAMES )
- Both Database-Server must be included in the TNSNAMES.ORA
- You can Test the connection with "tnsping <DBSID>"
if you want connect to Database2 through database1, you can create a DATABASELINK.
|
|
|
Re: configure clients [message #455730 is a reply to message #455628] |
Wed, 12 May 2010 13:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You said you "added" but all I see is that you changed the definition of ORCL1.
Once again, why do you insist on giving information in piecemeal? This would prevent this thread from having 50 responses before you get an answer.
file before
file after
error messages
actual session (not a faked session)
etc.
|
|
|