-
Oracle XE client
Hi Friends,
I have installed Oracle XE client on my PC.
I check on its home dir (bin), and I found the proram sqlplus.exe
At DOS I run sqlplus system/manager but I want to connect to
my database server on another server.
How can I configure this connection pls? I look for tnsnames.ora
but I can not find any.
Thanks in advance to all and Happy New Year
Behind The Success And Failure Of A Man Is A Woman
-
In Oracle 10g you can use following command on SQL*Plus to connect to another database:
SQL> conn USERNAME/PASSWORD@HOSTNAME:PORT/SID
In that case you don't need a tnsnames.ora. Only your sqlnet.ora need the following entry:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT, HOSTNAME)
Regards,
Carlos Duarte
Oracle Applications DBA
-
Thanks dear for speedy reply.....I check the home dir of XE client and and can not find sqlnet.ora either...
but when i run sqlplus system/manager just to test connection...It
created a sqlnet.log error:
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\XEClient\bin\sqlplus.exe)(HOST =VISA_1)(USER=Administrator))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 03-JAN-2007 16:35:35
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
ns secondary err code: 0
nt main err code: 530
TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS
nt secondary err code: 2
nt OS err code: 0
Thanksssssssssssssssss................
Last edited by yxez; 01-03-2007 at 08:22 AM.
Behind The Success And Failure Of A Man Is A Woman
-
Sure. You can create a new one on $ORACLE_HOME/network/admin/
Try to establish the connection before, may work because it's supposed to be default. If does not work you can create the SQLNET.ORA and TNSNAMES.ORA
Regards,
Carlos Duarte
Oracle Applications DBA
-
Thanks dear....but the oracle xe client did not even make a
network/admin directory....should I create one?
Can u pls try to install oracle XE client pls
Last edited by yxez; 01-03-2007 at 09:17 AM.
Behind The Success And Failure Of A Man Is A Woman
-
Tns_admin
>>Thanks dear....but the oracle xe client did not even make a network/admin directory....should I create one?
You can create it yourself, or you can set TNS_ADMIN pointing to an existent directory and put the file(s) there.
HTH
Cheers.
Carlos.
-
Have you tried to connect to another database before do that?
Regards,
Carlos Duarte
Oracle Applications DBA
-
I tried it using...
>sqlplus system/manager@124.6.144.116:1521:xe
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 4 08:08:36 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
but I can ping the server...
======
I also set the TNS_ADMIN=C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
in my environment variable and run
>sqlplus system/manager@xe
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 4 08:21:35 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
=============
Thankssssssssssssssssss again
Last edited by yxez; 01-03-2007 at 08:19 PM.
Behind The Success And Failure Of A Man Is A Woman
-
anyone out there have tried installing the XE client pls.
Note that the XE server side has no problem. I can use its sqlplus.exe adn can connect to any remote server defined in the
tnsnames.ora.
But when I use the sqlplus.exe found in the client bin it will not
connect to a database even the local one. I even set the TNS_ADMIN variable because the client install does not create
a directory %ORACLE_HOME%/NETWORK/ADMIN
Another question is....where does my sqplus.exe client got the
following information(default params) which it logged to the sqlnet.log :
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES )(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\XEClient\bin\sqlplus.exe)(HOST =VISA_1)(USER=Administrator))))
Note: it uses ORCL but my sid is XE
I just want to edit this default sqlnet parameters but I dont know
where it is found.
Last edited by yxez; 01-03-2007 at 08:53 PM.
Behind The Success And Failure Of A Man Is A Woman
-
You did connect wrong. Try this:
sqlplus system/manager@124.6.144.116:1521/xe
Regards,
Carlos Duarte
Oracle Applications DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|