DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: redo log alloaction problem urgent

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    btw I wonder how can we create a database if we cant logon as internal heh

  2. #12
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    connecting as internal generates a log file .aud ,so if your file system is full "forget connect as internal".
    P.s move your arch file from there.

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    that if you have audit trail on though?

  4. #14
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    yes! .......(is the default)

  5. #15
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    sorry ...
    audit_trail string NONE

  6. #16
    Join Date
    Jun 2000
    Posts
    104
    hi,
    I am working on oracle 8i i.e, 8.1.5.I am not being able to connect as internal after full db import.i don't know why it is giving the error message invalid username/pwd?any way out-
    and i am on NT.

  7. #17
    Join Date
    Sep 2000
    Posts
    78
    did u try the default password 'oracle' ?

  8. #18
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    create a new password file if password 'oracle' doesnt work and cross the fingers ;)

  9. #19
    Join Date
    Jun 2000
    Posts
    104
    how to create a new password file as oracle does not work,it is really confusing that on my test db I am being able to access user internal but not on real DB.

  10. #20
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    The real DB needs security and your test DB I dont think so.
    To create a new password file

    orapwd file=$ORACLE_HOME/database/pwdSID.ora password=any_thing_you_want entries=10

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