Re: Oracle 8i - Create database by non product owner (e.g. oracle)

From: Frankie Li <earthy_at_hkicable.com>
Date: 19 Jun 2002 17:58:43 -0700
Message-ID: <e3b3b67b.0206191658.325f0659@posting.google.com>

Imprecise <f_puhan_at_precise.com> wrote in message news:<f_puhan-D609A3.08184418062002_at_vienna7.his.com>...
> In article <e3b3b67b.0206180034.5a7bdb8f_at_posting.google.com>,
> earthy_at_hkicable.com (Frankie Li) wrote:
>
> There should have been additional errors reported. Do you have those as
> well?
>

Thank you so much for all you guys' advise.

Ah yeah, (sorry, I am really new to Oracle that even don't know where the logs are at first...) following error is prompted in the log:

ORA-01990: error opening password file
'/u01/app/oracle/product/8.1.7/dbs/orapw'

I have tried following some suggestions in this group that were posted before:

Add/Remove "remote_password_file = none" (or something similar) in init.ora;
Add/Remove SID environment variable in .profile;

But these doesn't help.

The file orapw is there, but orapw<sid> and init<sid>.ora do not exist.

Any hint on what I can try now please?

Earthy Received on Wed Jun 19 2002 - 19:58:43 CDT