I have a Dell-Inspiron. when I try to connect VB 6.0 and Oracle 10g, I get a TNS error. I have been getting this error for other dell laptops alone. What change should I make?
I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?
I have been using 8.5 for years without any problem. Recently I have been unable to create any new reports. I am not allowed to insert any field or text objects. I am also unable to modify any of the existing thousands of reports. I have reinstalled a number of times. It will work for [...]
ERROR IN KQLMBIVG SEE LCK TRACE FILE —error is there in alert.log file
I have looked in the Oracle Technet site for a version of Oracle suitable for OS X. I downloaded Oracle 10.2.0.4.0 because it said that it was compatible with Mac OS X. However, when I attempted to install the application, nothing happened. Upon closer look, the documentation seem to point to Max OS X server. [...]
I have installed Oracle but when I’m starting Oracle *Plus it is not accepting the username and password ‘scott and tiger’ and ‘system manager.’ It is also not accepting these user names and passwords.
My boss was so pleased with the response from this site that he asked me to ask another question! He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to [...]
I am beginner of forms and reports.i need basic coding site for forms and reports pls anyone help me
Hi, I need some serious help here..I use OAS 10.1.2.0.2.. I deployed my ear file to the OC4J container. And everytime I access the webpage I get this error. 500 Internal Server Error java.lang.ExceptionInInitializerError at com.experio.common.util.AppUtil.getInitialContext(AppUtil.java:71) at com.experio.common.util.AppUtil.createEJB(AppUtil.java:199) at com.experio.common.util.AppUtil.createEJB(AppUtil.java:156) at com.experio.common.util.Debug.println(Debug.java:64) at com.experio.web.control.Entry.service(Entry.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824) [...]
Developers are telling me a page loads more slowly on one server than another for the same query that is run. how can I trace this connection to find out what it is doing on both servers?
Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ———————————- spool noaddressusagerelfix.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES TableB.I_OCPOSTAD_USAGES%TYPE; vC_OCPOSTAD_USAGES TableB.C_OCPOSTAD_USAGES%TYPE; vpartyAddressUsageIValue TableB.I%TYPE; vpartyAddressUsageCValue TableB.C%TYPE; vCounter NUMBER(10):=0; CURSOR cursor1 IS SELECT C, I, I_OCPRTY_USAGES FROM TableB WHERE I_OCPOSTAD_USAGES IS NULL AND [...]
Scenario: Windows desktop user logs in to the Windows domain and is authenticated by Windows Active Directory. The same user then lauches a Citrix session to connect to an application running on a Windows Citrix server and is authenticated using Windows passthrough authentication. The application then connects to a remote Oracle 10.2.0.3 database on Linux [...]
Oracle 10.2.0.3 RAC using ASM: Red Hat Enterprise 2.6.9.44 (RHEL 4.4) I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says “Member state = 4″. What’s a member state and [...]
I have created one database through DBCA on Oracle 10.1.0.2.0 and choose automatic backup daily at 2 am. But I cannot see any backup that is done under Oracle flash recovery area. Does it create in any other place? No error message was found in alertlog. Any ideas?
I have a data warehouse server that’s running Redhat AS 2.1 and Oracle 9.2.0.4, and a production database that’s running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I know I need to [...]
we installed oracle 10.2.0.2 on AIX 5l, we heard that there are performance issues with indexing (Oracle may pick the wrong index) . Has anyone had similar experiences and if so, what patches have you applied to resolve the problem?
Hi I have installed Oracle 10g Win 2003 server, as I know there are 2 parameter files one is dynamic and other is static. how do I know that which parameter file is being used? If I go to EM DBcontrol “all Initialize parameter file” I can see SPFILE is disabled, means dynamic parameter file [...]
Hello, My company recently upgraded Oracle server form 9i to 10g and I was requested to load all tables data from 9i to 10g. Most data transfer are good except this situation: If 9i table with date type declared as NUMBER, all numeric data will be truncated as integer in 10g (I used the same [...]
Hi, In order to get tracing info on Oracle 9 I added the following to the SQLNET.ORA TRACE_UNIQUE_CLIENT=on TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = C:Oracle10Run TRACE_FILE_CLIENT = SQLNetTrace TRACE_TIMESTAMP_CLIENT = ON This worked fine and generated the relevant trace files. When I paste the same lines in SQLNET.ORA on Oracle 10 I doesn’t generate any Trace [...]





