SQR and OPS$ Accounts

[Mara L Wells <mlwells@IX.NETCOM.COM>]

I am having a problem with an item I found in the FAQ section of the
SQR Users web site.

Q: Are ORACLE OPS$ accounts supported in a connect string for SQR?
A: Yes. After login as an OPS$ user, the SQR command is:
        sqr report /@t:machine:database

What follows are the results of several tests I ran to determine how
SQR and the OPS$ accounts were set up on the system I am using.  Null
inputs (i.e. tapping enter as a response) are annotated as <null
input>.

--------------------------------------------------------------------

TEST 1:

:/home> sqlplus /

SQL*Plus: Release 3.1.3.5.1 - Production on Thu Mar  7 14:45:29 1996

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

Connected to:
Oracle7 Server Release 7.1.4.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.4.3.0 - Production

SQL> exit
Disconnected from Oracle7 Server Release 7.1.4.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.4.3.0 - Production
:/home>

------------------------------------------------------------------------

TEST 2:

:/home> sqlplus /@t:corpdev1:new7

SQL*Plus: Release 3.1.3.5.1 - Production on Thu Mar  7 14:46:47 1996

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

ERROR: ORA-01004: default username feature not supported; logon denied
ORA-01988: remote os logon is not allowed

Enter user-name: <null input>

Connected to:
Oracle7 Server Release 7.1.4.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.4.3.0 - Production

SQL> exit
Disconnected from Oracle7 Server Release 7.1.4.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.4.3.0 - Production
:/home>

------------------------------------------------------------------------

TEST 3:

:/home> sqlplus

SQL*Plus: Release 3.1.3.5.1 - Production on Thu Mar  7 14:47:59 1996

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

Enter user-name: 12345
Enter password: <entered password>

Connected to:
Oracle7 Server Release 7.1.4.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.4.3.0 - Production

SQL> exit
Disconnected from Oracle7 Server Release 7.1.4.3.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.4.3.0 - Production
:/home>

------------------------------------------------------------------------

TEST 4:

:/home> sqr dropall.sqr /
SQR: Structured Query Report Writer V3.0.7
Copyright (C) MITI, 1994, 1995.  All Worldwide Rights Reserved.

(SQR 5528) ORACLE ORLON error -1004 in cursor 0:
   ORA-01004: default username feature not supported; logon denied
(SQR 4701) Can't logon to the database.

SQR: Program Aborting.
:/home>

-----------------------------------------------------------------------

TEST 5:

:/home> sqr dropall.sqr /@t:corpdev1:new7
SQR: Structured Query Report Writer V3.0.7
Copyright (C) MITI, 1994, 1995.  All Worldwide Rights Reserved.

(SQR 5528) ORACLE ORLON error -1004 in cursor 0:
   ORA-01004: default username feature not supported; logon denied
(SQR 4701) Can't logon to the database.

SQR: Program Aborting.
:/home>

------------------------------------------------------------------------

TEST 6:

:/home> sqr dropall.sqr
Enter Username: <null input>
Enter Password: <null input>

SQR: Structured Query Report Writer V3.0.7
Copyright (C) MITI, 1994, 1995.  All Worldwide Rights Reserved.

(SQR 5528) ORACLE ORLON error -1004 in cursor 0:
   ORA-01004: default username feature not supported; logon denied
(SQR 4701) Can't logon to the database.

SQR: Program Aborting.
:/home>

-----------------------------------------------------------------------

TEST 7:

:/home> sqr dropall.sqr
Enter Username: 12345
Enter Password: <entered password>

SQR: Structured Query Report Writer V3.0.7
Copyright (C) MITI, 1994, 1995.  All Worldwide Rights Reserved.

SQR: End of Run.
:/home>

---------------------------

After trying these combinations of the suggested command line, I was
still at a loss as to what the system was expecting.

My question to the learned peoples who read this list is this.  What
can be done to get the OPS$ accounts work with SQR?  Is it the SQR
setup? Is it the Oracle database setup? Is it the UNIX setup? Or
possibly a combination of all 3?

Mara L. Wells
Senior Consultant
REALOGIC, Inc.