sp2_0640 not connected, plus other 'login' issues
Posted on 2005-04-26
I am trying run create statements & stored procedures/tablespaces etc on 2 of my db servers:
I can connect as sysdba and either using OEM or as normal login and its fine but once i start to run '@create.sql' statement from my c: drive (all files are here and normally work) but i keep getting the error:
SP2_0640 NOT CONNECTED,
if i then type show user
i get ''
so basically it keeps dropping off.? I have checked my tnsnames.ora, listener.ora and sqlnet.ora and restarted the services, and rebooted and the same keeps happening. I thought it was just one db but its happening to them all> any ideas?