DBF File Size Changing After Cloning Same Schema From Different Machines In Oracle 11gR2
Jul 22, 2011
Our product uses Oracle11gR1 and in new release we are going to use Oracle11gR2. For this we are performing following steps:
(1) Install Oracle11gR2 on a machine where our product (Oracle11gR1) is already installed.
(2)Upgrade Oracle11gR1 schema to Oracle11gR2.
(3)For using upgraded schema in our product installer we create clone of upgraded schema.
(4)For creating clone we are using Oracle11gR2 DBCA utility.
(5) Clone files are successfully created (DBC, CTL, DBF).
Now we performed same steps from another machine and DBF file size changed very much. On one machine it was 89 MB and on second machine it was 150 MB. There is no different in schema and both machines are Windows 7 machines.
Tor educe size of schema we tried different space reclamation commands but size is not changing.
View 3 Replies
ADVERTISEMENT
Mar 24, 2013
i have a .dmp file and i want to use the data in this file for my further practices. so, i need to dump the data in the .dmp file to the any schema exists in data base.
View 1 Replies
View Related
Sep 28, 2012
How can i set db home name at the time of installation of oracle 11.2.O.3 .
View 3 Replies
View Related
Apr 8, 2013
I am trying to install Oracle 11g R2(64bit) on Windows 7 64 bit OS. While Creating Database using DBCA. I am getting error. Below is the screenshot.
Below is the error in the Trace file...
oracle.sysman.assistants.util.step.StepExecutionException:
Error in Process: C:Oracleapporacleproduct11.2.0serverinorapwd.exe
Unable to find error file %ORACLE_HOME%RDBMSopw<lang>.msb
View 3 Replies
View Related
Oct 26, 2012
I have created my schema in SYSTEM schema way back accidentally by forgetting to specify the database tablespace. There is about 60 objects (tables, indexes, functions etc) and 6MB Of data.
What would be the best way migrate the schema to the tablespace I planned to put it into? .
View 7 Replies
View Related
Apr 13, 2011
I am using oracle 8.1.5 database and my temp01.dbf file size is increased upto 19.8 GB now i want reduce its size .
View 13 Replies
View Related
Aug 23, 2012
we are planing to put the same oracle environment on two machines.
what is the best way to realize that.installation on each machine or installation on one machine and copy the environment to the second?
View 8 Replies
View Related
Mar 2, 2011
I want to send mail whenever the schema password is changed by the developers (clients) . I created this trigger to send mail. I am able to know which schema's password is changed but i want know how to get the client details who is changing the password.
Create Trigger Pwd_chg_trigger
before alter
on database
declare
begin
if (ora_dict_obj_type = 'USER') then
DBMS_OUTPUT.PUT_LINE(' ORA_DICT_OBJ_OWNER = ' || ORA_DICT_OBJ_NAME); -- to know which schema
-- using the above value and additional formatting i am sending the mail using my SMTP
end if;
end;
/
View 3 Replies
View Related
Mar 13, 2011
The Oracle machine A (11R1) is placed in San Jose.
The Oracle machine B (10R2) is placed in Sydney.
I need to develop a daily replica from A to B. I don't need the entire db, but only some single schema.
The entire DB size is 1TB.The exp pump gzipped dump size will be 5+GB.Tnsping from A to B takes 500+ ms.The regular A exp pump -> ftp -> B imp pump will be too slowly because of the poor network.Which way it would be the best to implement it?
View 2 Replies
View Related
Oct 10, 2012
Machine 1: Oracle server installed and database hosted on this Machine.
Machine 2: Oracle client is installed and connect through sqlplus to database in machine 1.
The requirement is: I need to have a Java/C program in machine 2 (where client available) which needs to be called from the stored procedure in server on machine 1. The objective is calling a java/C program from Oracle stored procedure but available on 2 different machines. Is it possible,
Environment: Oracle 11.2.0.1
UNIX AIX 6.1
View 3 Replies
View Related
Nov 7, 2007
I want to export the oracle data into an excel sheet. I have written the code by using UTL_FILE package. but i am getting the output as shown in the screen shot(without formatting the column size as the width of the data it has). But I want the output column width to be set according to the size of the data automatically.
View 5 Replies
View Related
May 25, 2010
I need to install Oracle Data Provider for NET (and all depending Oracle client SW components) in multiple client machines.
Exist any other options (faster) without installing oracle client on each of the machines?
View 4 Replies
View Related
May 15, 2013
Version Details:
O.S Version HP-UX B.11.31 U ia64
Oracle DB Version 11.2.0.3.0
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Scenario :
Using RMAN Active cloning to duplicate a RAC database from Production to Development environment.
Problem:
At the end of the cloning the below errors are reported;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
[code]...
How to prevent the error of RMAN-06054: media recovery requesting unknown archived log for thread with sequence and starting SCN of while performing the RMAN Active Cloning? I do NOT want to use UNTIL clause.
View 5 Replies
View Related
Jul 13, 2012
How can in increase the allocated space for a schema in Apex Admin section?
I know you can set this when creating a schema alongsite a workspace and looks like the only way to do it is via raising a service request for more space and loggin in as ADMIN and approving it (in increments of 500MB).
View 4 Replies
View Related
Jan 23, 2013
I have to do oracle database cloning from asm to non-asm.
View 4 Replies
View Related
Oct 4, 2013
I have a database(10.2.0.5.0) in solaris 10 , i simply take a tar backup of ORACLE_HOME andextracted them into another server (which is solaris 10 only) and linked the binaries after that when i connecting with sqlplus.
I am getting following error
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Oct 4 14:49:48 2013 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Enter user-name: /as sysdbald.so.1: oracle: fatal: libskgxp10.so: open failed: No such file or directoryERROR:ORA-12547: TNS:lost contact
I would like to tell that i have also oracle 11gr2 running on the server my oracle_base is same for both(10g 11g)but ORACLE_HOME is different.
View 3 Replies
View Related
Mar 30, 2007
I'm taking export dump using expdp of some schema's of total size is 300GB. This is the par file:
DIRECTORY=expdp
FILESIZE=32212254720
DUMPFILE=expdp_schema01.dmp,expdp_schema02.dmp,expdp_schema03.dmp,expdp_schema04.dmp,expdp_schema05.dmp,expdp_schema06.dmp,expdp_sche ma07.dmp,expdp_schema08.dmp,expdp_schema09.dmp,expdp_schema10.dmp,expdp_schema11.dmp,expdp_schema12.dmp,expdp_schema13.d
[code]....
here one biggest schema size is 250GB and the total size of all the schema's is 300GB. The file where am taking the dump has 350GB space but even then the expdp failed saying
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
why it failed and how to restart it and make sure it runs successfully without error.
View 4 Replies
View Related
Apr 19, 2011
To clone my oracle binary from host A to host B, in order to make up my DB in the host B
see bellow the necessary information:
source :
version host:HP-UX hostA B.11.11
db : Release 9.2.0.8.0
destination :
HP-UX hostB B.11.31
View 6 Replies
View Related
May 5, 2013
oracle 11g ASM RAC under OEL 5.6 . i just want to do a cloning so first i create cloning of my oracle home and then i create pfile and i get this error
SQL> startup nomount;
ORA-29702: error occurred in Cluster Group Service operation
SQL> exiti google it , i found this issue is with relink RAC binaries due to the souce database is RAC and destination is not
[oracle@backuptest ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@backuptest lib]$ make -f ins_rdbms.mk rac_off
bash: make: command not found
View 5 Replies
View Related
Nov 29, 2011
I need the step by step procedure for the cloning of database in linux environment .
View 2 Replies
View Related
Jul 19, 2011
I tried to write a dynamically changing filename and file type so that i can dump some data. But the code I wrote is not producing any file at all even though it compiles with no errors. I run this code at XE database which comes free from the oracle website. I did all the directory settings. No problem with it because I can produce file with different codes. The code is as following:
CREATE OR REPLACE PROCEDURE dump_csv_file IS
TYPE number_array IS VARRAY(10000) OF NUMBER;
TYPE string_array IS VARRAY(10000) OF VARCHAR2(100);
TYPE date_array IS VARRAY(10000) OF DATE;
TYPE v_file_array IS VARRAY(10000) OF UTL_FILE.FILE_TYPE;
[code]...
View 11 Replies
View Related
Mar 20, 2013
I want to do cloning of a database on my standalone pc having oracle 10g on windows 7. PC is P4 with 2GB RAM.
The database is installed on my pc and i want to clone it on the same pc.
View 4 Replies
View Related
Mar 22, 2013
os version is solaris 10
db version 11.2.0.3
how to tune log file sysnc waits in 11gr2 what parameters are involving in tuning log file sync and what would be its optimal values.
View 9 Replies
View Related
Apr 24, 2013
Using Application Express 4.2.1.00.08
Any problem using 4.2's One Level Tabs - Content Frame page where you have a parent region (of type content frame Body Container ) while number of child regions (of type Hide & Show Region - Borderless ), if you want to re-order them by changing the sequence, it has no effect when you run the page.
The regions still show in the same order top to bottom as it did before the update of sequences. Heading links (to show/hide child regons in content frames) has the same ordering as before.
View 3 Replies
View Related
Jan 13, 2011
How to use same oracle sequence name in Oracle Database schema as well as timesten schema?
View 1 Replies
View Related
Mar 28, 2012
Can we restore database password file in ASM for 11gR2 version.
View 4 Replies
View Related
Jun 3, 2013
I have a deadlock trace file to analyse and i used to be able to see the rowid as a 16 bit hex value in the trace file, which i could then query on to get the actual real world row name.I see in the 11GR2 deadlock trace the formatting is different and for the life of me i am unable to see the rowid. Has Oracle stopped reporting this now, or is their another way to get this value? The deadlock graph shows me
*** 2013-05-14 14:49:15.047
Submitting asynchronized dump request [28]
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.16e] :
BLOCKED 0x4362890f8 5 wq 2 cvtops x1 TX 0x3d001b.0x18a3021 [FF000-0001-00000002] inst 1
BLOCKER 0x436288f38 5 wq 1 cvtops x28 TX 0x3d001b.0x18a3021 [102000-0001-00000002] inst 1
[code]....
View 0 Replies
View Related
Oct 1, 2013
I'm using Oracle10G (10.1.0.2) Enterprise Edition. The size of the listener.log file approximately 2.46GB. Is this responsible for any performance problem of any service in my current instance...
View 9 Replies
View Related
Jul 30, 2013
1.2.0.2 on RHL.. 3 Log Groups with 1 member each. db_recovery_file_dest string /oracle/oraarch For the purpose of increasing log file size, if i use ALTER DATABASE ADD LOGFILE GROUP 1 SIZE 300M; but it creates Log Group with 2 member. one is at /oracle/oraarch location and other at /oracle/oradata (db_create_file_dest).
We are using ORACLE MANAGED FILE SYSEM . I want only 1 member at /oracle/oraarch (to keep the previous setting intact ...just increasing the size from 100 to 300M). If I manually give the path where to create the logfile member, I get this error:
ALTER DATABASE ADD LOGFILE GROUP 1 '/oracle/oraarch/DB/onlinelog/' SIZE 300M;
ALTER DATABASE ADD LOGFILE GROUP 1 '/oracle/oraarch/DB/onlinelog/' SIZE 300M
*
ERROR at line 1:
ORA-00301: error in adding log file '/oracle/oraarch/DB/onlinelog/' - file cannot be created
ORA-27038: created file already exists
Additional information: 1
View 8 Replies
View Related
Sep 1, 2010
I am getting the following error when i try to re size the data file.But the data file is having lot of free space.
ORA-03297: file contains used data beyond requested RESIZE value
Presently table space size is 220GB with 8 data files.As the process of the performance tuning we moved data to different table spaces.Now used space of the tablespace is 90GB.So I am trying to resize the datafile but it throw an error.
View 1 Replies
View Related
