20/04/2018 11:47

LINE/COL ERROR-------------------------------------------------------------------------57/2 PLS-00103: Encountered the symbol ALTER when expecting oneof the following: begin case declare exit.... read more
1 answersclick here to view
19/04/2018 11:47

both IAS & Infra in same server, one Database.
It used to be running, but today it won't start.
Here is the error : Application Server Control : Status = DownFarm=Infrastructure database is unavailable(but using sqlplus, I have succesfully log-in into that'Infrastructure database') Components : Forms -> UnavailableOC4J_BI_Forms -> UnavailableReports Server: rep_sysloginfra -> Status = [inprogress,.... read more
3 answersclick here to view
18/04/2018 11:47

Roughly, the Bakery has 120 Shops.
Each Bakery has about 500 Customers per DayEach customer buys 2 Different Items in Average. There are about 100different Items.
so this makes120*500*2 = 120000 Items bought per day120000*6 = 720000 per week720000*50 =36.000.000 per Year with 300 buisness days Raw data is delivered in the fo.... read more
3 answersclick here to view
17/04/2018 11:47

Ok, I have no clue about where to start. I grabbed a script ofMetalink and tried to compile it and received the following errors: 9/22 PLS-00201: identifier 'DBMS_LDAP.SESSION' must be declared9/22 PL/SQL: Item ignored10/22 PLS-00201: identifier 'DBMS_LDAP_UTL.PROPERTY_SET_COLLECTION'must be declared 10/22 PL/SQL: Item ignored11/22 PLS-00201: identifier 'DBMS_LDAP.STRING_COLLECTION' must bedeclared .... read more
1 answersclick here to view
16/04/2018 11:47

Next i tried to verify the switchover operation using the dataguardmanager GUI.
During the switchover process an error occured (Exception Cobrasomething). After this my management server service is not starting andwhen I try to connect to the primary database the error Ora-0103: Oracle .... read more
1 answersclick here to view
15/04/2018 11:47

2 answersclick here to view
13/04/2018 11:47

In Oracle 9i, it was recommanded that the Archive Log folder (disk)should be doifferent from the folder (disk) for storing the RMANfiles. But in 10g, it looks like they are to be kept inflash_recovery_area. Is this contradict what it should be definedbefore ? Also there is maximum size definition of the flash_recovery_area.
Should I defined the total size of th.... read more
7 answersclick here to view
12/04/2018 11:47

2 answersclick here to view
11/04/2018 11:47

Thus, you should c.... read more
6 answersclick here to view
10/04/2018 11:47

I am leaning towards the ET because it will eliminate the need for astaging table that we use on the sql loader method.
10 answersclick here to view
09/04/2018 11:47

5 answersclick here to view
08/04/2018 11:47

I'm building a web app using Oracle 10g (NOT AS) and PL/SQL. It's fairlysimple: a few packages producing web forms and pages writing/reading datato/from my tables.
I'm trying now to figure out what are my options for managing authenticatedaccess to some of my procedures.
I'd like to use db authentication (Oracle username/password), but I've neverdone this before: I browsed the Internet and the docs but couldn't clear upmy mind.
My questions are: 1) can I do d.... read more
8 answersclick here to view
07/04/2018 11:47

But i have a problem with the connection to the Db, infact when i openthe database i have this error on oracle Db: ORA-12505: TNS:listner does not currently know of SID given in connectdescriptor (DBD ERROR: OCI ServerAttach) and my software connect to datab.... read more
16 answersclick here to view
05/04/2018 11:47

I have a database server which has a failover server.
There is suspicion that the failover server may have been omitted in acouple of instances when we applied patches to the production server.
We did not use OPatch to apply these patches.
Is there a way to confirm between the two servers which patches havebeen applied, so we can establish whether they are indeed out of sync? Thanks! DW
2 answersclick here to view
Databases
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.
Search eDiscover