Oracle Error Messages

how can i resolve oracle error 00103

I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE...

ORA-01591

lock held by in-doubt distributed transaction iam running oracle9i relase 6.I get the following error

TNS-03505: Failed to resolve name

HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve name my listerner.ora file is LISTENER= (DESCRIPTION_LIST = ...

Update deactiviting and throwing ora-600 error

ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :A4

data from oracle 10g to oracle 8i

Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object

Moving Oracle from one windows domain to another

We are using Oracle 9 running on Windows 2003 R2. We moved the server into a different domain which is also within an AD environment. We then received the following error codes. RdConnection: Error # -2147467259 OpenConnection Description ORA-01034 ORACLE not available ORA-27101 When we...

ORA-1034: Oracle is not available error with SQL Plus

I had installed Oracle 9i in Windows XP Professional Edition. Whenever I start SQL plus(GUI) it says, ORA-1034 error, "Oracle is not available, Shared memory realm does not exist" In the services I saw that an associate database service is running. Thank you.

ORA-01925: maximum of 145 enabled roles exceeded

I’m getting ORA-01925: maximum of 145 enabled roles exceeded and I can't change the max_enabled_role. I dropped some roles but still face the same issue. Not able to login as system. Please suggest. Thanks.

Need help with CORBA object error in Oracle Management Server

When I am in OMS, and try to shut the DB down, I receive a CORBA Object_not_found error. Does this mean that I have not installed the CORBA objects correctly?

Oracle -fetched column value truncated error

Hi I am using ASP.net using C# in my application which connects to Oracle 9i DB with a UTF8 character set. On of my columns in a table has datatype Nvarchar2(4000), when I try to fetch data through a Stored proecedure using execute Dataset command in C# it throws error "ORA 01406 -fetched column...

What's the best way to import an Oracle database?

I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each...

calling reports

i am trying to call oracle 9i report through 9i forms but getting the error: REP-0503 YOU DID NOT SPECIFY THE NAME OF THE REPORT please help me and tell me the complete steps of calling the report through forms

Calling a report from form

Hello all We recently have migrated from oracle 6i to 9i DS. We have some forms which are calling a report. I have used the run_report_object() instead of run_product() in 9i. Previously the forms were displaying the reports properly. But I have re-installed the windows and oracle due to some...

oar-01033

ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I've tried several different usernames...but SYS should work as i've used this many many times in the past "as...

Calling a report from a form

Hello experts I hope you all are fine & enjoying good health. I am facing a problem after migration from oracle 6i to oracle 9i, I wonder if someone can help me in calling a report from a form. I have used RUN_REPORT_OBJECT instead of RUN_PRODUCT but I am getting error FRM-41214 unable to run...

trying to install oracle 10g

I'M TRYING TO INSTALL ORACLE 1OG ON AN ACER 5520-5334 COMPUTER AND IT HAS BEEN GIVING ME A PARTICULAR ERROR 'NO VALID DEVICES FOUND ....... etc. from my research it seemed like the versions of red hat os ( rhel 3.0,4.0) were not compatible with my computer. pls can any one give me advice on what...

What is the PRAGMA_INIT exception?

What is the PRAGMA_INIT exception? Thank you.

Hyperion 9.2 Schedule Error

As soon as we tried to click 'when to run' on workspace, a listing of error msgs appeared on the screen. Eg. An exception was thrown: null... With the following stack trace....

Oracle 6i problem in deploying forms

Hi, i am new to oracle. i have Forms in oracle 6i that i want to deployed on a web server. i have the option of Program->Run Form -> Web but this is giving the FRM-99999: Error 18121. on checking the release notes and implementing the IView interface its not working. Please, help to solve...

oracle apps error

hi all i hope you can help me i'am trying to install apps on winxp sp2 on 97 giga pariation but i have this strange error i install mks tool kit and visual c++ v6 and no space on the names of folder i have this error RW-20012: Error: - Free disk space on system returns zero: probable cause - mount...