Oracle Error Messages

ORA-27101: Shared memory realm does not exist

ora-27101:shared memory realm does not exist

Forms not connecting to upgraded Oracle 8.1.7 database to Oracle 10g R1

i have upgraded my oraCLE 8i database to 10R1 and am trying to connect my oracle 6i froms to it. After doing the connection when i try to log into the application it tells me that the password and the user name is incorrect. i have tried with a different user details but its not working. what...

rep-002

I am getting error "rep-002:Unable to retrieve a string from the report builder message file " while opening a existing report in Reports 9i...How to solve this?

ORA-00600

What is the solution to this ORA-00600:internal error code, arguements: [kksfbc_reparse_infinite_loop],[],[],[],[],[],[],[]

rep-51002

hello i have problem when i need to run the report 10g via form builder 10g by using web.show_document ,the error rep-51002 appear how can i solve that please where i am using oracle database 10g and oracle developer suite 10g on the same pc under windows .. thanks

ORA-00257

What's the quickest way to resolve an ORA-00257 error? What are some ways to prevent this from happening?

Oracle, MySQL connectivity by HSODBC

Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both...

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.

NUMBER IN A LIST

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...

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?

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

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...

Error when translating execute immediate from Oracle to SQL

SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* ...

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: := . ( @ % ; ...

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.

Link Oracle 10g with Sql server problem

i have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) as...

Oracle coding error ORA-06550

Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise...

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...

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.

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.