Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2013

    Unanswered: Unable to connect to oracle with different OS user accout

    I have installed oracle on Ubuntu with OS user oracle. When I try to connect to oracle with logged on as different OS user (other than oracle), I get error SQL> connect user1/user1@orcl ORA-12154: TNS:could not resolve the connect identifier specified

    However, if I don't mention oracle SID then i don't get any error. SQL> connect user1/user1 Connected to: Oracle Database SQL>

    I have declared ORACLE_HOME & SID in the user profile. But it did not work. Can someone please help me to understand the issue.

  2. #2
    Join Date
    Oct 2002
    Cape Town, South Africa
    SID should be ORACLE_SID if you are setting an environment variable.
    What is the result of
    tnsping orcl

  3. #3
    Join Date
    Nov 2003
    Provided Answers: 23
    In this statement: connect user1/user1@orcl
    orcl is not the SID, it's a connect identifier defined in tnsnames.ora

    So how does your tnsnames.ora look like?
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags:

    Tips for good questions:

Tags for this Thread

Posting Permissions

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