Re: Problem authenticating OS user as DBA even after granting DBA role

Comments embedded.

rishib4u_at_gmail.com wrote:
> ok here are the facts straight & simple.
> 1. i have a group called ORA_DBA.
> 2. i have a standalone system as at home so i installed as the local
> Administrator.
> 3. the local Administrator was automatically under the ORA_DBA group.
> 4. i can connect as scott/tiger, system/manager,
sys/change_on_install,
> internal/oracle.
> BUT when i type in "/ as sydba" which should log me in cause my OS
> username is under the ORA_DBA
> group, it fails and gives the error Insufficient privileges Err. No.
> 1031.
>
> 5. i have got the solution in the reply from Sybrand Baker. i went
> through the checklist and checking if i had done whatever was told
> 'should be done before hunting for nonexisting problems' and finally
> came to the last item which dealt with the sqlnet.ora entry. this was
> the part i was unaware of and this did finally solve my problem.
>
> i am a novice user and am still learning and i am very thankful for
> your tips. but there are some queries that still arise although these
> are not related to my last query, but i hope things can become more
> clearer if i can have those doubts cleared.
> 1. why isn't the sqlnet.ora file not configured by the database
during
> the installation like the tnsnames.ora?

I have never seen it missing in a Windows installation, either on Windows 2000 or on Windows XP Pro, as the Net Configuration Assistant creates this file in its proper location. Possibly the Net Configuration Assistant failed and you did not notice it.

> why does it still reside in the Sample folder untill manually
altered?

> 2. before installing on win2000 i had tried the installation on
winXP,
> the database service starts nicely when the database is created but
> fails after a reboot. this could be solved by deleting the old
service
> and creating a new service with the same SID which starts fine, but
> that does not answer the cause.

Most likely the registry entries for the pfile location are missing or misconfigured. The default location searched for your parameter file (init<SID>.ora) is %ORACLE_HOME\dbs; the normal location DBCA puts your init<SID>.ora file is %ORACLE_BASE%\admin\<SID>\pfile, where <SID> is the ORACLE_SID value for your database. I choose to use an spfile; to create one is a simple matter of:

SQL> connect / as sysdba
Connected.
SQL> create spfile from pfile;

File created.

SQL> Once created you shouldn't have the problem during startup of Oracle not finding your pfile, which is probably the cause your instance did not start at boot. Of course, if the registry entry 'points' to the correct init<SID>.ora file such problems shouldn't exist.

> also in my case after the new sid is
> created while logging in it gives ORACLE not availabe while the
> database service & tnslistener service are already running. are these
> too, caused by misconfigured *.ora files?
>

No. This is caused by the instance not starting after the service started. ORADIM should be used to configure the service to automatically start both the service and the instance. Then follow the procedure listed above to eliminate any issues related to your init.ora file.

> help me clear those doubts,
> thankyou ,
> rishi.

David Fitzjarrell Received on Fri Mar 04 2005 - 13:20:30 CST