Problem: Error message when creating dictionary views and system stored procedures.
SP2-0640: Not connected error message when running catcdb.sql
Environment:
Database Software: Oracle 12c Release 2
Operating System: Windows Server 2012 R2 Standard - 64 Bit
Workaround:
In sqlnet.ora make sure below parameter is set:-
SQLNET.AUTHENTICATION_SERVICES = (NTS)
This SQLNET.AUTHENTICATION_SERVICES = (NTS) parameter is required in order for the the catcdb.sql script and subsequent perl scripts to successfully connect to the database and run, otherwise you may encounter "SP2-0640: Not connected" error messages. Once the installation is complete, you may remove this parameter or comment it out.
Exit out of SQL*Plus, reconnect, drop and recreate the database, and rerun "catcdb.pl" script.
Hope it helps.
No comments:
Post a Comment