-
Error message when starting up Oracle 11g database on Windows Server 2008 R2
I'm running Windows Server 2008 R2 and when I'm trying to startup Oracle 11g database, I keep getting this error: SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2180024 bytes Variable Size 1996491848 bytes Database Buffers 1191182336 bytes Redo Buffers...
Last updated: -
Data Transferring is Slow – from back end to front end
==> My System: Processer - Xeon 8 Cores @ 3.8GHz RAM - 20 GB Storage – 11 HDD SAN - RAID 5 configured I/O Rate – 260 MB/s Network – Cisco 1 Gbps Intranet Front End – Using C#.Net desktop Application, PL/SQL Developer (write PL/SQL) ==> Database: Oracle 11g (11.2.0.3) Standard Edition...
Last updated: -
Increase performance of SQL loader
Like to hear best practices to be followed to increase performance of SQL loader.
Last updated: -
Oracle TNS Listener Remote Poisoning
What is the fix on Oracle TNS Listener Remote Poisoning?
Last updated: -
Cannot create Oracle 11g database
SQL> @createdb.sql create database sam * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-01501: CREATE DATABASE failed ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 5 ORA-00604: error occurred at recursive SQL level 1 ORA-30012:...
Last updated: -
Export row of table and all its children in Oracle Database 11g
Is there a way in toad to export the row of a table and all of its children in Oracle Database 11g?
Last updated: -
How to sort a resultset from a ‘group by’ statement
I have written a query like this: select to_char(order_date,'mon-yyyy') "months", sum(nob) "number of bags" from p_in where order_date between '1-apr-11 and '31-mar-12' group by to_char(order_date,'mon-yyyy') The above query returns me a resultset which gives me number of bags sold in every month,...
Last updated: -
Problem connecting D2K 6i with database Oracle 11g
Steps to connect D2K 6i, with oracle database 11g.
Last updated: -
Oracle Report 6i and Oracle 11g database
I have oracle 6i report under oracle 9i database.Now database is upgraded from 9i to 11g. So if I try to compile a report 6i under oracle 11g database then which kind of error might raised?
Last updated: -
Oracle Enterprise Manager Console
Pls. can anyone help me with this error masage,whenever i try to start OracleDBConsole from the services. iam using oracle 11g database, windows 7 the error masage is "Oracle could not start OracleDBConsole on the local computer for more information review the Service Event Log. if this is a...
Last updated: -
please advise some tips about how to create and tune a good performance of xfs filesystem to work effeciently with oracle database? thanks, nltt
Last updated: -
Need to save dates in Oracle Forms 10g without modifying data values
I am trying to save date and time as entered by the users example: In the insert and update triggers of my block my statement is: :MAIN_BLOCK.USER_DATE := TO_DATE(TO_CHAR(:MAIN_BLOCK.USER_DATE,'DD-MON-YYYY')||' '||:MAIN_BLOCK.HOUR||':'||:MAIN_BLOCK.MIN||':00 '||:MAIN_BLOCK.MERIDIAN,'DD-MON-YYYY...
Last updated: -
Hi, I have installed Oracle 11g Database and installed Oracle Developer suite 10g .. Error - FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes. When I try to open Oracle form builder I am receiving...
Last updated: -
what is different from MSSQL, MYSQL and Oracle 11g?
what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?
Last updated: -
I want to conect oracle form 6i to oracle 10g data base
I want to connect Oracle form6i fmx to oracle 10g data base presently i am connecting at client side making shortcut in path i use to write :C:\orant\BIN\ifrun60.EXE c:\MS\FORMS\ERP_LOGIN erp_ss/ss@sdcl in this method End user is knowing User name and password and connecting string. Is there any...
Last updated: -
Oracle Database 11g SQL Fundamentals I exam prep
I will be appearing for OCA paper 1 exams in a couple of days, can anybody help me for the preparation.can u pass on any dummies u have or any url from where i can get useful material.
Last updated: -
ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?
Last updated: