Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    Apr 2004
    Posts
    8

    Unanswered: problem starting database (12560 TNS error)

    Oracle 8.1
    Windows 2000

    I'm a total Oracle idiot but of course, I have to fix this issue. One of our existing databases just started having an issue.

    Fatal NI connect error 12560, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracl e)(ARGV0=oracleNYCDB)(ARGS='(DESCRIPTION=(LOCAL=YE S)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=N YCDB)(CID=(PROGRAM=D:\Oracle\Ora81\BIN\SVRMGRL.EXE )(HOST=ORACLE-CA)(USER=0ra.username))))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
    Time: 23-APR-2004 15:27:49
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNSrotocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0
    This was an existing server that was working fine, that nobody touched lately, but starting having an issue after a hotfix, I think.

    I'm a complete DB moron, so please be gentle.. Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    when do you get this error?

    go to a cmd prompt ant type
    set oracle_sid=<SID>
    svrmgrl
    connect internal

    and then is your database running? ie Do you have a database problem or a listener problem?
    There are 10 types of people in the world, those that know Binary and those that don't.

  3. #3
    Join Date
    Apr 2004
    Posts
    8
    I can't get the database to turn on. When I try to start the db via services, it just says "starting" and it never turns on.

    C:\Documents and Settings\Administrator>set oracle_sid=<SID>
    The syntax of the command is incorrect.

    C:\Documents and Settings\Administrator>svrmgrl

    Oracle Server Manager Release 3.1.6.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    ORA-12560: TNSrotocol adapter error
    SVRMGR> connect internal
    Password:
    ORA-12560: TNSrotocol adapter error

  4. #4
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    you need to replace <SID> with the sid of your database
    There are 10 types of people in the world, those that know Binary and those that don't.

  5. #5
    Join Date
    Apr 2004
    Posts
    8
    Got it... sorry...

    C:\Documents and Settings\Administrator>set oracle_sid=NYCDB

    C:\Documents and Settings\Administrator>svrmgrl

    Oracle Server Manager Release 3.1.6.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    ORA-12560: TNSrotocol adapter error
    SVRMGR> connect internal
    Password:
    ORA-12560: TNSrotocol adapter error
    SVRMGR>

  6. #6
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    forget this bit for now until you can connect via svrmgrl ....

    once you are connected type startup and report back the error

    also, find the error log, I'd guess it will be in D:\Oracle\admin\<SID>\bdump\alert<SID>.log and post the last few minutes worth from the bottom
    Last edited by robert xr4x4; 04-28-04 at 15:07.
    There are 10 types of people in the world, those that know Binary and those that don't.

  7. #7
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    what the status of the windows service, is it started?
    There are 10 types of people in the world, those that know Binary and those that don't.

  8. #8
    Join Date
    Apr 2004
    Posts
    8
    Status in service says: starting

    When starting the service, I get a starting popup window showing that it's attempting to start and then

    "Could not start the OracleServiceNYCDB service on Local Computer.
    Error:1053: The service did not respond to the start or control request in a timely fashion. "

  9. #9
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    ok, so long as it says started then you should be able to get into svrmgrl

    in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 (assuming the database is in home 0)
    what is the value of the ORA_NYCDB_PFILE key?
    what is the value of the ORA_NYCDB_AUTOSTART key?

    can you confirm that the sid is NYCDB

    can you copy the entry from your tnsnames file, D:\Oracle\Ora81\network\admin\tnsnames.ora
    There are 10 types of people in the world, those that know Binary and those that don't.

  10. #10
    Join Date
    Apr 2004
    Posts
    8
    It doesn't say start .. it says starting but the database doesn't start.

    EXTPROC_CONNECTION_DATA.NE.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    NYCDB.NE.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-ca.NE.COM)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = NYCDB)
    )
    )
    ORA_NYCDB_PFILE:
    D:\Oracle\admin\NYCDB\pfile\init.ora

    ORA_NYCDB_AUTOSTART key: TRUE

    I have it set to manual in Services for now until I get it fixed.

  11. #11
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    The oracle service must be running, regardless of whether it can open the database.

    The service MUST say "started" the fact you get an error is irrelevant. Does the service stay "started" or does it stop? If it stops after the error then you need to look at the windows event log to see if there is a meaningfull error
    There are 10 types of people in the world, those that know Binary and those that don't.

  12. #12
    Join Date
    Apr 2004
    Posts
    8
    it stays on "starting".
    Attached Thumbnails Attached Thumbnails services.gif  

  13. #13
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Your Windows service might get corrupted. Try to recreate the service:

    - stop the Oracle Service...
    - delete it

    c:\> oradim -delete -sid .....

    - recreate it

    c:\> oradim -new -sid ..... -intpwd ....... -startmode a -pfile .........



    HTH,

    clio_usa - OCP 8/8i/9i DBA

  14. #14
    Join Date
    Apr 2004
    Posts
    8
    Thanks but didn't help... Here is my listener.trc ....
    Attached Files Attached Files

  15. #15
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    On Win2K, M$ made some slight changes in the way a service must respond during startup. This resulted in many previously happy services being reported as failing to start on the service manager.

    I often see the same message on my laptop (like me, a very slow old beast) during Oracle Service startup. Wait a few minutes, press F5 to refresh the services display status and you may find that it did start correctly after all.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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