Have you find this error, there are many cause of this error, but if this is happened when installing database then this is probably because either the service is stopped or because you connected to computer remotely using remote desktop connection. Continue reading
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.