Connecting Internal or as SYSDBA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Connecting Internal or as SYSDBA

  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Question Connecting Internal or as SYSDBA

    I have an Oracle Database system that I have been given which I need to change the initorcl.ora file. I have tried to connect internal without a password and the system denies me with an invalid username/password error. I have also tryed connecting as as sysdba but that didn't work either. I was not here when this system was configured and none of the people who did the configuration work here any longer. Any ideas as to how I can get into the system so to shutdown the database make the changes and restart?

    Oracle Version 8.05 (Yuk, but what my company owns)
    WIN NT 4.0


    Thanks!!
    Last edited by tlmason74; 04-17-2003 at 08:40 AM.

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    What version? note that 9i doesn't support internal.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    also post your os version

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Create new pswd file with ur new pswd using ORAPWD utility.

    Or if ur OS is windows its pretty easy to get into DB as sysdba.

    In SQLNET.ora make the authentication NTS and put the NT user in ORA_DBA group. U can get into DB as SYSDBA without pswd.


    Abhay.
    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"

  5. #5
    Join Date
    Apr 2003
    Posts
    2
    My Oracle Version is 8.05
    OS is Win NT 4.0

  6. #6
    Join Date
    May 2001
    Posts
    736
    Delete your old password and enter into your OS with Administrative user and follow the steps mentioned by Abhay to create the New password file.

  7. #7
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47

    Re: Connecting Internal or as SYSDBA

    Originally posted by tlmason74
    Oracle Version 8.05 (Yuk, but what my company owns)
    Hi 8.05 is neither extint nor bad.As long as it server u'r business purpose it is good enough.

    anyway comming to u'r question.
    i understand that u need to make some changes in u'r parameter file.
    Create new pswd file with ur new pswd using ORAPWD utility.
    This should work.
    If u just want to shutdown the database in winnt u can stop the service make the necessacary changes and start the service.
    u can Also try the System/manager to get into the database(hope the default pwd for system is not changed).
    Cheers
    Murali

  8. #8
    Join Date
    May 2001
    Posts
    736

    Re: Re: Connecting Internal or as SYSDBA

    Originally posted by dasari98
    u can Also try the System/manager to get into the database(hope the default pwd for system is not changed).
    Without sysdba can he shutdown his database. which is what he wants.

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