Re: Two Oracle admin questions.

I had the same problem when I installed my 805. I had to create a soft link between $ORACLE_HOME/dbs and $PFILE_HOME.

You will find this in your Administrator's Reference in page 1-18.

In article <8fro77$9o8$1_at_nnrp1.deja.com>,   buckeye714_at_my-deja.com wrote:
> I am not sure about Number 1, but I think you have to explicitly set
> tablespace privileges, though I could be wrong.
>
> As for Number 2, Oracle looks for the initsid.ora file in the
> $ORACLE_HOME/dbs directory. For administrative purposes, I keep the
> actual initsid.ora file elsewhere. I create a softlink in the
> $ORACLE_HOME/dbs directory to point to the file.
>
> HTH,
> Patrick
>
> In article <8frnjm$910$1_at_nnrp1.deja.com>,
> alan_psb_at_yahoo.com wrote:
> > Hello all,
> >
> > I have two questions: (Oracle 8.0.5 on Solaris)
> >
> > 1) I got error message when I created a table:
> >
> > ORA-01950: no privileges on tablespaces 'USERS';
> >
> > However, when I type "select * from user_role_privs", I see that
 I
> > have the RESOURCE and CONNECT role.
> >
> > I through with RESOURCE role, I have the unlimited quota on all
> > tablespaces. Why I cannot create objects on tablespace 'USERS'
> > (tablespace USERS has free spaces)? And what can I do such that I
 can
> > create objects on tablespace 'USERS'?
> >
> > 2) When I type "startup" in svrmgrl, Oracle cannot find the
 initsid.ora
> > file. I can only startup the Oracle instance by specify the path of
 the
> > initsid.ora (startup mount pfile=...). What can I do such that I
 don't
> > need to specify the path of the initsid.ora to start the instance?
 (I
> > have already set the ORACLE_SID variable before using svrmgrl).
> >
> > Thanks,
> > Alan
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 16 2000 - 00:00:00 CDT