Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Unanswered: Problem with my Oracle connection

    Hello,

    I have a oracle 9.2i standard edition on a linux SuSE 8.2 installation and I try to connect from my Windows 2000 PC. Everything that I tried ended with:

    ORA-12154: TNS:could not resolve service name

    I did write to my local tnsnames.ora the connection string also I did it on the server.

    If I connect to the server via ssh it works. But with the new schema It doesn't work even with the ssh stuff.

    Can anyone please help me?

    the entry from the tnsnames.ora is like:

    TEST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = "ip-adresse")(PORT = 1521)
    )
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    (INSTANCE_NAME = test)
    (GLOBAL_NAME = test)
    )
    )

    Thanks in advance,

    sincerly
    Alexander Pfeifer

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: Problem with my Oracle connection

    Originally posted by al3xand3r
    Hello,

    I have a oracle 9.2i standard edition on a linux SuSE 8.2 installation and I try to connect from my Windows 2000 PC. Everything that I tried ended with:

    ORA-12154: TNS:could not resolve service name

    I did write to my local tnsnames.ora the connection string also I did it on the server.

    If I connect to the server via ssh it works. But with the new schema It doesn't work even with the ssh stuff.

    Can anyone please help me?

    the entry from the tnsnames.ora is like:

    TEST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)
    (HOST = "ip-adresse")(PORT = 1521)
    )
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    (INSTANCE_NAME = test)
    (GLOBAL_NAME = test)
    )
    )

    Thanks in advance,

    sincerly
    Alexander Pfeifer
    Yes, but you really did not show EXACTLY what you tried,
    so it is hard to say what is wrong.

    Can you ping ip-adresse?

    What in the world do you mean about "new schema"?

    Did this ever work?
    What changed?

    What is in listener.ora?

  3. #3
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    good questions above

    All good questions to answer above and add this one:
    Is the listener turned on (on the server)? Make sure.
    Michellea Southern-David

  4. #4
    Join Date
    Oct 2003
    Posts
    4
    I tried to connect with sqlplus to the oracle database and this doesn't work. If I use the Enterprise Manager and connect to the database it works really fine, even the connection test give me a success. But if I only use sqlplus or sqlplus-worksheet, I get the error message:

    ORA-12154: TNS:could not resolve service name

    The listener.ora looks like this:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = "ip-adress")(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /opt/oracle/product/oracle)
    (PROGRAM = extproc)
    )

    I can ping the ip and I can connect to the other instance (I thought by oracle it would be named with "schema" not instance) that there is running (but I cannot connect to their with sqlplus either).

    The only thing that changed is, that there now is running a new instance with the name test as a test server to develop further.

    I do not understand why I can connect with the Java application and with the Enterprise Manager (from Oracle), but it doesn't work with the simple sqlplus or sqlplus worksheet.

    The listener is turn on. If it would be off, I could not connect with the application or anything else, or?

    Thanks in advance.
    Sincerly,
    Alexander Pfeifer

  5. #5
    Join Date
    Oct 2003
    Posts
    4
    Thanks again, but I found the error.

    It was just a wrong line in the sqlnet.ora.

    bye
    Alexander Pfeifer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •