Home » Infrastructure » Linux » Ora-01031: Insufficient Privileges during 10g installation
Ora-01031: Insufficient Privileges during 10g installation [message #99272] Fri, 14 January 2005 10:34 Go to next message
Daniel
Messages: 47
Registered: February 2000
Member
I have tried installing Oracle 10g on Suse 9.1 Professional several times. Although I have tried to carefully follow the instructions in the installation guide, I get the following error.

When the Database Configuration Assistant start during the initial installation, I receive the error -> Ora-01031: Insufficient Privileges.

I created the oinstall and dba group according to the installation guide and made oracle a member with oinstall being the primary group. I also ran -> chown -R oracle:oinstall -> on the Oracle_Base folder to which I want to install the software and oradata files. Similarly, I ran -> chmod -R 775 -> on that folder. During the install I ran the script -> oracle_base/oraInventory/orainstRoot.sh -> during the installation when prompted.

I would really appreciate any help that any of you could provide. Thank you so much in advance.

-Daniel
Re: Ora-01031: Insufficient Privileges during 10g installation [message #99275 is a reply to message #99272] Mon, 24 January 2005 02:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check your ENV

ORACLE_SID
ORACLE_BASE
ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin
Re: Ora-01031: Insufficient Privileges during 10g installation [message #99278 is a reply to message #99275] Thu, 27 January 2005 18:14 Go to previous messageGo to next message
Daniel
Messages: 47
Registered: February 2000
Member
Excellent! The PATH was not set correctly before I started the installation. It's working great now. Thanks!
Re: Ora-01031: Insufficient Privileges during grant select on sequence [message #110485 is a reply to message #99275] Tue, 08 March 2005 00:14 Go to previous messageGo to next message
ttphuong
Messages: 5
Registered: March 2005
Junior Member
hi,
I'm using my ID as dba to grant select on an owner.xyz_seq to a user
but i cannot, i got: ORA-01031: insufficient privileges mark on the sequence name (xyz_seq).
Please help.
Thanks
Re: Ora-01031: Insufficient Privileges during grant select on sequence [message #110533 is a reply to message #110485] Tue, 08 March 2005 08:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
works for me..

mag@mutation_mutation > create sequence myseq start with 1 increment by 1;

Sequence created.

mag@mutation_mutation > grant select on myseq to test;

Grant succeeded.

mag@mutation_mutation > connect test/test
Connected.
mag@mutation_mutation > select mag.myseq.nextval from dual;

1

mag@mutation_mutation > set head on;
mag@mutation_mutation > /

NEXTVAL
----------
2
How can we reset sequence # ? [message #110562 is a reply to message #99275] Tue, 08 March 2005 13:31 Go to previous messageGo to next message
ttphuong
Messages: 5
Registered: March 2005
Junior Member
During testing, sequence # is increaing, if i would like to reset the number of sequence back to the last one before i make that test, how can we do that?
Thanks
Re: Ora-01031: Insufficient Privileges during 10g installation [message #110566 is a reply to message #99272] Tue, 08 March 2005 13:55 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
--
-- Please refer DOCUMENTATION.
-- all info is available in docs.
mag@teng > create sequence mysequence start with 1 increment by 1;

Sequence created.

mag@teng > select mysequence.nextval from dual
2 ;

NEXTVAL
----------
1

mag@teng > /

NEXTVAL
----------
2

mag@teng > /

NEXTVAL
----------
3


mag@teng > alter sequence mysequence increment by -2;

Sequence altered.

mag@teng > select mysequence.nextval from dual;

NEXTVAL
----------
1
Previous Topic: Installing Oracle 10g in Suse Linux 9.1
Next Topic: Oracle 9i R-2 Installation on Red Hat Linux AS 3
Goto Forum:
  


Current Time: Thu Mar 28 07:28:31 CDT 2024