I am working with a developer who is creating web pages for our website using javascript running on an Apache server. I manage the Oracle database and tables. I have just become aware of the...
When i am trying to connect to the Oracle Database i am getting this error.
Failure-ORA-00257:archiver error. Connect internally only, until freed.
Please suggest
Hi, I have a fairly large SQL query which retrieves data from very large data tables. I have looked at the explain plan generated and find that the optimizer is executing the code in a complet...
I have multiple "producer" (java application) that is producing jobs for multiple consumers (also java application).
I am thinking of using an Oracle database table to act as a job queue. S...
Guys
I have a 2 node RAC Cluster 10g with ASM I want to do a COLD backup of the database.
Now I am able to use ftp to connect to the ASM instance which would give me access to the datafi...
Guys
I use oracle oem 10g I would like to use the metallink link to get the patches from oracle but everytime I run this I get the following error but I am nit sure how to move on
Updating...
I have an Oracle 10g database for which OEM (and SQL Plus) are reporting seemingly incorrect space information about the flash recovery area. This ocurred after I had an issue with excessive ...
Hi.
Would you please give me a workbale sample of the function which can simulate crosstab (pivot).
I need to send two parameters (group_id, type_id) to this function from the view and t...
I have little batch file that reads the files in a folder and loads them into oracle table using a static ctl file. But I have field that stores the name of the data file from which it was lo...
We have several databases all oracle 8i
All our oracle 8i databases are on 2 windows 2000 machines
We are using 8I OEM NAMES DATABASE.
Our goal is to migrate all oracle databases one OR ...
I have a server with 10g running on it and i have a virtual volume attched to it and i can read right to this volume that is on a 3PAR san , I have a drive letter agginged to it, I want to ei...
When I set up in Microsoft Visual Studio to connect Oracle server.
Provider: Native OLE DB\Microsoft OLE DB Provider for Oracle
Server name: xxxx -- Is it the host name? Is it the instance...
We are having an issue with an account on our system. The user in question is unable to get ODBC connections to work for them on any of the 3 servers that we have tried. All of the other acc...
folks
how do i export a table content in oracle into a batch xml format?
all help will do
r
hello,
I am getting an "Attempted to read or write protected memory" error associated with creating a new OracleConnection. It only happens on one test computer, 2 other test computers make ...
Currently running Oracle 10g R2 on Red Hat Enterprise Linux 4. Am in process of cleaning up security. For unknown reasons, multiple table owners within several Oracle Sids were granted the D...
Guys
I am in a pickle I need to copy a RAC ASM oracle 10g database from a linux box to a different linux server.
I have been advised that the simpliest method is to shutdown the database...
Hello,
I have a table in Oracle 10g with its name starting with an underscore(_). When I execute a select query on the table such as
SELECT * FROM _TABLENAME;
I get the following erro...
Hi all,
I am upgrade Oracle from Oracle 8i to Oracle 10g. I have successfully installed Oracle 10G on a new Linux Server machine and able to create multiple databases. I am now trying to ...
Hi,
What does the OracleDBConsole<sid> process do? Is it critical for a .NET client to access the database?
Thanks!
I'm Using local naming (TNSNAMES.ORA file):
"TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)
TNSNAMES.ORA file exist...
Hi,
I am trying to insert an XML document that has a node over 64K in size. I get the ORA-31167 error indicating that XML nodes over 64K in size cannot be inserted. Is this a limitati...
I use Oracle Colalboration Suite and When I upload any file or to create any folder on Content Service, an error occurs on Content Service
2008/06/16 10:29:58 [oracle.ifs.ecm.agents.MostRec...
Experts,
i have to move control files from one location to another location. for this i am following this method.
1) shut down the database.
2) move control file to other location.
3) ...
folks,how can i use oracle to define a carriage return of a date field
my field is reportdate 13-06-2008 14:25:02 and i want the field to display
reportdate
13-06-2008
14:25:02
i...
