Connection to Oracle 8 personal Edition

[Thomasps]

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

[tomate]

How do you start the db ?

[Thomasps]

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

it started directly..

Thanks
Thomas

[tomate]

look here

http://www.dbasupport.com/forums/sho...threadid=12183

or

http://www.dbasupport.com/forums/sho...threadid=11604

[Thomasps]

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

[Thomasps]

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.

[Thomasps]

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