Hi - Ive installed Oracle 11g server in Vista with advanced installation method chosen. Everything works fine. But when I try accessing EM in IE 7, I get certificate error. Though I can igno...
What would the best character set be for a new data warehouse in Oracle 11G.
The considerations are:
-Application supported charactersets (for example Cognos, Business Objects will report ...
Is it possible to copy statistics between tables, specifically large partitioned tables?
We are using Oracle 10g (10.2.0.4.0) which has much of the functionality included in the first relea...
create table works_on
(
essn varchar(20),
pno number(10),
hours number(10),
constraint essn_fk_1 foreign key(essn) references employee(ssn),
constraint pn...
Hello Experts,
I just tried to install Oracle 11g on Linux (centOS). The documentation says that the minimum requirements is 1G of RAM; I have 2 GB. But, when I try to install, the kernel p...
Hi,
I have an old Oracle installation running since 1998. I have an UNIX-HP-UX Workstation with Oracle 8.0.5 Database. The Clients are running on Windows machines. Some processes are running ...
Experts,
I am installing Oracle Clusterware for the first time and i ran into the following errors.
What kind of privileges does the user need to install, as you can see from the error mess...
Hello experts,
Though I do see services available when running ./netmgr; when I start the listener it shows none. Pls see below.
I need my default LISTENER to support services....
Thx...
We have a DR site and the current DR plan is to send the daily full data dump to the DR server and import.
I understand there is a more efficient and faster way for recovery by sending the...
I just installed Oracle 11g on a new Fedora 9 Linux box. Everything installed fine. However, I am seeing some odd behavior that I can't figure out: I can tnsping and sqlplus (connect) perfec...
Does anyone have any installation instructions for ODP.net 11g components working against an Oracle 10g Database Server with Visual Studio 2008. I've been able to get ODP.net 11g installed wit...
I have J2EE application running on OC4J application server. Where the database connection is dropping / resetting after some idle time. The idle time varies from 20 mins to 90 mins. The persis...
Dear Experts,
I have 5 TB of space on a Windows 2003 server and i am trying to create an extended partion on this, when i right click on the disk and choose create new partition, it only giv...
Dear Experts,
I am trying to connect a oracle database from my linux server (fedora 5). I am given a TNS as bellow :
------------------------------
ABCD =
(DESCRIPTION =
(ADDRESS ...
Hi,
I am working on Oracle application express, i am quite new to it. I need to develop a simple data entry form, for the tables that reside in an another database, i have created dblink for...
I have an unruly database that writes massive amounts to the alert logs. I have no choice but to clean these up somehow. I have taken measures to copy the results from x$dbgalertext that ex...
Hello Experts
I am a young C# Developer and I am familiar with the System.Data.SqlClient/System.Data.OracleClient namespaces however I recently found out that Oracle is no longer supporting...
Experts,
I have been working with Oracle 11g and trying to staically register the listener file. We have had issues with our database where the following error is returned "ORA12528 tns ...
We recently installed Oracle 11g onto and windows 2003 64 bit server with 8 gigs of memory. There were some hard crashes due to power outages and now Oracle is creating excessive TRC files ...
Try to get a detailed init.ora for Oracle 11g in Windows env.
experts,
I often need to open the terminal window and set the Oracle environment for one SID. Is there a way to automate this process? I looked up the solution but the web site liste...
We are upgrading our databases from 9iR2 to 11g.
1) would you recommend upgrading all the client machines that have 9i client to 11g too. Is there any benefit to that or 9i would still work...
Hi Experts.
I need information on PL/SQL Native compilation. I have the overview, but want to hear from horses mouth. Here are my queries
1. I need simple example of pl/sql native compilat...
I am profroming the install of the Oracle 11g database on Win 2003 R2 Server. I have kept
all the default settings (Oracle Home etc.) . On the last protion of the database install when it ...
Hello Experts,
Any idea why I am getting this ORA-12504 error?
Pls see below my listener.ora
Thx,
Regards
