Hi dear,

I am receiving given error and don't have the knowledge of given terms such as ASMSNM, ASM.

Please describe these terms and give me an answer on the error, in a simple way so that I can understand all steps easily.

Details of Error:

Database Configuration Assistant

Could not validate ASMSNMP Password due to following an error – “ORA-01031: insufficient privileges

Do you want to continue?

If you continue, ASM will not be configured to be monitored by Database Control.

Retry Continue

Hi Dear

I am facing this error, in installation process of Oracle Database 11g.

Please tell me why this error appears.

Details of Error:

Oracle Database 11g Release 2 Installer

Error in invoking target ‘client_sharedlib’ of makefile

‘/u01/app/oracle/product/11.0.2/rdbms/lib/ins_rdbms.mk’. See

‘/u01/oralventory/logs/installActions2011-07-07_01-17-21PM.log’ for details.

Abort    Retry    Continue

Regards.

Hi dear,

I am receiving this error. Please provide me its solution. How can I remove this error.

Details of Error:

Error in invoking target install of makefile/user/ora9/product/9.2/network/lib/ins_oemagent.

Mk

Press ‘Help’ for more information.

Press ‘Retry’ to try again.

Press ‘ignore’ to ignore this error and go on.

Press ‘Cancel’ to stop this installation

I want to take only the date part of passed date time string.

Example:

If I pass '8/16/2011 12:47:01.698187 AM -4.00 AM' . I only require '8/16/2011' from the following query:

select trunc(''8/16/2011 12:47:01.698187 AM -4.00 AM') from dual;

But it is throwing an error: ORA 01722- invalid number .

Can you please correct the query?

Hi,

I am writing one query:

select  * from user where logged_in_time='15aug2011 00:00:00' ;

as logged_in_time is a timestamp field and I want to list out all the users who logged in at this time.But it is not displaying any output, whereas if I write:

select * from user;

and try to find it manually, rows are present with this logged_in_time. Please help.

Regards,

Jake.

I have oracle 9i DB installed, is it possible to make a batch file scripts utility which first creates a user then imports dump file and then gives grants. With the help of this utility it is possible to switch within no time from primary db server to secondary server within no time. This utility can be helpful in such DB server environment which has got a backup or secondary server .

Awaiting your response,
Yousaf.

In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Hello Friend,

Hi there, when I tried to use some third party software or Oracle Form Builder, I encountered with this error of ‘ORA-12524’.

Some database parameters were modified e.g. max_parallel_server but the error continued to appear. 

Also, the server was trying to restart. 

The error disappeared and reappeared one day later.

Any one help me to solve this issue?

Thanks in advance.