DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to startup database remotely by using spfile

  1. 05-30-2006, 03:18 PM #1
    oradba2006
    oradba2006 is offline Junior Member
    Join Date
    May 2006
    Posts
    6

    How to startup database remotely by using spfile

    Oracle 10g database (Enterprise Edition) has been shutdown. Can I startup this database remotely. This database uses spfile.ora. Thanks.
    Reply With Quote Reply With Quote
  2. 05-30-2006, 04:12 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes you may
    Reply With Quote Reply With Quote
  3. 05-30-2006, 07:31 PM #3
    oradba2006
    oradba2006 is offline Junior Member
    Join Date
    May 2006
    Posts
    6
    I am getting following error when I am trying to startup database remotely.
    ORA-12560: TNSrotocol adapter error.

    At windows prompt I did following
    set oracle_sid=orddb
    sqlplus /nolog
    conn sys as sysdba
    password
    connected to idle instance.

    Do I need set up something else before starting up database remotely. I am able to connect to this database remotely when database is open, but unable to startup when it is shutdown.
    Reply With Quote Reply With Quote
  4. 05-31-2006, 03:56 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    thats will try to start a database on the local machine, not a remote one
    Reply With Quote Reply With Quote
  5. 05-31-2006, 08:13 AM #5
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    why dont u read a bit? ( especially client server concepts )..

    and then start oracle cocepts
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  6. 05-31-2006, 09:34 AM #6
    charlton
    charlton is offline Junior Member
    Join Date
    Jan 2002
    Posts
    96

    Smile

    You need to specify the database name you wanna connect to in your connect string. If you are connecting to a remote DB.
    Make sure the DB is in you tnsnames file....lol

    >conn sys@DB_NAME
    >Password as sysdba
    >startup
    Last edited by charlton; 05-31-2006 at 09:36 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width