Database Links and OS Authentication

Database Links and OS Authentication

Post by Jeff Hunte » Fri, 17 Apr 1998 04:00:00



Greetings all,

I know that I have done this in UNIX but can't seem to get it to work in
NT 4.0
using Oracle 8.0.3. I have two instances: OEM and DEV. They both have
public (anonymous) database links pointing to each other. I have users
on
each of those databases being authenticated at the OS level. (OPS$).
When I try to access the database link from any of the OPS$ accounts,
I get the following message:

/* -------------------- SNIP ----------------------------*/

C:\WINNT\system32>plus80 /

SQL> select user from dual;

USER
------------------------------
OPS$JHUNTER



                         *
ERROR at line 1:
ORA-01004: default username feature not supported; logon denied
ORA-02063: preceding line from DEV

/* -------------------- SNIP ----------------------------*/

Any suggestions?!?!?!?

Thanks in advance
-- Jeff


Programmer/Analyst           WWW: www.isrv.com/~jhunter
PO BOX 832                   Voice: (724) 284-7325
Butler, PA 16003-0832        FAX: (724) 789-9601

  vcard.vcf
< 1K Download
 
 
 

1. Problems with database links on SUN OS.

Oracle 7.3.4 on Sun OS 5.6. I have a database link. SQLPlus works on the
client. But I can't get it to work on the server. This is my statement and
error messages. Anyone have any idea?


ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION
ORA-02063: preceding line from database

Thank you

2. US-CT-DATABASE ADMINISTRATOR / ORACLE

3. OS level authentication with JDBC

4. Problem using ADO SHAPE

5. SYSDBA & SYSOPER and os authentication through OEM

6. SQL net v2 with Oracle v6

7. OS Authentication

8. Problem to start master server of Sybase 11.5

9. OS authentication with Oracle8i on Windows 2000 Professional

10. Oracle9i/ODBC/stored procs/OS authentication/ref cursor problem

11. OS Password authentication

12. ODBC and OS user authentication problems

13. Is OS authentication secure enough?