-
External users 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
I try to connect using ODBC or Enterprise Manager Console from a Windows XP 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)
When I log on the Unix system using HPSIC and I issue SQLPLUS /, everything works. When I connect from Windows XP, I get the following message ORA-01017: invalid username/password; logon denied.
Everything works using a local Oracle account, for example SYSTEM.
Any suggestions are appriciated.
Thanks,
Marta
-
i dont think you can do that over odbc
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|