Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Unanswered: Cannot start Ora92

    I'm running Ora92 under W2000Server.
    When I open a terminal server conection and start (a remote) SQL Plus session and try to connect SYS as SYSDBA (to startup the DB) I get an ORA-12560, although the listener and the rest of the Oracle processes are running.
    I finally could connect via SQL Plus (starting the session in my desktop) and strart the DB.
    May be this is a bug... does anybody got this error? Any other solution o recomendation?
    Thanks in advance.

    Manf

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    12560, 00000, "TNSrotocol adapter error"
    // *Cause: A generic protocol adapter error occurred.
    // *Action: Check addresses used for proper protocol specification. Before
    // reporting this error, look at the error stack and check for lower level
    // transport errors.For further details, turn on tracing and reexecute the
    // operation. Turn off tracing when the operation is complete.
    ================================================
    Do a GOOGLE search for ORA-12560
    ================================================
    http://download-west.oracle.com/docs...493_01/toc.htm
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    is the listener configured properly?
    post the contents of your listener.ora, tnsnames.ora and your connection line.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    The problem MUST be tnsnames.ora (on the server side)...
    That's why you could enter using your desktop but not via TS.

    Compare tnsnames.ora file from your desktop with the one on the server... that should be the problem.

    Saludos...

  5. #5
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    a lot of Oracle utilities simply will not run properly in a TS session... even when running TS in remote admin mode (hopefully someone wouldn't be stupid enough to run an Oracle db server in TS app server mode )

    you need to take control of the console, which is something that you can't do with Win2K without a third part app, like VNC, PCAnywhere, etc...

    With 2003 Server, you can actually run a console session with Remote Desktop, haven't personally tested whether or not the utilities work in that environment

    another option is to set up something like SSH using Cygwin or an off the shelf SSH product

    can you successfully run sqlplus and connect from the console on your server?
    Last edited by drew; 08-19-04 at 00:35.
    drew
    ------------------
    http://wjtechnologies.com

  6. #6
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    You might be using the BEQ connection for your local connections (may be you don't specify @TNSALIAS), but when you connect remotely you use TNS aliases.

    If that's the case, then check the TNS alias for this database:

    c:\> tnsping TNSALIAS


    Hope that helps,

    clio_usa - OCP DBA 8/8i/9i

  7. #7
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Thumbs up

    Thanks guys for your comments.
    For Duck: the listener was properly configured and running.
    For DKG: both desktop and server tnsnames.ora are well configured (same syntax).
    For clio_usa: doing 'tnsping <alias>' works ok.
    As drew said (I could not find any doc in metalink assuming this) some oracle app may not properly work via Terminal Services. I could not test any other third part app.
    After I connect from my desktop (sys as sysdba) and startup the DB, I was able to start a SQL Plus within the server.
    Thanks again!
    Regards,

    Manf

  8. #8
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Since the tnsping is working - use this to connect:

    SQL> conect sys/<password>@TNSALIAS as sysdba


    Hope that helps,

    clio_usa - OCP DBA 8/8i/9i

Posting Permissions

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