“SP2-0310”解决方法

【报错代码】
SP2-0310: unable to open file “up.sql”

[oracle@edgzrip1-PROD1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue May 19 10:11:38 2020
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> start up
SP2-0310: unable to open file "up.sql"

【解决方法】startup中间没有空格

SQL> startup
ORACLE instance started.

Total System Global Area  418484224 bytes
Fixed Size                  1345352 bytes
Variable Size             285214904 bytes
Database Buffers          125829120 bytes
Redo Buffers                6094848 bytes
Database mounted.
Database opened.

问题是varchar 与 varchar2 的区别，别打错了。startup中间没有空格。oracle自己规定的没办法哦。