Oracle 10g

Wait event LNS wait for LGWR redo ?

I have a PROD database 10gR2 with a physical standby database. In the TOP ten waits in AWR REPORT, there is the event"LNS wait for LGWR redo" which represents 25% of waits. Is there a relationship with standby or with only redo log ? This event is not documented .

upgrade from Oracle 9i to 10g

I am trying to upgrade a copy 9i Production database to 10g. Using DBUA tool. After selecting the DB for the past 20 hrs the process is still running with no progress. Alert log has the message on MMNL. What are the possible ways to upgrade a 9i DB to 10g. Have followed the oracle docwith no...

Link Oracle 10g with Sql server problem

i have created a link between our Oracle DB and SQL server db it was succussfulty created and i was able to select data from oracle table using SQLServer. then i have created a view in sqlserver using this link to read from Oracle, the view was created create view dah_test as ( SELECT count(*) as...

Error:1327 during installing orcale 10g

I downloaded 10g express edition and tried to install to windows xp. An error 1327:Invalid Driver:E\ prompted. There is no E drive at all. Not sure what is going on? Anyone could help?

Developer 10g

I want to connect my forms and reports of developer 10g to other data sources. e.g. Sql Server. How can i connect to it through odbc?

Clustering

I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

can VS 2005 support Oracle 10g?

can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

OpenLDAP and Oracle Database

Hi, This is a question related to Oracle and OpenLdap. Can anybody please tell me how to setup the Oracle [10g] to use the installed OpenLdap server. I know we need to use netca and use the internet directory services; But how to set Open Ldap is the question here. Your help is greatly appreciated!...

report server error using oracle 10g

Hi. I an using oracle 10g. when i run 10g reports individually it works fine but when i try it to connect with forms it gives error 'cannot connect toserver' please help how could i connect it to server.

ORA-12801 and ORA-01008 when running Oracle Reports

When I run the report from report builder I get following error ORA-12801: error signaled in parallel query server P001, instance db12:testdb(2) ORA-01008: Not all variables bound Any idea what could be the problem? Database is Oracle 10g.

How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?

I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created - as i can switch between them using the Home Selector. I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling me only...

Problem to transfer Proc C to Oracle 10g

Can you please tell me the procedure to run Proc C prpograms of Oracle 8i in Oracle 10g

TNS-03505: Failed to resolve name

HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve name my listerner.ora file is LISTENER= (DESCRIPTION_LIST = ...

CPU UTILIZATION IS SHOWING 0 IN SAR REPORT

Hi all I am facing problem on oracle 10g We have oracle 10g on solaries 5.9 We have database in RAC envinment with 2 nodes We have 10g AS as a front end application. My problem is when user fired user name and passwd the application page are coming very slow it is taking very much time...

Anyone Have Experiences With Running Oracle in a Sun Solaris Container/Zone

We are a SAP / Solaris environment. We thinking about virtualizing our SAP environments as part of our upgrade to ERP 6.0 using Solaris Zones/Containers. There are two schools of thought as far as the database instances; virtualize the Oracle instance along with the SAP instance or seperate the...

oracle 10g v sybase ase 15

what are the differences between the two products relating to cost, integration, database size, number of concurrent users, performance and features

BW load performance

BW data load performance using Oracle 10g and windows 2003 env. how to improve CPU, DB, dialog response time? any notes for Oracle patches, SAP any notes?

3 tier character report printing not possible in 10g

i made a character report in 10g , if i run in report builder then its printing is fine. but when i print report using 3 tier (using pdf format) then all setting are disturbed.

Nested SQL with multiple table join does not work with wildcard searches

Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving...

Migration from Oracle 8 to Oracle 10g

I have a database of 80MB in Oracle 8 and want to migate to 10g. OS is Solaris. Pl guide ?