I have Oracle 8.1.7 installed on RedHat 7.2. I had Oracle running,
created a user, some tables, and was able to access it through some
perl scripts.
I was curious if I could have two database running at the same time so
I used dbassist and created another database.
Once this was created I tried to connect to the old database but I got
some connection problems. I ran ps -ef and found that my old database
processes were gone. So I went to SVRMGRL and shutdown the new
database, and tried to start the old one.
and got this error:
SVRMGR> startup
LRM-00109: could not open parameter file 'dbs/init%ORACLE_SID%.ora'
ORA-01078: failure in processing system parameters
I looked for the init file and the old one was gone so I copied the
new one and changed some parameters, and ran startup again.
it worked but i got another error:
SVRMGR> startup
ORACLE instance started.
ORA-01990: error opening password file 'dbs/orapw'
I then used the orapwd command and created a new password file.
and the database started up.
but when i logged in all my old settings and tables are no longer
there.