Forms :: Using Online Software Developed By Oracle 6i And 10g XE?
Oct 10, 2012I developed an Point of sales software using developer 6i and database 10g XE.Now I want to use this software online. Can I do it ? If it is, then how?
View 1 Replies
ADVERTISEMENT
Forms :: Run Report Developed By Crystal Reports By Click On Button In Oracle Developer 6i?
Dec 19, 2011I want to run a report developed by crystal reports by click on a button in oracle developer 6i.
Is it possible. If yes then how can i do this.
SQL & PL/SQL :: How To Connect Oracle 10g Database Through Online
Dec 8, 2011how to connect oracle database through online
View 8 Replies View RelatedApplication Express :: How To Get Online With Oracle
Dec 17, 2012I am going for a presentation at my University. But the students are not very interested in Oracle or Databases. So I need a title for the Apex topic which gets the other students to visit my presentation.
The presentation should show the basics of apex and how to earn money with this.I thought of:
1) Oracle in the world of Web 2.0
2) How to get online with Oracle
3) What to show if some1 tells you Access is a Database
4) Oracle in a drag and drop environment even for developers
5) Best of Breed: Oracle SQL / PL/SQL, HTML, XML and Java in a nutshell
Recovery Manager (RMAN) :: Online Backup Scripts For Oracle 11g On Windows?
Jul 25, 2013,I am new to Oracle database administration i am working on a 24*7 tool .the tool will work as a non stop.this is a standalone tool.there wont be any one who will be taking care of the database.I need to design a backup statergyNeed to take backups on timly basis.Since the database can't be go offline cold backup's can not be useenhot backup needs to implemented.what are steps needs to do for hot backup.Is there are some pre defined scripts to run the backup.
View 6 Replies View RelatedApplication Express :: Import App Developed In 4.2 To 4.1
Mar 6, 2013I imported my application that i've been developing in 4.1 into 4.2 apex.oracle. I didn't realize it's only forward compatible so when I tried to import back to 4.1, i wasn't able to.
Is there any way I can import the app back to apex 4.1?
Reports & Discoverer :: Digits Conversion - Report Developed In Builder
Oct 9, 2012I am facing an issue here at my workplace, there is a report developed in report builder , the user wants to see the digits in arabic.
View 4 Replies View RelatedReports & Discoverer :: Developed Tabular Report In Builder 6i - Rep-1213 Error?
Dec 23, 2011I have developed a tabular report in report builder 6i. Total columns in report 28 in all. Now its throwing following error.
REP-1213: Field 'F_orpahn_Code'references column 'orphan_code'at a frequence below its group
Status Online Logfile
Nov 2, 2010I delete member logfile from disk with statement: shred -fu /u01/app/oracle/redologs/activeredolog/DB1/redo0102.log
But if I check status one logfile with statement:
select status from v$logfile wheremember='/u01/app/oracle/redologs/activeredolog/DB1/redo0102.log';
Status is still null. I think status should be change.
My database is 11.2.0.1 with single instance.
Status is changed after restart instance.
Haw can I monitor status logfiles without restart instance?
SQL & PL/SQL :: Online Shopping Catalog System
Jan 24, 2013Including order number, name and contact details (email, address, telephones) of customer and date the order was placed, order including product code, quantity ordered and cost charged; and Data on each product in the catalog including product code, name, description, unit price and category.
user to input information n number of order items (where 1 ≤ n ≤ 20) as parameters
a cursor to handle the multiple orders retrieved.
Online Gathering Statistics For A Schema
Dec 24, 2012Is it possible to gather stats for a schema which its in use. When i try to analyze the tables of a schema it shows that the statistics for that table is locked. So is it possible that instead of analyzing a table one by one , can i go for gathering the Schema stats while the objects of that Schema is still in use ( like DML or select statements being issued on those schema objects) .
DB version : 10.2.0.4
OS version : RHEL 5.8
DB type : RAC
RAC & Failsafe :: Single Node - Online / Offline
Dec 5, 2012I have implemented Rac One node with two machine(dbtest01,dbtest02) in 11.2.0.3 Redhat 5.3 one for online another one for offline. i have created TAF also.
dbtest01 is online and create one query
DECLARE
i number(36):=1;
begin
while(i<10000000)
loop
dbms_output.put_line(i);
i:=i+1;
end loop;
end;
i executed above query for test and i made relocate database using srvctl utility to dbtest02 machine.
session is relocated successfully with new session id...above query getting stop in 25000 itself. i want to make it continue that process..also i tried to find Omotion utility in all the path.. couldn't find it... where will it be.. i want to relocate all the session without losing work.
from application i am getting disconnect after relocation.. application server need to restart to get work again...
Separate ASM Diskgroup For Online Redo Logs
Sep 25, 2013Version: 11.2.0.3Platform : Solaris 10
One of the Hitachi support guy has suggested to create a separate disk group for Online redo logs. His rationale was that ORLs was write only files and it would be better to put in a separate disk group.
Server Utilities :: Running Export Utility Online
May 26, 2010Just want to confirm if I can run the export (command line) even if the database is up (online)? Are there any risks/impact while doing so?
View 7 Replies View RelatedClient Tools :: Sql Developer Online Data Move
Dec 1, 2011I am using SQL developer 2.1 to migrate tables from Sybase 12 database to oracle 11g. I have used online data move option for moving sybase data into oracle tables, but even after data move is completed not all rows have been moved from sybase tables to corresponding oracle tables. Some rows are missing but still there is no error message being displayed, how to find out what's going wrong.
View 3 Replies View RelatedData Guard :: Does Standby Redologs Are Applied Online To Datafile
Jul 20, 2011Till now i was pretty sure that standby redologs are applied to database without any delay, but everything looks that the process is different. i did on primary server table and add some records to this table.
Next i switch to standby and open redologs (with hex editor) to look for this "create table" and "insert" commands. and i succeeded. so this is prove that standby log are supplied by primary database.
Next i cancelled recovery process and open database in read only mode and there was no records in this standby db, moreover there wasn't any table on standby. so i started to be confused, because i suspected that this table and it content will be on standby database.
Next i started recover process again for standby database and do some switch log on primary server. after that i back to standby, cancel recovery process and open database in read only mode. there was table and contents for it.
so my question is:
does standby redologs should be applied online to database or they are only applied after promoting standby database to primary database?
it looks like contents only from archivelog is applied to standby database. it is correct?
database is 9i.
Backup & Recovery :: Create Online Back Up Of Database Using RMAN?
Dec 23, 2011How can i create an oline back up of database using RMAN?
View 1 Replies View RelatedSQL & PL/SQL :: Change Datatype Of Column In Table Online Using DBMS REDEFINITION?
Aug 8, 2011Is it possible to change the datatype of a column in a table online, using DBMS_REDEFINITION?
If Yes, then which of the options will be used with DBMS_REDEFINITION package?
Data Guard :: How To Add Both Online And Redo Log Files To Standby Database
Sep 13, 2011I've only successfully duplicate a standby database.
from the alert log
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:ORA102CTAREDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
[code].....
when I tried to add the online and standby redo log, it error out
SYS@CTA>select logdetail.member, loggroup.group#, loggroup.sequence#, loggroup.archived, loggroup.status lg_status, logdetail.status ld_detail, logdetail.type
2 from v$log loggroup join v$logfile logdetail
3 on loggroup.group# = logdetail.group#;
MEMBER
--------------------------------------------------------------------------------
GROUP# SEQUENCE# ARC LG_STATUS LD_DETA TYPE
---------- ---------- --- ---------------- ------- -------
[code].....
based on my understanding from [URL] ....
Quote:
As part of the duplicating operation, RMAN automates the following steps:
Creates a control file for the duplicate database
Restores the target datafiles to the duplicate database and performs incomplete recovery by using all available incremental backups and archived redo logs
Shuts down and starts the auxiliary instance (refer to "Task 4: Start the Auxiliary Instance" for issues relating to client-side versus server-side initialization parameter files)
Opens the duplicate database with the RESETLOGS option after incomplete recovery to create the online redo logs (except when running DUPLICATE ... FOR STANDBY, in which case RMAN does not open the database) when duplicating for standby database it does not create online redo logs. Duplicating a standby database does not creates online redo logs.
how should I add the online and standby redo logs. If I transfer the redo logs from primary to standby, it always encountered the the following error
Dump file d:ora102ctadumpcta_arc0_3624.trc
Tue Sep 13 19:21:53 2011
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 2
[code].....
Commit Completes Although Current Online Redo Log File Have Been Removed
Apr 10, 2013Although i have removed current online redo log file in linux os (Oracle Linux),when i type "commit" it says that "commit complete".
Is this fair for this princip?*:" if Only when all redo records associated with a given transaction are safely on disk in the online logs is the user process notified that the transaction has been committed."*
I think that it can lead to loss of data in some cases..I'm using Oracle 11g R2 on OEL (x64)..
P.S : I haven't multiplexed current ORL group files...
Open Resetlogs Is Not Working When Creating Clone DB With Online Backup
Jun 3, 2013I am trying to create a clone database using hot backup of a database .
STEPS THAT I FOLLOWED
------------------------------------
LET ----- >CURRENT_DB NAME=DEV
CLONE DATABASE NAME=DEVCLONE
steps PERFORMED FORM DEV DB
-----------------------------------------------
- put the database in backup mode using 'alter database begin backup'
- copy all the data files to a different folder
- during copy i have performed some operations on the DB (creating users, tables, dmls etc...)
- in between copying i also performed log switch
- after completion of copy , "alter database end backup"
- created a backup control file in a human readable format (alter database backup controlfile to trace as ........)
steps performed for clone DB side ((DEVCLONE)
-------------------------------------------------------------------
- created a parameter file for the database .
- modified the backup control file so that it will point to the location of copied destination of datafiles
- set the ORACLE_SID
- then 'sqlplus / as sysdba
- starup nomount
- run the modified control file ( created a control file for the clone database)
- recover the database using "recover database using backup controlfile"
I have provided the archive files that it was asking for (archive logs that has been generated in DEV DB)
then i canceled the recovery by typing "cancel"
- recover database using backup controlfile until cancel;
then typed "cancel"
- then try to open the database with open resetlogs but it showed below error
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:DATA_GUARDDEVHOTSYSTEM01.DBF'
Resize Online Redolog Files And Make RMAN Absolute Backups As Usable?
Jun 19, 2013why can not we resize online redolog files instead of re-creating the same with large size and remove the older onces.2. How can we make RMAN obsolute backups as usable ?
View 8 Replies View RelatedRMAN :: Configured Recovery Catalog / Started Full Online Backup Using EMC Networker
Nov 27, 2012I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
My question is, if I need to restore Backup of last 15 days then I can ?.
Backup & Recovery :: Does Full Cold Backup Of RMAN Include Online Redologs
Jan 8, 2013Does the full cold backup of rman include online redologs?
So that at the time of recovery when i restore the database the online redologs also restored to that point?
Backup & Recovery :: Taking Online Backup Of Full Database
Jan 29, 2011online backup done thru RMAN.Suppose i am taking online backup of full database. During the backup, user's are inserting/deleting/modifying data. This data is getting stored as online archives. Once the database backup is finished, how these archives are applied to the database to make the database up to date.
View 1 Replies View RelatedReal Application Clusters :: UDLM Rac-udlm-rs Failing To Come Online
Jul 1, 2013I'm setting up a zone cluster that will be running RAC. This has gone well, up to the point where, using clsetup, I attempt to create the rac-framework-rg (and associated rac-udlm-rs, rac-framework-rs). In attempting to create the resource group, the rac-udlm-rs fails to come online, causing the rest of the framework to fail.
The error in the log file for UDLM (/var/cluster/ucmm/dlm_<zone>/logs/dlm.log is:
CONNECT ERROR: 'Invalid argument', family=0, port= 6009, in=0.0.0.0
This repeats 5 times per second on both zone cluster nodes. regularly the error changes port (i.e. it cycles through the ports). I've tried rebuilding the zone cluster, to no avail. I am at a loss as to what the error might be, or where to start looking, since there is no evidence anyone has ever hit this error before.
Possibly related, or even the cause, is that the zone cluster has been configured with: add net address=xxx.xxx.xxx.xxxend at the zonecluster level, but these addresses are not showing up under 'ifconfig -a'. how they are used, and when they should show up though. Some notes:the zone cluster in all other respects seems fine - I have QFS resources configured and these appear to successfully work in all circumstances.the ORCLudlm package is installed (the one that comes with Oracle 11.2.0.3)
Performance Tuning :: Difference Between Index Rebuild And Index Rebuild Online?
Jan 10, 2011What is the difference between index rebuild and index rebuild online.
View 3 Replies View RelatedForms :: How To Send Mail To Lotus Notes With Attachment From Oracle Forms
Feb 7, 2011Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 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.
Forms :: Read / Write In Unix From Oracle Forms Installed In Windows
Nov 24, 2011I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.