Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQLPLUS on OpenVMS

SQLPLUS on OpenVMS

From: Cuyler <cuyler_at_gmail.com>
Date: Mon, 09 Jul 2007 11:21:52 -0700
Message-ID: <1184005312.990537.179970@c77g2000hse.googlegroups.com>


I'm new with Oracle on VMS and I'm having a few difficulties with getting a SQL script to run properly on the system. I can connect to the database and manually run the script (copy and paste from it) just fine but when I put those into a .SQL script and call it it I get an error. I've recreated the script manually to ensure I don't have any non-printable characters in the file causing me grief.

Here's the output (server name, user names and passwords obviously changed). Extra blank lines removed. I'd appreciate any light you folks could she don this - I'm sure it's something really simple I'm over looking.

VMSHOST::VMS_USER $ sqlplus my_username/my_password SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jul 9 14:07:29 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production With the Partitioning and Real Application Clusters options JServer Release 9.2.0.8.0 - Production
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning and Real Application Clusters options JServer Release 9.2.0.8.0 - Production

VMSHOST::VMS_USER $ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jul 9 14:07:43 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect my_username/my_password
Connected.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning and Real Application Clusters options JServer Release 9.2.0.8.0 - Production

VMSHOST::VMS_USER $ type test.sql
CONNECT my_username/my_password
EXIT VMSHOST::VMS_USER $ sqlplus @test.sql
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jul 9 14:08:06 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_string>] | / Enter password:
ERROR:
ORA-01005: null password given; logon denied Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus Received on Mon Jul 09 2007 - 13:21:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US