ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC

Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC Hi there, I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied the 9.2.0.3.0

ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC

Title: ORA-00600 signalled while mounting the database from the second instance of Oracle9i RAC Hi there, I have set up two-node Oracle9i RAC on Windows 2000 Advanced Server with OCFS (Oracle Clustered file system). The Oracle version is 9.2.0.1.0 and I have also applied the 9.2.0.3.0

SQL and PL/SQL tuning template document required urgently

suggest as to how to go about doing one? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

ORA-14403 error detected during bulk updates

appreciated. Thanks and Regards, Ranganath www.mailfiler.com [RK-K521CR3] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

How to invoke stored procedures from another instance?

Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options

RAC DBCA hangs while creating cluster database

Hi Listers, I am trying to set up a two-node RAC on Windows 2000 Advanced Server on Proliant DL 580 Servers. I am following the metalink document 178882.1 and Harrison B. Redhouses document DIY Multi-Node RAC on a single Windows PC downloaded from www.oaktable.net. I am having two

Slightly OT: Unable to recognize shared disk on Red Hat Linux AS 2.1

Hi listers, I am trying to setup Oracle9i RAC on RedHat Linux AS 2.1 on DL580 server. The storage system is MSA 1000 Controller with FCA2101 Fibre Channel Host Bus Adapter. I have installed dual operating systems viz; Windows 2000 Advanced Server and RedHat Linux AS 2.1. I am unable to

Clarification sought regarding configuring two-node Oracle9i RAC on RH Linux AS 2.1

Hi Listers, I am trying to configure a two-node Oracle9i RAC on Redhat Linux AS 2.1. I have 2 network cards in each node. Oracle doc. says that one of the network cards has to be on a public network and the other network card on a private network each configured with static ips. Does

Bug in Execute Immediate clause???

Hi Listers, The below procedure gets created successfully in TEST Schema. But when I execute the procedure by starting a fresh session connecting as TEST schema I get the below error and when I execute the procedure for the second time it executes successfully. I have granted the dba

Standard or Enterprise edition without installing Oracle9i software

Hi there, I have 3 CDs of Oracle9i database Release2 (9.2.0.1.0) for Linux Intel with part numbers as A99339-01, A99340-01 and A99341-01. I want to set up RAC on Linux machine. I believe RAC option only comes from Oracle9i Enterprise Edition CDs. Is it possible to know whether RAC

RE: Deleting Statspack tables.

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City

RE: How to select and display 10 records at a time from a table using sql query - Solved

or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

ora - 4031 while inserting into a parent table

://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

How to select and display 10 records at a time from a table using sql query

. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Spooling output of a select statement to a file through stored procedure

://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Running sql script from stored procedure

://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Not receiving messages from the list but able to send it

or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

No messages since yesterday evening

. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

stored procedure errors

system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET

Question on on delete cascade functionality

of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Trigger help

: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

How to find the size of all the tables under a particular schema using vsize

Dear DBA Gurus, I need to find the size of one row of all the tables under a particular schema using vsize clause. How do I do this? Please help. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL

How to find the table size?

a particular schema. How do I do this using Sql or Pl/Sql? Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

ora - 900 error while using copy command in a stored procedure

* from carrier'; execute immediate sql1; end; Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Ora - 1008 - Not all variables bound error

= + e.toString()); } } } -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to prevent oracle from committing a transaction?

help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

How to notify the firing a database trigger to the java application

will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: How to prevent oracle from committing a transaction - Solved

Hi DBA Gurus, The following soultion worked for me: Exit Rollback. My special thanks to Marco Rooy van and Ray O'Brien for providing the solution. Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED

How to pass the connect clause to connect as a database user in a stored procedure?

will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Error while executing stored procedure as system user

: at SYSTEM.CREATE_USER, line 4 ORA-06512: at line 1 What might be the reason for the errors? Can anyone help me? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Error while executing stored procedure as system user - Solved

; Thanks Amol Joshi for giving the suggestion to use auth_id current_user clause in the stored procedure code. Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Imedia query tuning

, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Imedia query tuning

11 sorts (memory) 1 sorts (disk) 552 rows processed TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

How to avoid sorting in the select statement?

: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Ora - 4091 error while trying to insert a record into a table

? Any help in this regard will be greatly appreciated. TIA and Warm Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Ora - 4091 error while trying to insert a record into a table - RESOLVED

-- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

ORA - 1008 error when trying to insert data into a table

(SQLException nExp) { throw new Exception(nExp.toString()); } } } Any help in this regard will be greatly appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K

Memory leak problem

as possible. TIA and Regards Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Conventions for naming indexes, constraints etc.

, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Conventions for naming indexes, constraints etc.

/gints/eng/naming_conventions.htm But this was not mentioned earlier because I created it some minutes ago ;) Gints Plivna "Ranganath K" ranganathk@subexTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Entity Relationship diagrams

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle Intermedia Search Query

then it is returning error ORA - 29902. How do I write the query in order to return the correct result? Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat

Intermedia text table design

and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to call a stored procedure from Java

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle Masters program

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

How to increase the number of inserts into a table to 2000 per second

into that table as we require to implement the same into our application. Any help in this regard will be higly appreciated. TIA and regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858