Oracle 11.2 on Windows7 -- tnsping OK , sqlplus hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Oracle 11.2 on Windows7 -- tnsping OK , sqlplus hangs

  1. #1
    Join Date
    Jan 2013
    Posts
    4

    Oracle 11.2 on Windows7 -- tnsping OK , sqlplus hangs

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    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.
    this space intentionally left blank

  3. #3
    Join Date
    Jan 2013
    Posts
    4
    Could not find the alert.log !
    used even this command to locate it but no alert file was found --
    dir /s alert*.log|more

  4. #4
    Join Date
    Jan 2013
    Posts
    4
    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

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    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.
    this space intentionally left blank

  6. #6
    Join Date
    Dec 2002
    Posts
    60
    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.

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    Quote Originally Posted by skhanal View Post
    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.
    this space intentionally left blank

  8. #8
    Join Date
    Jan 2013
    Posts
    4
    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

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width