Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQLPLUS on OpenVMS
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
![]() |
![]() |