Production Oracle DB 11g On Virtual Server

Apr 25, 2013

We just got a new Dell R720 server that will host our Oracle DB. The server hasn't even been turned on yet but we know that the load on the server will be very low for a long time.

One of our problems is that we need to run a VERY important application. Since it is not very resource consuming compared to it's importance we chose to run it on a not so new Xeon 5110 1.60 GHz - 4GB RAM server. He said it's not a good idea and that we should buy a new server. (money is very low)

The software vendor suggested to virtualize our R720 server, host a vm running our database, and along with it other smaller machines like the one I described above. I suggested the use of Oracle VM, Oracle Linux for the database host and transforming the physical servers servers in VM with P2V.

Our IT Manager didn't like that, he said that it's not recommended to run a database on a virtual machine. But our software vendor said that many of their clients run their solution this way.

View 7 Replies


ADVERTISEMENT

Export/Import/SQL Loader :: Oracle 9 Database Refresh From Production Server To Integration Server

Oct 13, 2012

I will have to proceed with Oracle 9 database refresh from production server to integration server. 5 biggest schemas must be exported and imported. They constitute 97% space used in a database. This is very big database so I would like to be sure that everything will go smoothly. That is why i want to ask you some questions.

Have you got any clues for me before I start with exp/imp? From my side i will tell you that I will have to exp/imp schema by schema because there is small space both on production and integration disk for a dump. First thing I thought are dependencies between schemas that are exported and that which are not, and also between schemas that are exported/imported one by one.

This is procedure that I plan:

For every schema that is to be refreshed
{
1. Export schema with ROWS=N CONSTRAINTS=Y
2. EXPORT schema with ROWS=y CONSTRAINTS=N
3. Import schema from step one
4. Disable all the foreign key constraints using ALTER TABLE DISABLE CONSTRAINT.
5. Import schema with rows
}
ALTER TABLE ENABLE CONSTRAINT

With above procedure i think that I will avoid problems with dependencies between schemas exported/imported one by one. But my concern is if there are any dependencies between those schemas and schemas that are not exported. Is there an way to check it before refresh ?

View 4 Replies View Related

Server Administration :: Getting Error When Install Oracle Grid Infrastructure On Virtual Box RHL 5.5

Aug 6, 2013

When trying to install Oracle Grid Infrastructure on Virtual Box RHL 5.5 (2.6.18-194.el5 kernel) machine it gives error.

Quote:$ Xlib:connection to ":0.0" refered by server
Xlib:No protocol specified

Exception in thread "main" java.lan.NoClassDefFoundError

at java.lan.Class.forName0(Native Method)
..........at oracle.install.ivw.crs.driver.CRSInstaller.main(CRSIntaller.java:103)

View 7 Replies View Related

Server Utilities :: IMPDP Error ORA-31693 On Oracle Virtual Column With Not Null?

Jun 21, 2013

I am having issue with IMPDP on ORACLE VIRTUAL COLUMNS.I am having following table with Virtual column defined with Not null. Expdp is fine without any issue.

DDL :
------
CREATE TABLE alert_hist
(
alertky INTEGER NOT NULL,
alertcreatedttm TIMESTAMP(6) DEFAULT systimestamp NOT NULL,
alertcreatedt DATE GENERATED ALWAYS AS (To_date(Trunc("alertcreatedttm"))) VIRTUAL NOT NULL

When I do the import (IMPDP) it got failed with the following error.

. . imported "TESTSCHEMA"."VALART" 359.1 KB 4536 rows
ORA-31693: Table data object "TESTSCHEMA"."ALERT_HIST" failed to load/unload and is being skipped due to error:
ORA-39097: Data Pump job encountered unexpected error -1

After that I dropped the Virtual Not null column and recreated that column with Nullable.

DDL :
-----
alter table alert_hist drop column alertcreatedt;
alter table alert_hist add alertcreatedt DATE GENERATED ALWAYS AS (To_date(Trunc("alertcreatedttm"))) VIRTUAL;

After that I took the expdp and impdp , it went fine with out any issue.

View 7 Replies View Related

Production Database Server Process

Apr 27, 2013

Oracle 11g default server process is dedicated select distinct server from v$session; dedicated

Which server process is used in the oracle 11g Production? if the database is connect to an online application?

View 19 Replies View Related

Why Production Server Slower Than Development Workstation

Jun 24, 2008

I have a JSP that works with an Oracle 9i database.

On my local windows workstation where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server connecting to the same Schema processes very slow sometimes during the day. During off hours the Production Intranet JSP with Oracle processes quicker.

There is only one user for the application and I dont understand why the same application using the same database runs so much slower sometimes on the production server compared to my local workstation.

View 1 Replies View Related

Automate Import From Production To Test Server

Nov 15, 2011

I would like to know that how can i automate the export from production to test server. I need direction to create process to import data from production (server A) to test server (server B).

View 6 Replies View Related

Server Utilities :: Data Import From Production To Test

Jan 26, 2012

I want to automate the import from production to test.

1) export the production schema
2) import in to test server?

How can i automate that currently i am doing it manually as follow:

1) expdb the production schema
2) kill all connection on the test server to test schema
3) drop test user cascade;
4) recreate user;
5) impdb the production schema to test:

but i want it to automated or scheduled so i don't; have to log in every night!!

View 5 Replies View Related

Server Utilities :: Running Exp And Imp Command On 11.2.0.1.0 Production Version

Jul 25, 2012

I ran "exp" command to take a back of Oracle Db based on user and later imported(using "imp" command) the dump into another db. Its seen that some the tables are not exported during exp command run. Can I use exp command on Oracle 11.2 version?

or should I always be using expdp command?

View 3 Replies View Related

Server Administration :: ASM - Disk Strategies In Production Environments?

Jan 26, 2010

I am working on ASM as i am bit confused to decide ASM Disk strategies in production Environments. For Ex:-

1.Normal Redundancy ( Allows 2 Mirror Groups ) :-
I have created Normal_DG Diskgroup with 4 Disks

Disk1-------------------
Disk2 ------- |
|--->FG2 ----> FG1
Disk3 ------- |
Disk4-------------------

According to my understanding , if Disk1 Fails Disk4 facilitates normal operations. When there is space crunch it operates in reduced redundancy . Am i right ?

2.I have got 4 Disks in one group (i.e from Disk1 To Disk4 ) i have not defined any failure group and as per my understanding all disks will be added to its own failure group without mirroring and striping.

View 2 Replies View Related

SQL & PL/SQL :: Oracle Virtual Private Database Policy

Mar 31, 2012

I created policy as follow.

BEGIN
DBMS_RLS.ADD_POLICY (
object_schema => 'scott',
object_name => 'orders_tab',
policy_name => 'orders_policy',
function_schema => 'nisadmin_vpd',
policy_function => 'get_user_orders',
statement_types => 'select');
END;
/

After the creation of this policy for the table when I select the table Orders_tab then getting the below error.

ORA-00904: "ORA_ROWSCN": invalid identifier

When I dropped this policy then I can see the records of Order_tab table.

View 3 Replies View Related

Windows :: Oracle 10g On Virtual Machine 2003 X64

Jul 9, 2010

Does already installed Oracle 10g (10.2.0.1) on a windows 2003 server x64? Do you notice strange behaviors, any errors after the installation?

Does already installed Oracle 10g on a windows virtual machine? Are there any prerequisites?

View 9 Replies View Related

RAC & Failsafe :: Two Node - Configuration On Oracle Virtual Box

Mar 27, 2013

I am configuring two node RAC on oracle virtual box. Did its mandatory to configure DNS on both nodes before Rac installation? Whats the purpose of DNS in RAC. And if its mandatory did i have to configure DNS on each node separately?

View 1 Replies View Related

Application Express :: Oracle XE In Production

Jan 1, 2013

I am trying to use the APEX (as a substitute for my PHP forms base application) for a new client. Can I use the APEX and Oracle XE in production, without spending any money for a license from Oracle - i.e. for listener, Web server, etc,?

I already have setup the APEX that works fine on my laptop, able to see and work with the form on the browser, so can I take the same to a server as a production?

View 4 Replies View Related

Oracle Clustered Production Environment

May 26, 2013

I have a requirement to upgrade Oracle Data Integrator(ODI) from 10.1.3.5 to 11.1.1.6.3 We have a Clustered production environment where N1 will be up when N2 be down and viceversa.

Here N1 and N2 are the ODI servers as well as DB(11g Release 2) servers. They both access the SHARED CLUSTERED database. From ODI we will generally point the Oracle clustered IP(Virtual IP) which will internally point either N1 or N2 whichever is active. ODI application wise we are clear about the procedure.

Having some issues on DB related activities.

1. Should I break the cluster definitely? Cant I do the activity without breaking the cluster?
2. Do I need to point N1, N2, Clustered IP (Virtual IP) while doing the activities?
3. Since its a clustered database, do I need to db related activities once or twice? (Twice means, manually on both the servers)
4. As they are using same file structures (RAC), If the Virtual IP points N1 by default, assume that I create two new users a

View 1 Replies View Related

Cons Of Running 8 Production Database Instance On One Windows Server

Dec 3, 2010

We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.

I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.

My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)

View 6 Replies View Related

Server Administration :: How To Refresh Test Schema From Production Request

Oct 31, 2012

Steps to Refresh test Oracle 9i schema from production schema on a Windows platform..

View 3 Replies View Related

Server Utilities :: Use Data Pump For First Time On Production Database

Sep 13, 2011

I need to use Data Pump for the first time on my production Database.Currently on Testing Database, when i am taking schema level export there are no errors or warnings in the log file but when i importing it gives fallowing ORA in the import log file. i searched on google,the only way i found is to recompile the invalid objects. how to avoid this warnings in log file.

"ORA-39082: Object type ALTER_PROCEDURE:"QUANTISV4"."P_CTM_ABN_INVST_EQUITY" created with compilation warnings"

View 4 Replies View Related

Server Administration :: Tablespace Auto-Extend OFF On Production System

Jun 6, 2012

I want to OFF tablspace AUTOEXTEND on a prodution system, we have many RAC databses and that will be done on all stations. i have got a document from net which was written on 29-Jun-2007 and it says that if need to OFF the AUTOEXTEND of a TABLESPACE so you need to ist make it off on the underlying datafiles of that tablespace so this doc is for Oracle 8.1.7.2.0

View 2 Replies View Related

Accessing Oracle On VirtualBox From Host Virtual Machine?

Jul 18, 2013

I have a Host system of windows 8, installed the Virtual Box Latest edition.The guest OS is the oracle Linux that came with the Pre-Built Developer VMs from Oracle.The VM is set to HOST ONLY network setting. Now, the thing is that i want to access the Oracle in the guest machine from my windows host machine.the guest OS shows the IP address as 192.168.56.101. I can ping the IP address from the HOST machine, but cannot connect theSQL developer to the oracle in the guest OS from the host machine. It keeps on saying the Network adapter cannot connect. do not say that install the oracle in window itself. I actually want to do the same on my macbook pro as that is my primary machine.

View 10 Replies View Related

RAC/ASM Clusterware Installation :: Virtual IP For Oracle 11gr2 Cluster?

Sep 8, 2012

I created Virtual Private Network for VIP and subnet is 255.255.255.255. I need VPN subnet as 255.255.255.0. How to i create

INS-40911:      Ensure that nodes in the list are up and reachable, and ensure that the node addresses are all in the same subnet.

View 2 Replies View Related

Cannot Connect To Oracle Running Under A Virtual-PC XP Mode Guest

Oct 27, 2012

Host: Win7

Guest: Using Virtual PC on Win7, created a VM using XP-Mode. Installed Oracle and everything on it. I can connect to the Oracle from within the guest env using sqlplus. Listener is also running, checked with 'lsnrctl status"

Guest and Host can ping (network) each other. I installed the guest using the Microsoft Loopback Adapter. Disabled the firewall on the guest OS before the host ping could work.

So ping works both ways from guest to host and host to guest. tnsping from host fails says "no listener". When I did a "telnet 192.168.x.x 1521" from host it said could not open connection on port 1521.

How do you open port 1521 on the guest OS to traffic from the host OS?

View 2 Replies View Related

Where To Download ORACLE Software Version For Production

Nov 1, 2010

Where to download the oracle software for building a production server? What are steps ?

View 1 Replies View Related

Server Administration :: Number Of Sessions In Database MES (production) Coming From Another Machine

May 25, 2010

We have quite a number of sessions in database MES (production) coming from another machine.

From v$session, the program is oracle@WID27 (TNS V1-V3). This WID27 (hostname) consists of quite a number of development databases inside. We have to trace which jobs are actually triggering this, as WID27 are not suppose to connect to production databases.

How can we tell whether the sessions came in is from dblink or from the machine itself?

View 3 Replies View Related

Server Administration :: Import Data To Production Database - Details Are Not In Tnsnames.ora

May 3, 2011

I need to import data to production database. The database details are not in tnsnames.ora.

I am using easy connect method to connect to the database, since I am not able to edit tnsnames.ora.

Is there any way by which I can do the import ?

Can I do it like this

imp system/pwd@imp system/pwd@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)))(C
ONNECT_DATA=(SID=xx))' ......................

View 4 Replies View Related

Performance Tuning :: Creating Workspaces On Production Server For Application Service

Apr 15, 2013

how would we learn creating workspaces on the production server for application services:

* Folder structure
* How client workspaces are sharing other common folders, tomcat, java, software release etc
* Scripts tomcat and create54workspace

View 2 Replies View Related

Importance Of Public And Virtual IPs In Etc / Hosts File When Dealing With Oracle RAC

Mar 12, 2011

When working against the Oracle 10G/11G RAC database it's important to have all the relevant entries in the etc/hosts file.

Thus, when running the following code against the database sometimes it finishes with "Ok!" and sometimes getting the error below:

CODEimport java.sql.*;
public class TestDBOracle {
public static void main(String[] args)

[Code].....

The reason is missing RAC-related entries in the etc/hosts.

When dealing with Oracle RAC it should be both entries for the public and for the virtual IPs of the nodes in the etc/hosts file.

CODEA.A.A.A                        NODEA
A.A.A.B            NODEB
...

B.B.B.X            NODEA-VIP
B.B.B.Y            NODEB-VIP
...

View 1 Replies View Related

Client Tools :: How To Configure SQL DEVELOPER Via Virtual Machine Oracle Database

Mar 21, 2012

i have oel installed on my parallel Virtual machine.

i have a problem with configuring sql developer to the oracle database which is located in my virtual machine.

my os is windows7 32 bit.

View 13 Replies View Related

Installation :: Oracle Database 11gR2 On Virtual Box on Windows 32bits Machine

Oct 31, 2013

I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.

View 6 Replies View Related

Oracle 11g - Java Virtual Machine Could Not Find Main Class Program Will Exit

Jul 26, 2013

In my Organization I am trying to install oracle ODTwithODAC112030 but one Error showing that is java virtual machine could not find main class program will Exit. 

Server Configuration Dell power Edge r510 Windows 2003 64 bit serv PAck 2 Citrix Presentation server 4.5 .

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved