SYS Problem - Oracle 8.1.6 / Win NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SYS Problem - Oracle 8.1.6 / Win NT

  1. #1
    Join Date
    Dec 2001
    Posts
    221
    1. I deleted oracleservice using oradim.
    oradim -delete -sid RND
    2. I created the new service.
    oradim -new -sid RND -intpwd PWD -pfile FILENAME
    -startmode a

    My problems -

    1. My database could not start when my services are started auto.
    2. I couldn't connect to sys. says invalid password
    i changed it from internal using alter user statement
    3. i couldn't SHUTDOWN from sys. gives
    insufficeint privileges.


    Any idea !!! am i missing something.

    Santosh Jadhav
    8i OCP DBA

  2. #2
    Join Date
    Feb 2002
    Posts
    267
    check init.ora parameter

    remote_login_passwordfile=exclusive

    [Edited by sonia on 05-05-2002 at 08:21 AM]

  3. #3
    Join Date
    Dec 2001
    Posts
    221
    its exclusive.
    Santosh Jadhav
    8i OCP DBA

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    being connected as internal
    did you try ..
    connect sys/ as sysdba?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    1. When u create the SID, u need not give the startmode option. By default it will be set as automatic.
    Even if it is set as manual, go to Control Panel->Services and change it to Automatic.

    2. For performing the STARTUP and SHUTDOWN operations your user should have the SYSDBA privileges.
    If you want to perform all these things by connected as the SYS user then you should connect like,

    connect sys/pwd as sysdba.

    Vijay.

    Say No To Plastics

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