why can I TNSPING but I can not connect using SQLPLUS?
Oracle 10g
Slackware 10 install 2.6.6 kernel
exports
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10g
ORACLE_SID=ora9i
ORACLE_TERM=xterm
error in sqlplus:
bash-2.05b$ sqlplus wells/blah@test
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
TNSPING:
bash-2.05b$ tnsping test
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10g/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521))
OK (40 msec) 3 37875
The windows file tnsnames.ora had contrl characters
that messed up SQLPLUS!!
On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote: why can I TNSPING but I can not connect using SQLPLUS?
Oracle 10g Slackware 10 install 2.6.6 kernel
exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i ORACLE_TERM=xterm
error in sqlplus: bash-2.05b$ sqlplus wells/blah@test
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
TNSPING: bash-2.05b$ tnsping test
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files: /home/oracle/product/10g/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias )SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521)) OK (40 msec)
91YJ_Renegade <sp*****@waxhaw.net> wrote in message news:<pa****************************@waxhaw.net>.. . The windows file tnsnames.ora had contrl characters that messed up SQLPLUS!!
On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote:
why can I TNSPING but I can not connect using SQLPLUS?
Oracle 10g Slackware 10 install 2.6.6 kernel
exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i ORACLE_TERM=xterm
error in sqlplus: bash-2.05b$ sqlplus wells/blah@test
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
TNSPING: bash-2.05b$ tnsping test
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files: /home/oracle/product/10g/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias )SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521)) OK (40 msec
Thnak you. It is working.
91YJ_Renegade <sp*****@waxhaw.net> wrote in message news:<pa****************************@waxhaw.net>.. . The windows file tnsnames.ora had contrl characters that messed up SQLPLUS!!
On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote:
why can I TNSPING but I can not connect using SQLPLUS?
Oracle 10g Slackware 10 install 2.6.6 kernel
exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i ORACLE_TERM=xterm
error in sqlplus: bash-2.05b$ sqlplus wells/blah@test
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
TNSPING: bash-2.05b$ tnsping test
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004 11:31:28
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files: /home/oracle/product/10g/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias )SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521)) OK (40 msec)
Thank you. It is working :) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lhansen |
last post by:
I've seen posts similar to this, but have not found the magic bullet to
solve my problem..
I have an asp page (see source code below) running on IIS 6.0 on
Win2003 Server that tries to get file...
|
by: banz |
last post by:
Hello
I have a problem to resolve: I wrote a Perlscript which caches data from a
server (local on my machine) I would like to have a other connection to a
remote server but I don't know how to...
|
by: Kristof Thys |
last post by:
Hello,
I'm developing a C# - windows forms application. To get some information
for my application, I'm connecting to an URL, wich gives me XML
generated using php.
With 90% of the users, this...
|
by: Suresh |
last post by:
Hi Guys
I have Db2 server installed on remote server. i am connecting to that
remote server by using VPN.
I want to connect that remote DB2 server instance using my local
machine DB2...
|
by: Thom Little |
last post by:
I have a simple web service that requires no input and returns a character
string.
I created the service and FTPd it to a remote server. The .dll to the .bin
directory and the single .asmx file...
|
by: Tor Inge Rislaa |
last post by:
Database on remote server
On the remote server where my ASP.NET application is located there is no SQL
Server or SQL Server Express. When I test my application locally it works
fine because...
|
by: Vadim Malishev |
last post by:
Hello,
Can anybody help to solve the following problem?
My Windows Service trying to access remote machine to get WindowsDirectory
Property over Win32_OperatingSystem WMI class. Both servers...
|
by: 91YJ_Renegade |
last post by:
why can I TNSPING but I can not connect using SQLPLUS?
Oracle 10g
Slackware 10 install 2.6.6 kernel
exports
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/10g
ORACLE_SID=ora9i...
|
by: Brett |
last post by:
I wrote an ASP.NET application that queries a SQL Server database (on a
different box from the web server) and displays the result in a GridView.
The datasource for the GridView is a SQLDataSource....
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |