• Updating Microsoft SQL Server tables from Oracle generates error

    i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

    Balecha10 pointsBadges:

    I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in it, but returns...

    Papalpha5 pointsBadges:
  • Oracle initialization error while running Java files

    I am facing no issues while compiling the java file. However while running the same, I am facing the following error. java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress. Any pointers for the same?

    JagdishK5 pointsBadges:
  • ORA-12560: TNS:protocol adapter error

    I recently downloaded Oracle Designer from oracle website. When I use the default username and password, it give me the following error ORA-12560: TNS:protocol adapter error RME-00220: Failed to connect to Repository What should I do to solve this problem

    Develolper5 pointsBadges:
  • Resetting the database

    I received the following error:RMAN-20042: invalid tablespace creation change# when i dried reseting the database after doing a restore from an Rman backup. I tried to unregister the database than register it back in rman but the problem still exist and getting the following even when i try to...

    Oradbsm5 pointsBadges:
  • how can i resolve oracle error 00103


    150919745 pointsBadges:
  • how can i update ?

    when update in form (master_details) in details block i found error frm-40735 when button pressed trigger raised unhandled exception ora-00001

    Camba5 pointsBadges:
  • 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.

    OracleATE190 pointsBadges:
  • Error(55,8): PLS-00103: Encountered the symbol “C1” when expecting one of the following: := . ( @ % ;

    Hi All, I get the following error on compiling my stored procedure code - ****************************************************************************** Error(55,8): PLS-00103: Encountered the symbol "C1" when expecting one of the following: := . ( @ % ;...

    Ravipatil200815 pointsBadges:
  • Oracle Project Costing – GL date error

    In the process 'Transfer labor cost to GL', got error-msg - "could not create valid GL date"; however GL period is OPEN in GL module and also in the Projects module.

    PMkj5 pointsBadges:
  • 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...

    OracleATE190 pointsBadges:
  • 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.

    OracleATE190 pointsBadges:
  • report server error using oracle 10g

    Hi. I an using oracle 10g. when i run 10g reports individually it works fine but when i try it to connect with forms it gives error 'cannot connect toserver' please help how could i connect it to server.

    Raza15 pointsBadges:
  • Oracle App Server webcache and mod_gzip

    Hi all, I am struggling since last few days to work these both together.Problem is: The web cache is compressing the content but i don't want it to compress, i want the compression from server through mod_gzip. Even if i m disabling compression in webcache settings, its not working. In mod_gzip log...

    Mthakur5 pointsBadges:
  • ORA-12801 and ORA-01008 when running Oracle Reports

    When I run the report from report builder I get following error ORA-12801: error signaled in parallel query server P001, instance db12:testdb(2) ORA-01008: Not all variables bound Any idea what could be the problem? Database is Oracle 10g.

    OracleATE190 pointsBadges:
  • 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 = (DESCRIPTION =...

    Oda5 pointsBadges:
  • ORA-01591

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

    Kondaskar5 pointsBadges:
  • 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

    17383110 pointsBadges:
  • 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

    Skarthik35 pointsBadges:
  • 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...

    Xxxxxxxxxxxxxx5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.