Ok i have this error on my oracle 8.1.7 database with oracle developer 6i R2.
This usually happened when the computer is improperly shutdown like of power failure or BSOD.
Been searching on the internet most of the solution is to connect straight to sqlplus, like this:
– open the command prompt.
– in “c:\>”, type “sqlplus /nolog”
– in “sql>” type connect / as sysdba
Now this is the problem, based on the tutorial it should generate “connected” status, even though i’ve tried using the proper form of “connect sys/manager as sysdba” it still generating TNS error.