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?).
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
jIM schreef:
> 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?).
Owner? Is this some *ix platform?
Post platform and environment variables
- --
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD8DBQFGRKwhnJJX6RwZIDkRAs0kAKDbxf5HqpW8CIx8wgEP1VUc38KEpwCeN2su
/TFVO9R3S/kfJfNrA+Bpj/w=
=AuW1
-----END PGP SIGNATURE-----
-----------------------------------------------Reply-----------------------------------------------
On May 11, 12:00 pm, jIM <noreplysoc
@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.