On May 11, 12:00 pm, jIM <noreplysoc..._at_hotmail.com> wrote:
> I am using some templates to create an oracle SID and schema using the
> windows DB config assistant. I have done similar things before... but
> am having problems right now.
>
> The error is "insufficient privlidges" (TNS error 01031).
>
> First time I was not logged in as Oracle trusted OS user. I reset the
> admin password (for Oracle trusted user), created a new SID to create
> new schema, and the same error came up.
>
> I have a DBA which worked me through similar issue before, he is
> unavailable right now.
>
> I have admin access to my machine
> The Oracle trusted user is a local account on same machine which I can
> get access to.
>
> When doing this, the configuration fails at around the 90% mark...
> meaning something might be up with the templates (who needs to own the
> templates in dbca/templates?).
Security issues aside, to make it easy, The user running the install
should be in the ORA_DBA local group and SQLNET.ORA should use NTS
authentication. If machine is truly hardened, you will have other
issues with file permissions. If so, run the install with the user
who has file level execute permissions and is also in the local
ORA_DBA group.
Received on Fri May 11 2007 - 13:23:05 CDT
