External users and ORA-01017 [message #158554] |
Mon, 13 February 2006 02:42 |
landini
Messages: 2 Registered: February 2006
|
Junior Member |
|
|
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
|
|
|