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


ADVERTISEMENT

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

Migrate Current Production Database To Test 10.2.0.4 On Windows

Feb 1, 2011

I have to migrate the current production database to test 10.2.0.4 on windows. Any non-export way to upgrade 9i to 10 g?

i have following steps

1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
2) shutdown oracle 9i database on server A
3) copy database file, controlfile, redolog, and other files to new server B
4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations
5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA
6) start dabase in upgrade mode
7) run catpat.sql and util102.sql
8) take backup
9) open database for users

View 3 Replies View Related

Instance Of Oracle Enterprise Manager 10g Database Control Already Running

Jun 4, 2012

I'm have in Oracle version Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production:

while enter in a command

$emctl status dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Oracle Enterprise Manager 10g is running.
----------------------------------------------------------------------------------
$emctl stop dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
-----------------------------------------------------------------------------------
$emctl start dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
-----------------------------------------------------------------------------------

View 1 Replies View Related

Windows :: Test If Database Is Running?

Sep 15, 2010

I have a unix script that will check if the database is up and running. I need a similar script but this time in windows batch file.

this is the snippet of the code from the unix script:

#! /bin/sh
sqlplus -s /nolog > /dev/null 2>&1 <<EOF
whenever sqlerror exit failure

[Code].....

View 2 Replies View Related

Forms :: Running Oracle Database 10g On Windows 7

Nov 12, 2009

I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs

View 9 Replies View Related

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

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

See If PMON Or SMON Running On Windows Server?

Feb 27, 2013

On windows server how can we see if the PMON or SMON is running? Is there a way, as we can see on linux using?

View 6 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

View 4 Replies View Related

How To Create Central Inventory For Oracle 11g Running On Windows Server

Dec 26, 2012

--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.

We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.

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 :: 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

Windows :: Changing JDK From Production Client?

Oct 20, 2011

I have been asked to create a new instance of an application server. As part of this, my management has asked me to replace any old JREs or JDKs.

We run 10g, so I installed the 10203_vista_w2k8_x86_production_client on my new server. I would like to replace the 1.4.2 JDK that is bundled with the Oracle Production Client with 1.6.0.

View 1 Replies View Related

Oracle EM Not Running Instance?

Nov 1, 2010

I have Oracle 11g R2 (11.2.0.1) with Oracle EM running on Solaris 10 with ZFS.When I start OEM it comes up and tells me that the listener is running but that the DB instance is down and agents are down.I know that the instance is up because I can start it manually.

Each time I start emctl, lsnrctl and DB manually everything starts running but OEM returns a failure for the DB. long as the display shows the DB not running OEM won't allow me to work in it.Instead of getting the login page I get the Database Control Page stating that "Enterprise Manager is not able to connect to the Database instance."I have tried the various emca -config dbcontrol db -repos drop and recreate but no luck.

Is there a way to uninstall/reinstall without dropping the DB?Are there control/configuration files I may hack to tell OEM the correct information?

View 3 Replies View Related

Windows :: Installing 10g Database Software On Windows 2008 Server?

Sep 28, 2010

I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:

Checking Operating system version: must be 5.0,5.1,5.2 or 6.0

Actual 6.1

FAILED <<<<

Exiting Oracle Universal Installer

Press any key to Exit.

View 12 Replies View Related

Reports & Discoverer :: OC4J Instance Tracking And Report Builder Running?

May 1, 2012

How to check in which port : OC4j instance is running ??

How to run the report using : OC4j instance and deploy into application server?

View 3 Replies View Related

Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?

May 4, 2011

I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?

View 1 Replies View Related

Server Administration :: How To Get Disk List On Any DB Instance That Uses ASM Instance

Mar 16, 2011

My context on our servers is the following one:

- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks

On each DB instance you can see:

- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view

So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?

View 6 Replies View Related

Server Administration :: Script To Automate Startup / Shutdown Of Multiple Instance In One Database

Jun 24, 2010

Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.

View 1 Replies View Related

Data Guard :: Change Server B To Standby Database With A Running As Primary

Oct 4, 2010

I new to data guard concept.

I am using oracle 10g with data guard configured , I have primary ( A ) and standby database ( B ) .But because of some unavoidable conditions the primary database ( A ) got shutdown and was not starting , We shifted the standby database ( B ) at new location and changed it to primary with following command ,

startup mount;
alter database recover managed standby database finish;
alter database commit to switchover to physical primary;
shutdown;
startup;

This new primary ( B ) was open for end users for 2 days during which old primary ( A ) was shutdown .

I took the backup of ( B ) and restored it on A AND shutdown the B . Now A is acting as Primary database. Server B is shutdown . I want to change server B to standby database with A running as Primary .Is it possible ?

View 5 Replies View Related

Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home

Sep 29, 2011

We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.

View 2 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Forms :: Running Reports 6i On Windows 7?

Nov 2, 2009

would like to check if anybody running Form/Report 6i on Windows 7 ? I meant not XP mode.

View 3 Replies View Related

Copy Database From Production To Test?

Feb 22, 2011

Would like to know if I can replicate Production database (10.2.0.2) to Test (10.2.0.4).

tell me the process to do that on windows environment.

I wonder if I can do it with two different oracle versions?

View 4 Replies View Related

ORA-12154 Running 32 Bit Oracle Software 0n 64 Bit Windows?

Oct 7, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:\Program Files (x86) on 64 bit windows, The PATH variable doesnt recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client.

Oracle Client: 10.2.0.3 32 bit

Windows OS: Windows server 2008 R2 64 bit

I have referred the below document from the metalink(which states that the bug is fixed in 10.2.0.3 client).

ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS [ID 334528.1]

View 1 Replies View Related

Windows :: Error When Running Macro Excel

Jan 13, 2012

I installed Oracle 11gR2 database for windows 7. I believe it's 32 bit. I keep getting an error when I run my macro excel: Error while trying to retrieve text for error ORA-01019.

View 1 Replies View Related

Standby Data Files - Production Database?

Jul 24, 2012

: I noticed three data files on my standby show's they are corrupted. What will be the easy and fast way to sync them up from my production database?

View 1 Replies View Related







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