|External users and ORA-01017 [message #158554]
||Mon, 13 February 2006 02:42
Registered: February 2006
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
(ADDRESS = (PROTOCOL = TCP)(HOST = hpsicmi05.italy.hp.com)(PORT = 1521))
(SID = testsic)
(SERVER = DEDICATED)
In sqlnet.ora there are the following data
NAMES.DEFAULT_DOMAIN = emea.cpqcorp.net
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.