SP2-0640: Not Connected ( help please)
422170Jun 6 2005 — edited Jun 7 2005 Hi
I have set up VSM 1.3. It was working fine, a few months back, and I never changed any settings, as far as I can remember. Today, I wanted to fire up VSM. So I connected to Oracle and then tried to create user "webstore" with password "welcome".
I typed the same as before from my <VSM_install_dir>/sqlplus directory, which is: sqlplus /nolog @webstore.sql
and what happens is the following: (after entering thee password and oracle SID):
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
ERROR:
ORA-12170: TNS: Connect timeout occurred
I also cannot connect to Oracle Enterprise Manager as well.
It was all working fine.
I changed from a DSL connection to a dial up one recently and so my computer is now not part of the router based network of 3 PCs running on a DSL connection. Does this change have anything to do with my problem?
I am not at all familiar with Oracle. It appears so huge and daunting and baffling to me. Any help is greatly appreciated. Thanks in advance