Oracle Apps R12 Backup?
Jul 18, 2011way to backup Oracle Apps R12 in Linux.
for Oracle DB tier I use RMAN.
ADVERTISEMENT
Networking And Gateways :: APPS Listener Not Starting On 11i Apps Pointing To 10R2
Jun 25, 2010How do I install the 10G listener on the application server (11i)
View 3 Replies View RelatedForms :: Get_file_name For Oracle Apps?
Jul 15, 2010How can we do get_file_name for Oracle apps forms, server installed on Linux, like I wanted to get a dialog box to browse the data?
Is there a way that we can browse the data here?
Oracle Apps 11i - Limited Memory Usage?
Nov 5, 2012We are running Oracle Apps 11i on Windows 2003 R2 Enterprise SP2 (32 bit). After enabling /3GB switch parameter in Boot.ini file, the OS recognizes the 8GB RAM and consumes it upto 5.6GB during non-peak hours but as workload increases in evening when end users generate auto receipts the same memory usage ratio reaches upto 6GB resulting the OS gets hang and don't respond at all. Inspite of having 2GB free memory it doesn't consume it. We have to shut down it by pressing the power off button and restart it
The system configuration is as under:
HP ProLiant DL380 G6
Intel Xeon 2.4 GHz
8GB RAM (4 x 2 GB)
Forms :: Oracle Apps 11i To Use Text_io Function
Dec 21, 2010We create a form on 6i then deploye it on our Oracle apps Server with EBS and forms 11i Linux based. I want to create a form using form 6i which read a text file from client side and insert data into table i try text_io function but its not working after deployed on server and also try webutil function but its not working with oracle forms 6i.
View 6 Replies View RelatedBitmap (PDF / XML) Printing In Duplex Mode From Oracle Apps
Mar 16, 2011I am running oracle Apps 11.5.10.2, trying to enable duplex printing for all PDF / XML reports.
View 1 Replies View RelatedForms :: Download / Upload To Excel Through 6i In Oracle Apps
Nov 24, 2010download / upload data from / to database through oracle forms 6i which is deployed in oracle apps 11i.I am using DDE/OLE2 but it is downloading if form is stand alone but when i post this form in my UNIX server, it is not downloading.
Oracle apps is in UNIX and i want excel to be in client (windows).what procedure to be used.
Reports & Discoverer :: How To Create Bar Code In 2.5 (Oracle Apps 10.7 Char)
Apr 4, 2006Printing a bar code (such as a pick slip number e.g. 223456) in Oracle Applications 10.7 char, reports 2.5 on a genicom (dot matrix)..I was unable to find any fonts for this when I searched.
View 3 Replies View RelatedForms :: How To Enable / Disable Keyboard Shortcuts In Oracle Apps
May 12, 2010How do we need to enable or disable the keyboard shortcuts in Oracle Apps like Shift+F6 for duplicate record, also how do I change the functionality, I mean suppose I want Key-M to do the same function as shift+F6.
View 2 Replies View RelatedForms :: Develop A Custom Form Which Is Not Related To Oracle Apps
Oct 15, 2010I wanted to develop a custom form which is not related to oracle apps. I don't want to login to oracle and use the form. I wanted it to be like standalone form (use it as a tool) where I can automate the process of migrating the code from one instance to another, on click of button. Can I create standalone form and run without logging to oracle?
View 1 Replies View RelatedForms :: New Form For Oracle Apps Turning Fields In Other Forms Black
Sep 23, 2011I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.
Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.
Reports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer
Mar 19, 2012When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.
View 3 Replies View RelatedForms :: How To Upload Image In 6i In Apps
Jan 18, 2011I have upload an image in forms6i, in oracle apps
On button press event, code is...
DECLARE
V1_PATH VARCHAR2(50);
BEGIN
V1_path := get_file_name('C:IMAGE', NULL,
file_filter=> 'JPEG Image (*.JPG,*.JPEG,*.JPE,*.JFIF)|*.JPG|Bitmap Image (*.bmp)|*.bmp|GIF Image (*.GIF)|*.GIF|TIFF Files (*.tif)|*.tif|All Files (*.*)|*.*|');
DECLARE
[code]....
But it giving error message when preesing the button i.e. FRM-47105: NO image name specified.
Forms :: Test Legacy Apps Built Using Reports 6i On Windows 7?
Jul 21, 2012I still have a legacy apps built using Forms 6i and Reports 6i running against Oracle 10g database on a Windows XP client and Windows 2008 server.It seems working well on Windows 7 client (32-bit only), but I think that it needs to test this apps.
View 11 Replies View RelatedBackup & Recovery :: Error While Backup On Windows 7 Client Of Oracle 11gR2 Database
May 2, 2011I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.
On Database Server
SQL> create directory win_expdp_dir as 'd:expimp';
Directory created.
SQL> grant read, write on directory win_expdp_dir to lab;
Grant succeeded.
On Windows 7 machine (client machine)
D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.
Backup & Recovery :: Backing Up / Restoring Oracle Database Via Entire Backup Of Server
Aug 7, 2012I've read a lot about the different types of backup available with Oracle (hot and cold backup). However, I was thinking of a different way of performing this task. I'm currently using Windows Server 2008 R2 and Oracle 11g Standard Edition. I'd like to schedule an entire backup of my server via the utility "Windows Server Backup" (available for free).That way, I could recover my entire server with all the programs and files in case the latter crashes.I'm wondering if this solution could be used as a way of backing up (and recovering) the Oracle database. Should I still set up a regular hot backup with the Archivelog mode enabled in case some operations/transactions were being done at the time of the crash (for the data integrity)?
View 2 Replies View RelatedMobile Server :: Deploy Existing Apps Design For Win Mob 6 On Windows 8 Phone
Mar 9, 2013It looks that windows mobile is gone and windows 8 is available.. Can a vb .net application developed to run on win mobile 6 with oracle lite be deployed on windows 8 phone.
View 3 Replies View RelatedBackup & Recovery :: Why Oracle Generates One More Backup Piece On One Backupset
Nov 11, 2011I set 'maxopenfiles 4' when allocating channel to sbt in my products env, I got 2 backup pieces in one backup set because that tablespace has 7 datafiles. Other configuration is kept as default, such as no maxsize, no MAXPIECESIZE, and etc setting.
I read document from Oracle. It says:"By default a backup set contains one backup piece. To restrict the size of each backup piece, specify the MAXPIECESIZE option of the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands. " And also, maxopenfiles configure does not force another backup piece generated. So, why do I get another backup piece?
BTW, I tried this on another testing environment. I only get one backup piece even there are more than 2 times maxopnefiles datafiles.
Backup & Recovery :: RMAN Backup Oracle 10g To Be Restored On 11g
Jul 31, 2012I have the RMAN full database backup of oracle 10g (10.2.0.3) on Sun Solaris OS which i want to restore on oracle 11g (11.2.0.3) on Linux OS. The backup pieces was transferred to oracle 11g server manually in binary mode.
-rwxrwxr-x 1 mepc dba 36356096 Jul 16 14:49 snapcf_MEPC.f
-rwxrwxr-x 1 mepc dba 166028800 Jul 16 15:29 MEPC_full_backup_MEPC_nnnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 169567744 Jul 16 15:29 MEPC_full_backup_MEPC_nmnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 164813824 Jul 16 15:39 MEPC_full_backup_MEPC_nonbkn9f_1_1
-rwxrwxr-x 1 mepc dba 144025600 Jul 16 16:06 MEPC_full_backup_MEPC_nqnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 168576512 Jul 16 16:09 MEPC_full_backup_MEPC_npnbkn9f_1_1
-rwxrwxr-x 1 mepc dba 168649216 Jul 16 17:33 MEPC_full_backup_MEPC_o5nbkpvv_1_1
[code]....
the backup is taken in above format. I know the ORACLE_SID and dbid of the database from which the backup has been taken. whenever i tried the following command
mepc@tcstctmatson:/mepc_backup/May22fullbkp$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 31 12:14:54 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: MEPC (DBID=1595278680)
RMAN> shutdown;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started) Oracle instance started
Total System Global Area 1071333376 bytes
Fixed Size 1349732 bytes
Variable Size 620758940 bytes
Database Buffers 444596224 bytes
Redo Buffers 4628480 bytes
[code]....
the file is not corrupted as i checked the checksum on both the servers and it is same.how can i restore the RMAN oracle 10g backup in Oracle 11g.
Backup & Recovery :: Does Oracle Write Any Specify Value To Front Of Every Backup
Nov 7, 2011When you create a backup in SQL Server, whether the backup is on disk or on tape, SQL Server writes the letters TAPE to the first four bytes of the backup. Does Oracle write any specify value to the front of every backup, and if so, what are the first four bytes?
View 2 Replies View RelatedBackup & Recovery :: What %N Determines In Oracle RMAN Backup
May 23, 2012what is %N determines in Oracle RMAN HOT Backup. In some documentation it says it gives you backup with respect to tablespace. Is it a version specific ..bcos when tried in above version it failed....
View 4 Replies View RelatedBackup & Recovery :: Hot Backup Mode - Forgot Put End In Oracle 11g R2?
May 24, 2012I have a scenario like while taking the hot backup i forgot put end backup mode,at the same time one of user u1 updating some lacks of recordsinto the T1 table.at some time he wants rollback.and my redolog file size is very less.is it possible to rollback? if yes how?
View 3 Replies View RelatedBackup & Recovery :: SCN Based Backup Do RMAN Generate Backup From Archivelogs
Oct 18, 2012understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???
View 1 Replies View RelatedBackup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile
Jan 24, 2011I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am
other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)
if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)
I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)
Backup API For Oracle?
Sep 24, 2009I am currently reading some articles/documents to backup and restore Oracle databases. I found that Oracle databases can be backed either up by RMAN('Recovery Manager' tool supplied by oracle) or doing a "Hot Backup" (bring the database to backup mode and then copying the Physical datafile by issuing operating system "copy" command). The above methods do not meet my needs. I want to backup Orcale databases via my own application and I use C++. Hence, I am searching for an API that can be used with C++ to backup the Oracle databases.
Is there any API to backup the Oracle database that we can integrate with our own application program? [Like , To backup SQL Server Database , we can use VDI(virtual Device Interface) API to backup the SQL server database]
Restoring Oracle Backup
Jul 12, 2011My boss gave me a 1GB Oracle .dmp file, and I told him that I could handle it easily (ie, install Oracle on a machine, import the .dmp file, and export / move it onto a MS SQL server).
Oracle has turned out to be far more difficult to learn than I originally thought, however. Even after a week of reading search results and watching YouTube videos, I still feel completely in the dark.
Restoring an Oracle backup? (Once the backup is restored, that should be it - I have an ETL tool (Scribe Insight) for reading an Oracle database and moving it to SQL. I can use GoToMeeting for screen sharing.)
Backup And Restore Don't Work In Oracle
Mar 22, 2011I try this for backup:
$ exp scott/tiger FULL=y FILE='d:\demo.dmp';
and this for restore:
$ imp scott/tiger FULL=y FILE='d:\demo.dmp';
and after restore i can't see the data in my tables. (i work on Oracle 11.2.0 64bit)
ShadowProtect To Backup Oracle Databases?
Mar 22, 2013if you are using ShadowProtect to backup your Oracle databases. What are your experiences and the pros and cons in using ShadowProtect as the one and only backup/recovery tools for Oracle databases? Can the potential of ShadowProtect replaces the commonly use Oracle backup/recovery tools?
The reason why I raise this question is because my boss has the idea that ShadowProtect is THE best backup/recovery tools. Personally I don't think so, because there can be cases where we only need to recover the database and not the whole OS.
Oracle - SQL Query For Number Of Days Since Last Backup
Oct 20, 2011Is there any Oracle query I can run to determine the "number of days since the last backup"? SQL Server provides this data but I cant seem to find the equivalent for Oracle. Looks like there may be some information like this via RMAN tables and if so I want to create the simplest query possible to obtain that information.
View 3 Replies View RelatedBackup Oracle Database Using RMAN Utility?
Feb 13, 2012I'm going to backup this un-maintained Oracle 11g server in my office. I'm being told it's never been backed up and extremely critical to our success so tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:
[oracle@db1 ~]$ rman target=/
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 13:18:05 2012
connected to target database: CQDB (DBID=1854033249)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
BACKUP DATABASET FORMAT �/oracle/u01/app/oracle/backup/%d-%T-%s-%P�;
My question is the above sufficient for a safe full backup? We only have the one single target database called 'cqdb' which houses several schemas. Can you tell me if this is correct? I've shut the database down so it's in a cold state so I don't think I need to configure the FRA (Flash / Fast Recovery Area) but I honestly don't know. This is my 2nd time on a Oracle DBMS.
What about the 'archivelog' files? Do I back those up? Do I need them in case a recovery? Also what about the 'controlfile'? Do I need to back those up as well as the mentioned above?