Board index Oracle

Connecting to Instance from Client machine - newbe question

Connecting to Instance from Client machine - newbe question

Post by MLJ » Sun, 31 Dec 1899 09:00:00



Hi,
We have a Oracle 7.3.4 server.
I am trying to setup a client machine to connect to this instance.
The client is a unix box.

I have setup the listener.ora and tnsnames.ora
I have setup ORACLE_SID
and exported it.

When i try to connect with sqlplus, without specifying the $ORACLE_SID,
I get the message
ERROR: ORA-12545: TNS:name lookup failure

I have installed,
Oracle Names 2.0.4.0.0
Oracle Unix Installer 4.0.1.0
Oracle JDBC Driver 7.3.4.0
Pl/Sql v2 2.3.4.0.0
Pro*C 2.2.4.0.0
SQL*Module for C 1.1.5.0.0
SQL*Net (v2) 2.3.4.0.0
SQL*Plus 3.3.4.0.1
Tcp/Ip Protocol Adapter (v2)
Server Manager (Motif) 2.3.4.0.0
Does anyone have any clues about this
thanks
dinyar

 
 
 
Top

1. Newbe Question: Connecting to SQL With Access 2000...

I am trying to connect to my SQL Server 2000 over the internet. I am using
the Project feature of Access 2002. I always get some sort of error; no
trust connection, no server, etc.

Could someone please explain to me ho to connect to my SQL over over the
internet in detail. I have read and tried many different things but still no
go.
I appreciate any help someone can give me.


2. small dblink patch

3. Newbe question: client library?

4. Delphi 3 and Access Tables

5. 2 Instances, 1 machine VS 1 Instance 2 databases

6. How to retrieve records from the same table in a better way

7. Connecting to SQL from a client machine

8. Trigger + UpdLock

9. NT4 machine with SQL2K client tools connecting to SQL2K Cluster

10. Unable to connect to MSDE 7.0 from client machines

11. Connect from Client Machine through Proxy Server

12. NT4 machine with SQL2K client tools connecting to SQL2K Cluster

13. DTS execution from client machine fails connecting to Oracle


All times are UTC
Board index