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

Thread: Internal

  1. #1
    Join Date
    Apr 2002
    Posts
    55
    Hi,

    Oracle 8.1.7/Win 2000

    I am facing a strange problem.I logged into my DB with Internal/Oracle from SVRMGRL.Then I performed certain activities like exp,imp,view creation,etc from other users.Now when again I want to connect as Internal its gving error that
    ORA-01017: invalid username/password; logon denied. Can anyone help.I am unable to shutdown my Database.

    Thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello;
    Try to connect with : sys/oracle as sysdba
    this is a second form of connecting as internal

    Orca


  3. #3
    Join Date
    Apr 2002
    Posts
    55
    Hi,

    This is also giving the same error.

    Thanks.

  4. #4
    Join Date
    Apr 2002
    Posts
    55

    any replies ??

    any replies , I cannot shutdown my database as I cannot connect as Internal.

  5. #5
    Join Date
    Dec 2001
    Location
    Edmonton, Canada
    Posts
    50
    Create new password file using the ORAPW utility and use new password top do connect internal
    An elephant is a mouse with an operating system.

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi

    Is the win2000 user a member of the ORA_DBA group? if not you will have to give the password specified in the password file.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  7. #7
    Join Date
    Apr 2002
    Posts
    55
    Hi ,

    I was able to connect as sys/***** as sysdba but not as Internal.Causes ?

  8. #8
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    If you can connect as SYS, you should not have a problem shutting down your database (all internal does is connect as sys.)

    You do have to look at either rebuilding your password file or checking your host id group against the Oracle id group. This situation could happen if the id you are using is not or no longer a member of the SYSDBA group.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jrpm
    all internal does is connect as sys

    CONNECT INTERNAL is same as CONNECT / AS SYSDBA

    CONNECT SYS/password is not same as CONNECT / AS SYSDBA
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    Apr 2003
    Posts
    2
    I have LInux RH AS 2.1 and Oracle9i2

    I can do >connect sys/... as sysdba
    I can not do >connect / as sysdba
    returns ERROR: ORA-01031: unsufficient privileges

    Because of this problem I can not use dbstart dbstop scripts.
    I do not want to modify them to print sys password inside.
    I onle can start database manually from sys user.

    I found on internet some information:
    http://www.geocrawler.com/archives/3.../10/0/6954364/

    I checked SYSDBA users on my installation:
    select * from v$pwfile_users;

    This is what expected:
    USERNAME SYSDBA SYSOPER
    ------------------------- ------ -------
    INTERNAL TRUE TRUE
    SYS TRUE TRUE

    This is what I have:
    USERNAME SYSDBA SYSOPER
    ------------------------- ------ -------
    SYS TRUE TRUE

    Can somebody give me clue why I do not have INTERNAL user?

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