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

Thread: Internal

  1. 06-10-2002, 02:31 AM #1
    tanaka
    tanaka is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 06-10-2002, 02:45 AM #2
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    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

    Reply With Quote Reply With Quote
  3. 06-10-2002, 02:51 AM #3
    tanaka
    tanaka is offline Junior Member
    Join Date
    Apr 2002
    Posts
    55
    Hi,

    This is also giving the same error.

    Thanks.
    Reply With Quote Reply With Quote
  4. 06-10-2002, 04:25 AM #4
    tanaka
    tanaka is offline Junior Member
    Join Date
    Apr 2002
    Posts
    55

    any replies ??

    any replies , I cannot shutdown my database as I cannot connect as Internal.
    Reply With Quote Reply With Quote
  5. 06-10-2002, 04:36 AM #5
    anujdutt
    anujdutt is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  6. 06-10-2002, 04:38 AM #6
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  7. 06-10-2002, 04:38 AM #7
    tanaka
    tanaka is offline Junior Member
    Join Date
    Apr 2002
    Posts
    55
    Hi ,

    I was able to connect as sys/***** as sysdba but not as Internal.Causes ?
    Reply With Quote Reply With Quote
  8. 06-10-2002, 11:26 AM #8
    jrpm
    jrpm is offline Senior Member
    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'
    Reply With Quote Reply With Quote
  9. 06-10-2002, 01:23 PM #9
    julian
    julian is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  10. 04-10-2003, 03:54 PM #10
    dmkih
    dmkih is offline Junior Member
    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?
    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