 | |
| ORA-01031 | | ORA-01031: | insufficient privileges | | Cause: | An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login. | | Action: | Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label. |
|
|
| Posts about ORA-01031 | | Hello everyone
I use Oracle 10g R2 on Fedora Core 4 and I use password file.
The value of "os_authent_prefix " is "ops$ " (default) and the os user that
I 'm able to login with it as sysdba using osWhy would I get ora-01031 on "create sequence pump_id_seq minvalue 10000
nocache " as the schema owner which I verified has the DBA role and
(implicit?) create any sequence system privilege? I alsoHello
I 'm trying to refresh materialized view (Oracle 9i) and I have error
that some privileges are needed but I don 't have idea what more can be
needed
I 'm trying to execute from User2Hello
I have installed
SLES9+SP3
orarun 1.8 109.5 (also testet 1.8 109.16)
Oarcle 10.2.0.2
When I use /etc/init.d/oracle start the instance will not start
with following error.
/opt/oracle/ora10r2/Hi
I am trying to create view and getting following error
SQL > create or replace view stats
2 as select 'STAT... ' || a.name name b.value
3 from v$statname a v$mystat b
4 where <html > <div style 'background-color ' > <P >All </P >
<P >After installing Oracle 9IR2 on RH Linux 8.0 while trying to access SQLPLUS as SYS user <BR >we 're getting error ORA-01031 insufficient privileges.&I 've run into a real problem here... not sure how to solve it.
I have Oracle 10G installed and up to today running fine on SUSE9.3. I
had to do a system restart this morning... when it all came bacHi Deepak
Here I am sending you some excercise go thru from this.. hope that will solve you issue -
This error usually comes when you have different password for user
sys and password file.
egDBAs...
Sorry if this is a silly question my brain is not
thinking clearly today...
1.- UserA gives SELECT privileges on his tables to
UserB trough a role RoleA.
2.- UserB creates ViewA querying Am I missing something? How does someone with select any dictionary get to see
the link passwords?
SQL > create user user1 identified by asdf_1234
User created.
SQL > grant select any dictionaHello Carel-Jan
I am always reading with a great pleasure your postings ).
I have tried to keep the configuration as symmetric as possible.
"stby " ist the name of the connectString for the staHello listers
I am trying to build a standby database (for learning purposes) with RMAN.
The problem is when I try to connect to the standy instance (which is in NOMOUNT status)
I am alwaysHello
my config
SunFire V20z AMD64
SLES9 + SP1 x86_64 (and all SuSE Updates)
10g (10.0.1.3)
orarun-1.8-109.5
new installation (less problems with the LD_ASSUME_KERNEL)
With dbca I hI guess we have to fix orarun to solve this problem. Any other glitch?
Thanks
Arun
> > > "Robert Scheckle " <RobertS@(protected) > 1/26/2005 9 46 38 PM > > >
I have always created the Oracle user wiHello there
I have installed oracle9 on sles9. it is configured I have got a database
instance. But and here is my problem
I cannot connect with sqlplus "/ as sysdba "
I get the error
ERROHi
I am not able to set Remote_login_passwordfile none.
sqlplus "/@(protected) as sysdba " is not working and fails with ORA-01031
insufficient privileges. Presently Remote_login_passwordfile SHARED.
Lisa
I 'm sure they really meant "our guru " but just stated it in the context
of Windows so you misunderstood.
Dennis Williams
DBA
Lifetouch Inc.
"We all want progress but if you 're on Hi
I have successfully installed so many times Oracle 9i on SLES8. But
today I am trying to install on a HCL Infinity PC where SLES8 is not
detecting the network card. I have proceeded on instaVery odd... That 's not what I see on my 9i box. Though I do have a
different patchset than you.
Connected to
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning OIF you are on a UNIX version then when you set your Oracle environment do
you set the TWO_TASK variable? If so unset TWO_TASK prior to attempting to
create a sysdba session via sqlplus /nolog. Hav
On 05/12/2004 09 10 26 PM Stephane Faroult wrote
> Sorry to have to say that but you need to give a look to your beloved
> manuals yourself. There is a difference between the current user whoWhat Oracle version?
What platform (OS)?
What database authentification model are you using?
What Oracle error are you getting?
If you are on UNIX and use OS authentification then if someone setHi!
I am experiencing something weird here... I am the user L2930 (with DBA
role).
When I issue a select statement to select data from another user 's table it
works fine
SQL > select countHi all
I have a 9.2.0.4 database on Solaris 2.9 that is being very unhappy with remote connections as sysdba. The owner of the process (sqlplus for testing but IA also as I am ultimately trying toDaniel
PL/SQL does not require direct granting stored objects including
views do. An anonymous block using privileges granted via a role will
work
oet@(protected) > select * from user_sys_privs Hi Alan
Please check that your oracle-user belongs to group dba.
Harald
-----Urspr?ngliche Nachricht-----
Von Alan Civita [mailto a.civita@(protected)]
Gesendet Dienstag 3. Februar 2004 11 4 this is excatly what i 've done but the instance is called orcl. this was
running on the server. from client it works fine
linuxone /opt/oracle/product/9ir2/dbs # orapwd
file $ORACLE_HOME/dbs/o |
|
| Oracle Database Server Error Codes | |
|