DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Loging to Oracle 9i

  1. 03-07-2006, 12:31 PM #1
    fredy
    fredy is offline Junior Member
    Join Date
    Sep 2004
    Location
    kenya
    Posts
    8

    Cool Loging to Oracle 9i

    Someone to help me here. I have install Oracle 9i. Like in Oracle 8 I used to log to Sql*plus with username :scott and password :tigger. What do we used in 9i since the same was not taking me to SQL>.
    thank in advance
    Reply With Quote Reply With Quote
  2. 03-07-2006, 04:27 PM #2
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool



    scott/tiger is 8i version, in 9i version you have different schemas ('HR', 'OE', 'SH' and 'PM') which you install when creating the database with dbca or manually executing the scripts in:
    ?\demo\schema directory.

    Anyway you will need the system password (which is set when creating db with dbca) in order to execute these scripts.

    Or try: SYSTEM/CHANGE_ON_INSTALL


    Last edited by LKBrwn_DBA; 03-07-2006 at 06:31 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  3. 03-07-2006, 09:16 PM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by LKBrwn_DBA

    Or try: SYSTEM/CHANGE_ON_INSTALL
    Do you mean sys/change_on_install, or system/manager????
    Reply With Quote Reply With Quote
  4. 03-08-2006, 11:46 AM #4
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool



    Whatever works.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    Reply With Quote Reply With Quote
  5. 03-13-2006, 12:41 PM #5
    fredy
    fredy is offline Junior Member
    Join Date
    Sep 2004
    Location
    kenya
    Posts
    8
    Thanks all you guys! Your the smart one he!
    Reply With Quote Reply With Quote
  6. 03-13-2006, 12:41 PM #6
    fredy
    fredy is offline Junior Member
    Join Date
    Sep 2004
    Location
    kenya
    Posts
    8
    Thanks all of you guys! Your the smart ones hee!
    Reply With Quote Reply With Quote
  7. 03-14-2006, 11:51 AM #7
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    You are wellcome.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
    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