sqlplus troubleshooting

1.      分析数据库出错可以到$ORACLE_BASE/admin/EMS/bdump目录下的alert_EMS.log中查找(/oradata/oracle/ORACLE/app/oracle/admin/EMS/bdump/alert_EMS.log)

2.      SQL> !oerr ora 39700  #在SQLPLUS种输入相应error code可查看details

39700, 00000, "database must be opened with UPGRADE option"

// *Cause: A normal database open was attempted, but the database has not

//         been upgraded to the current server version.

// *Action: Use the UPGRADE option when opening the database to run

//         catupgrd.sql (for database upgrade), or to run catalog.sql

//         and catproc.sql (after initial database creation).