[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]
Re: SQR and OPS$ Accounts

Subject: Re: SQR and OPS$ Accounts
From: "Gayle L. Masters" <GLMASTER@MRA.FFX.MOBIL.COM>
Date: Fri, 8 Mar 1996 08:57:50 EST
     The remote login feature error message is a function of the ORACLE
     setup.  There is a parameter that must be turned on in the init.ora
     file. The parameter is REMOTE_OS_AUTHENT=TRUE

     This will allow remote login using the /.


______________________________ Reply Separator _________________________________
Subject: SQR and OPS$ Accounts
Author:  SQR-USERS@USA.NET at MRA
Date:    3/7/96 10:43 PM


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.

The following is an attached File item from cc:Mail.  It contains
information that had to be encoded to ensure successful transmission
through various mail systems.  To decode the file use the UUDECODE
program.
--------------------------------- Cut Here ---------------------------------
begin 644 rfc822.txt
M4F5C96EV960Z(&)Y(&-C;6%I;"!F<F]M('!E9V%S=7,N;6]B:6PN8V]M#0I&
M<F]M(&]W;F5R+7-Q<BUU<V5R<T!54T$N3D54#0I8+45N=F5L;W!E+49R;VTZ
M(&]W;F5R+7-Q<BUU<V5R<T!54T$N3D54#0I296-E:79E9#H@*&9R;VT@9&%E
M;6]N0&QO8V%L:&]S="D@8GD@<&5G87-U<RYM;V)I;"YC;VT@*$UO8FEL+3,O
M<&5G87-U<RTT*2!I9"!604$R.3DX."!F;W(@/$=,34%35$520$U202Y&1E@N
M34]"24PN0T]-/CL@5&AU+"`W($UA<B`Q.3DV(#(Q.C0X.C4T("TP-C`P#0I2
M96-E:79E9#H@9G)O;2!P;W-T;V9F:6-E+G5S82YN970H,3DR+C$U-BXQ.38N
M-2D@8GD@<&5G87-U<R!V:6$@<VUA<"`H5C$N,RD-"B`@("!I9"!S;6$P,CDY
M.#([($9R:2!-87(@(#@@,#,Z-#@Z,3(@,3DY-@T*4F5C96EV960Z(&9R;VT@
M<&]S=&]F9FEC92`H<&]S=&]F9FEC92!;,3DR+C$U-BXQ.38N-5TI(&)Y(&UA
M:6PN=7-A+FYE="`H."XV+C$P+S@N-BXQ,"D@=VET:"!33510(&ED(%1!03$Q
M,S,T.R!4:'4L(#<@36%R(#$Y.38@,3DZ-3<Z,3(@+3`W,#`-"E)E8V5I=F5D
M.B!F<F]M(%5302Y.150@8GD@55-!+DY%5"`H3$E35%-%4E8M5$-0+TE0(')E
M;&5A<V4@,2XX8BD@=VET:"!S<&]O;"!I9`T*("`@("`@("`@(#0U,S,Y,R!F
M;W(@4U%2+55315)30%5302Y.150[(%1H=2P@-R!-87(@,3DY-B`Q.3HU-SHQ
M,2`K,3<P,`T*4F5C96EV960Z(&9R;VT@:7@Q,"YI>"YN971C;VTN8V]M("AI
M>#$P+FEX+FYE=&-O;2YC;VT@6S$Y.2XQ.#(N,3(P+C$P72D@8GD-"B`@("`@
M("`@("!M86EL+G5S82YN970@*#@N-BXQ,"\X+C8N,3`I('=I=&@@15--5%`@
M:60@5$%!,3$S,C<@9F]R#0H@("`@("`@("`@/%-14BU54T524T!54T$N;F5T
M/CL@5&AU+"`W($UA<B`Q.3DV(#$Y.C4W.C`Y("TP-S`P#0I296-E:79E9#H@
M9G)O;2`@8GD@:7@Q,"YI>"YN971C;VTN8V]M("@X+C8N,3,O4TU)+30N,2].
M971C;VTI(&ED(%-!03$Q-3@Y.R!4:'4L#0H@("`@("`@("`@-R!-87(@,3DY
M-B`Q.#HU-CHS,2`M,#@P,`T*365S<V%G92U)1#H@(#PQ.3DV,#,P.#`R-38N
M4T%!,3$U.#E`:7@Q,"YI>"YN971C;VTN8V]M/@T*1&%T93H@("`@("`@("!4
M:'4L(#<@36%R(#$Y.38@,3@Z-38Z,S$@+3`X,#`-"E)E<&QY+51O.B!345(M
M55-%4E-`55-!+DY%5`T*4V5N9&5R.B`B1&ES8W5S<VEO;B!O9B!345(@<')O
M9'5C=',L('!L871F;W)M<RP-"B`@("`@("`@("`@("`@86YD('!R;V=R86UM
M:6YG(B`\4U%2+55315)30%5302Y.150^#0I&<F]M.B!-87)A($P@5V5L;',@
M/&UL=V5L;'-`25@N3D540T]-+D-/33X-"E-U8FIE8W0Z("`@("`@4U%2(&%N
M9"!/4%,D($%C8V]U;G1S#0I4;SH@375L=&EP;&4@<F5C:7!I96YT<R!O9B!L
C:7-T(%-14BU54T524R`\4U%2+55315)30%5302Y.150^#0H`

end
Prev by Date: SQR and OPS$ Accounts
Next by Date: Re: SQR and OPS$ Accounts
Prev by thread: Reply to SQR and OPS$ Accounts
Next by thread: Re: SQR and OPS$ Accounts
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page