-
Hi,
Problem I'm facing due to OS authentication
I have installed Oracle 8.1.6 on Sun solaris ( OS 2.8 ) in the
following ORACLE_HOME
/oracle/app/oracle/product/8.1.6
I have installed Forms 6.0.8 ( Developer 6i ) in the following
ORACLE_HOME
/oracle/app/oracle/product/8.1.6/d2k
The init.ora file has the following settings made for
OS authentication
remote_login_passwordfile = none
os_authent_prefix = ops$
2 oracle users are ops$hcsdevp and ops$hms
corresponding unix users are 'hcsdevp' and 'hms'
hms user profile has ORACLE_HOME variable set to
/oracle/app/oracle/product/8.1.6
hcsdevp user profile has ORACLE_HOME variable set to
/oracle/app/oracle/product/8.1.6/d2k
I can connect to database thr' hms user using OS
authentication
$sqlplus /
gets connected
sql>
But when I connect to hcsdevp user using OS authentication
I get the following error
$sqlplus /
I get the following error message :
ORA-01004 - default username feature not supported; logon
denied.
But I can connet using any normal oracle users like
system/manager or scott tiger .
Pl. mail me the solution urgently
Thanks
my email is shankar_gk@hotmail.com, kgshangs@yahoo.com
-
When the environment is setup with the 8.1.6 HOME, you can connect without specifying an alias. When you set the $OH to the 8.0.6 client (forms), you must specify an alias from your tnsnames.ora file.
For example:
sqlplus /@yourdbname
You can check that you have set the user up correctly by setting hcsdevp 's environment to the 8.1.6 $OH and connecting:
sqlplus /
If this works, this means you have set the user up correctly.
Jeff Hunter
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
|