-
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
-
How do you start the db ?
-
Started From
Started From "Start/Oracle Peronal 8/Start database" menus..
it started directly..
Thanks
Thomas
-
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|