Connection to Oracle 8 personal Edition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Connection to Oracle 8 personal Edition

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi.. All

    I got a system with personal oracle Installed. I started the database.. Fine it started nicely. But, I couldn't connect to the database. I don't know the password.. How can i change the password of the user sys /sytem/internal or how can i connect?.. Can I create a password file? Any other method?

    Thanks
    Thomas

  2. #2
    Join Date
    Mar 2001
    Posts
    188
    How do you start the db ?
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Started From

    Started From "Start/Oracle Peronal 8/Start database" menus..

    it started directly..

    Thanks
    Thomas

  4. #4
    Join Date
    Mar 2001
    Posts
    188
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Hi

    Hi..

    Those threads talking about the Server Passwords... But I am working with a Peronal Edition ver. 8. can I use ORAPWD and SVRMGR with Personal Oracle ? I doubt it..? More over I can't find it here...

    Thanks


    Thomas

  6. #6
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    More Details

    Hi Tomate

    More Details

    Dump file C:\ORAWIN\RDBMS80\trace\orclALRT.LOG
    Tue Mar 13 14:59:11 2001
    ORACLE V8.0.4.0.0 - Production vsnsta=0
    vsnsql=c vsnxtr=3
    Windows 95 V4.10, OS V192.0, CPU type 586
    Starting up ORACLE RDBMS Version: 8.0.4.0.0.
    System parameters with non-default values:
    processes = 50

    shared_pool_size = 3500000

    disk_asynch_io = FALSE

    control_files = C:\ORAWIN\DATABASE\ctl1orcl.ora

    db_block_buffers = 200

    db_block_size = 2048

    log_buffer = 8192

    log_checkpoint_interval = 10000

    db_files = 1024

    db_file_multiblock_read_count= 8

    sequence_cache_entries = 10

    sequence_cache_hash_buckets= 10

    remote_login_passwordfile= SHARED

    global_names = TRUE

    db_name = oracle

    parallel_max_servers = 5

    background_dump_dest = %RDBMS80%\trace

    user_dump_dest = %RDBMS80%\trace

    max_dump_file_size = 10240

    Tue Mar 13 14:59:12 2001

    PMON started with pid=2
    Tue Mar 13 14:59:13 2001

    DBW0 started with pid=3
    Tue Mar 13 14:59:13 2001

    LGWR started with pid=4
    Tue Mar 13 14:59:14 2001

    CKPT started with pid=5
    Tue Mar 13 14:59:14 2001

    SMON started with pid=6
    Tue Mar 13 14:59:14 2001

    RECO started with pid=7
    Tue Mar 13 14:59:19 2001
    create controlfile reuse set database oracle
    datafile 'C:\ORAWIN\DATABASE\sys1orcl.ora',
    'C:\ORAWIN\DATABASE\tmp1orcl.ora',
    'C:\ORAWIN\DATABASE\rbs1orcl.ora',
    'C:\ORAWIN\DATABASE\usr1orcl.ora'
    logfile 'C:\ORAWIN\DATABASE\log1orcl.ora' size 200k,
    'C:\ORAWIN\DATABASE\log2orcl.ora' size 200k resetlogs
    Tue Mar 13 14:59:22 2001
    Successful mount of redo thread 1.
    Tue Mar 13 14:59:22 2001
    Completed: create controlfile reuse set database oracle
    dataf
    Tue Mar 13 14:59:22 2001
    alter database oracle open resetlogs
    RESETLOGS after incomplete recovery UNTIL CHANGE 14234
    Tue Mar 13 14:59:25 2001
    Thread 1 opened at log sequence 1
    Current log# 1 seq# 1 mem# 0: C:\ORAWIN\DATABASE\LOG2ORCL.ORA
    Successful open of redo thread 1.

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Net 8 is required..??

    To connect to Perosnal Oracle Net 8 is required? My database is in the Same System where i am working. OS is Windows 98.

    While I am getting a message:
    SQL*Plus: Release 8.0.6.0.0 - Production on Thu Jun 21 09:47:29 2001

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-12203: TNS:unable to connect to destination

    What colud be the reason..? Wher I have to look.. Please help..

    Thanks

    Thomas

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