Oracle 11.2 on Windows7 -- tnsping OK , sqlplus hangs

[oratech]

Cannot connect to Local database on windows7 laptop.
tnsping comes as OK but sqlplus hangs.
Oracle SID is ORCL and these services are up -

OracleServicesORCL
OracleOraDb11g_home1TNSListener

but "Oracle ORCL VSS Writer Service" is not coming up.
I am able to connect to other databases in the network but not to my local DB instance.

Need help to resolve this !

thanx

[gandolf989]

Just because the listener tells you that it is listening for a database on a certain port, does not mean that it can connect to that database, or that the database even exists. You want to make sure that the OracleServicesORCL is set to autostart. You also want to connect without the listener as sys with sysdba. Did you look at the alert log for ORCL? You need to start there to see if the database is open, not just that the service is running.

[oratech]

Could not find the alert.log !
used even this command to locate it but no alert file was found --
dir /s alert*.log|more

[oratech]

I am running SQL NET trace, handshake is not completing , see some info from the trace

[10-JAN-2013 16:02:08:269] nttcon: set TCP_NODELAY on 608
[10-JAN-2013 16:02:08:269] nsopen: transport is open
[10-JAN-2013 16:02:08:269] nsnainit: inf->nsinfflg[0]: 0x41 inf->nsinfflg[1]: 0x41
[10-JAN-2013 16:02:08:269] nsopen: global context check-in (to slot 0) complete
[10-JAN-2013 16:02:08:269] nscon: doing connect handshake...
[10-JAN-2013 16:02:08:269] nscon: sending NSPTCN packet
[10-JAN-2013 16:02:08:269] nscon: sending 239 bytes connect data
[10-JAN-2013 16:02:08:269] nsdo: 239 bytes to NS buffer

[gandolf989]

The location of the diag directory is probably in the init/spfile. Look in there and it will tell you where to look. It would be in a diag directory somewhere on the server.

[skhanal]

Is there a firewall between client and server?. Can you telnet to Oracle port (1521)

telnet server 1521

If you can connect that means firewall is open.

[gandolf989]

Is there a firewall between client and server?. Can you telnet to Oracle port (1521)

telnet server 1521

If you can connect that means firewall is open.

You advice is unhelpful since it is a local database running on a laptop. The original poster is likely accessing the database directly from the laptop. It is a question of getting the environment variables right and making sure the service is running and setup correctly.

[oratech]

There is fatal error getting written in alert log which is --

Fatal NI connect error 12560, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 17-JAN-2013 16:53:14
Tracing not turned on.
Tns error struct:
ns main err code: 12560

TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (3740) as a result of ORA-609
Thu Jan 17 17:02:47 2013
Starting background process SMCO
Thu Jan 17 17:02:47 2013
SMCO started with pid=21, OS id=4768

[gandolf989]

I'm guessing that it is an empty database. hence you are better off using oradim to delete the instance. Then go to youtube and look for a video where someone creates and oracle database. Watch the video and use dbca to create a new database. In this case you probably did not give the database enough memory to run. But if you are trying to learn it can't hurt to practice.