Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    16

    Unanswered: ODBC and ORA-01017

    I have set up an Oracle 9.2 database on a HP-UX system and I plan to use external user authentication.

    In the init.ora file I have set the following parameters:
    os_authent_prefix = ''
    remote_os_authent = 'TRUE'

    I have created a user with the following statement

    CREATE USER HPSIC IDENTIFIED EXTERNALLY
    DEFAULT TABLESPACE HPSIC_DATA
    TEMPORARY TABLESPACE TEMPTBS
    QUOTA UNLIMITED ON HPSIC_IDX
    QUOTA UNLIMITED ON HPSIC_DATA;

    GRANT DBA TO HPSIC

    When I log on the Unix system using HPSIC and I issue SQLPLUS /, everything works. When I connect from Windows XP, using ODBC or Enterprise Manager Console, I get the following message
    ORA-01017: invalid username/password; logon denied.
    Everything works using a local Oracle account, for example SYSTEM.

    In the tnsnames.ora I have the following configuration
    TESTSIC =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hpsicmi05.italy.hp.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = testsic)
    (SERVER = DEDICATED)
    )
    )

    In sqlnet.ora there are the following data
    NAMES.DEFAULT_DOMAIN = emea.cpqcorp.net
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

    Any suggestions are appriciated.
    Thanks,

    Marta

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    Looks like you posted the same question twice. I responded to the other one.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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