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

    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
    Location
    Cape Town, South Africa
    Posts
    253
    SID should be ORACLE_SID if you are setting an environment variable.
    What is the result of
    Code:
    tnsping orcl

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    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: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

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
  •