Hello Experts,
I need to be able to connect to Oracle 11g server (tower) from my laptop. I am losing my mind. Please help.
Please see server configuration below, am I missing something?
...
INSERT INTO CustomerFamilyHistory (customerfamilyhistory_id_seq.nextval, firstname, lastname, age, ?????, sibling, customerid)
SELECT customerfamilymemberfirstname, customerfamilymemberlastn...
OS: RH Linux X86_64
DB: 11.1.0.7
Storage: SAN w/64k page size.
What does Oracle recommend as far as running disk defragmentation utilities on the database mount points?
Our SA set this ...
I created some sequences. I would like to indulge into the primary key column in CREATE TABLE script. How can i do it?
Anyone able to confirm Oracle 10g and 11g is certified on Windows 2008 64bit platform?
I have a 32bit Application running on a Windows 2008 64 bit server using Oracle V11 32 bit client. I am publishing it to a Terminal Server and it works OK using Remote Desktop. I published...
1Z0-007 and 1Z0-051 exam topics are easier than 1Z0-047. However, 1Z0-051
is a new one Oracle Database 11g: SQL Fundamentals I.
Source: http://education.oracle.com/pls/web_prod-plq-dad/db...
Try to get a detailed init.ora for Oracle 11g in Windows env.
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...
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...
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 ...
Hello Experts,
I am having problems with my listener. It does not know the service name; but I do see it and need it.
I am configuring it (and reconfiguring it) via ./netca and/or ./netmgr...
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...
Hi
I have installed Oracle 11.2 Grid Infrastructure (standalone) on RHEL 5.3 64-bit
After I changed hostname of the server I cannot connect to ASM instance.
I am getting the following e...
Hello,
I am interested in understanding the pros and cons of storing billions of rows for real-time access in XML DB or in a traditional relational DB. The logical data model for this solut...
We have a financial apps that our management wants to be on high availability.
We had crafted out a failover solution based on Windows 2008 Server Enterprise failover cluster with 2 dedica...
Hi there,
I have Oracle 11g installed on a server. We currently use a database control for each database instance. This equates to 200mb of memory for java.exe and 250 mb of memory for or...
Dear colleagues,
Here is my situation,
we have 2 HP DL380 servers with 1 Xeon Dual-Core on every server, and planning to buy Oracle Ent basic configuration
Here is some questions, that I...
Hello Experts,
During Oracle 11g initial install I get the warning below. I am not sure how to fix.
all environmental variables have been set correctly including ORACLE_HOSTNAME.
But, I ...
When upgrading to 10g last year we had an issue with Siebel efficiency. Since siebel creates its own queries we could not optimize this through our sql code. The solution was to use stored o...
hello Experts,
I have Oracle 11g installed on my tower (no firewall - Centos 5.3 - all environmental vars set correctly, listener working, and dbconsole is started)
I want to be able to ...
hello experts,
Can I do this:
ORACLE_HOME=192.168.0.1/oracleInstallPath?
Why?
oracle 11g is located on tower1
cfg_server is located on tower2
cfg_server is asking to set ORACLE_H...
Experts,
Can someone please provide me a script to backup a Oracle 11g database, using Data Pump.
I would to setup a job for nightly backup.
regards
I exported an 11g schema to 9ifile.dmp on a unix machine.
I installed 11g on windows and created a database APPS.
I ftp the file from unix to windows.
I want to import the file to APPS da...
We are planning to deploy Oracle 11g DBMS (STD) on Windows 2008 STD 64bit on VMware ESXi 3.5 .
I could not find anywhere on Oracle website that VMware is supported, only mentions that MS H...
