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