start up
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: start up

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Hi,
    can any1 plss tell me how do i start the oracle service from the Unix prompt?

    I been working on NT for a loooong time....

    and In NT..its a s simple as going to thr contol panel/servives and stating the service.......

    thanx for the help

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    there are no services with Unix, now you're going to work on a really efficient OS
    you need to use server manager.
    first check your env variables ORACLE_HOME and ORACLE_SID, as well as your PATH, then :
    $> svrmgrl
    svrmgrl> startup

  3. #3
    Join Date
    Jun 2001
    Posts
    316
    ya that starts the database.....
    But now that I have my service itself stopped.......
    can i start it any how from here?

  4. #4
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Ensure the environment variable ORACLE_SID is set to the correct database name then run server manager and startup the instance....

    UNIX> export ORACLE_SID=mydatabase
    UNIX> svrmgrl
    SVRMGRL> connect internal
    SVRMGRL> startup

    The Oracle listener command is 'lsnrctl start'

    Cheers

    Moff



  5. #5
    Join Date
    Jun 2001
    Posts
    316
    SVRMGR> startup
    LCC-00161: Message 161 not found; product=RDBMS; facility=MGR

    ORA-12560: TNSrotocol adapter error
    SVRMGR>


    SVRMGR> connect internal@local
    Password:
    Password:
    ORA-12500: TNS:listener failed to start a dedicated server process
    SVRMGR>


    why does it ask a password for the internal?

    Thanx

  6. #6
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    check the parameter :
    remote_login_passwordfile
    if it is defined in your init.ora, it should be = none, else define it like that, and you'll no longer have to enter a password as long as you're connected using a login that belongs to the dba group

  7. #7
    Join Date
    Jun 2001
    Posts
    316
    No it stil asks for the password......

  8. #8
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    what is the login you are connected with ???
    what are the groups this login belongs to ???

  9. #9
    Join Date
    Jun 2001
    Posts
    316
    Actually the porblem is this....

    If i start the oracle service from control panel/services (in NT)

    then

    $svrmgrl enter

    svrmgr>connect intrnal@local enter
    connected
    svrmgr>shut down immediate

    blah
    blah
    shutdown

    svrmgr>

    hen i go to the control panel/services stop the oracle service going on

    then i come to unix again
    $svrmgrl enter
    svrmgr>connect internal@local enter
    password:
    password:
    ORA-12500: TNS:listener failed to start a dedicated server process
    SVRMGR>

    This is the problem..
    i hope u guys can understand what i am trying to say.....

    thanx a lot


  10. #10
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    your problem is well understood. forget about services, under Unix you have your instance running or not, and it's just a group of processes.
    now, to help you with your problem : what is the login you are using, what are the groups your login belongs to ???

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