Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031: insufficient privileges While trying / as sysdba

534640Apr 9 2008 — edited Aug 13 2013
Hi All,
We have oracle database 10.2.0.3 on Linux x86 32 bit Server.

We are trying to connect our database with sysdba and getting [ORA-01031: insufficient privileges ] error.

I have recreated the password file:
orapwd file=orapwdPRODT password=mypassword

But still we are unable to login
-------------------------------------------------------------------------
sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:22:27 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
[oracle@dev1 PRODT_dev1]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:33:30 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
Please note that we are able to login if we supply exact password which is in password file. But / as sysdba command is giving above errors.

My sqlnet.ora file is having entries:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

I have also tried by removing this line but same error exist.

MY initPRODT.ora file is having this entry:

remote_login_passwordfile='EXCLUSIVE'

I have searched through metalink and google and normally this kind of errors resolved by recreating the password file. I have tried these solutions but unable to resolve this issue.

I have also followed Note:435947.1 and tried to relink the config files but again same problem exist.

Can any one help me in this regard???

Comments

fac586
I would also like for the region title of certain regions to be dynamic, or rather equaling the value of some item on the page. I did some digging on Google and found that this was apparently possible in Apex 3, but I'm currently working in Apex 4.
What makes you think that these methods don't work in APEX 4.0? Did you try them?

Use the static text exact substitution method to reference the value of the page item in the region title attribute: 
&P1_TITLE.
Ensure the page item value is set before the titled region is rendered (e.g. using a Before Header Computation).
2 people found this helpful
860960
I tried this in Application Express 4.0.2.00.07 and it works
Chandran
Could you please give a sample code
Jozef Demovic SVK
Hi,
Here is the example.

Type something like: "Order &P4_ORDER_NR." to the TITLE of the region.
- if item P4_ORDER_NR has value of 01/2012 then the Region Title will be "Order 01/2012".

Regards
J :D
917318
jozef_SVK wrote:
Hi,
Here is the example.

Type something like: "Order &P4_ORDER_NR." to the TITLE of the region.
- if item P4_ORDER_NR has value of 01/2012 then the Region Title will be "Order 01/2012".

Regards
J :D
Hi,

I've tried to handle item value. and I got a problem.

If I use Region Title: Role Description: &P4_POSITION_ID. - it shows : Role Description: 2
but when I inserted Region Title: Role Description: &P4_POSITION. it shows only Role Description:.

where P4_POSITION_ID - is Database column with source Position_ID
while P4_POSITION - is SQL query with source select e.POSITION_NAME from POSITION e where e.POSITION_ID = :P4_POSITION_ID

As I understand problem is when page is loaded P4_POSITION_ID item handle value, but P4_POSITION is empty.
but how to solve it?
Deep_in_Texas
When does the following code executes on your page?

while P4_POSITION - is SQL query with source select e.POSITION_NAME from POSITION e where e.POSITION_ID = :P4_POSITION_ID

Thanks
Pradeep

(I changed my handle but it's still displaying the number !!!!)

Edited by: 965010 on Oct 12, 2012 7:31 AM
917318
Deep_in_Texas wrote:
When does the following code executes on your page?

while P4_POSITION - is SQL query with source select e.POSITION_NAME from POSITION e where e.POSITION_ID = :P4_POSITION_ID

Thanks
Pradeep

(I changed my handle but it's still displaying the number !!!!)

Edited by: 965010 on Oct 12, 2012 7:31 AM
I don't know when it is executed. I've just created page item P4_POSITION and made it as SQL query.

Actually, value in the P4_POSITION_ID item is from POSITION_ID in EMPLOYEE table, which contains primary key EMPLOYEE_ID and has foreign key - POSITION_ID,
POSITION_ID is a primary key of POSITION table, which contains POSITION_NAME.

What I made is I created link from page 3 using EMPLOYEE_ID to redirect to page 4. There are all items in the page 4, which are in the EMPLOYEE table. But I need to show POSITION_NAME from POSITION table. So I created page item P4_POSITION as I mentioned before.

Do I need to create dinamic action or process before handling Region title?
1030438

The value for the item you wish to include in the title must be set at "Before Header" execution point (or earlier). If you're using an automated row fetch, I think you can simply move the row fetch process to the "Before Header" execution point.

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 10 2013
Added on Apr 9 2008
#database, #dba, #general-database-discussions, #installation
26 comments
265,978 views