1
Oracle10g,VB6.0,dell-laptop,connection error
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?
Answer Question
| October 26, 2012 1:05 PM
Dell, Oracle 10, VB 6.0
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?
Answer Question
| October 26, 2012 1:05 PM
Dell, Oracle 10, VB 6.0
Can I direct query the Oracle database with SQL Plus?
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 ?
Answer Question
| November 18, 2010 8:23 AM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
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 ?
Answer Question
| November 18, 2010 8:23 AM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix
Crystal Reports 8.5 Cannot insert Field or Text Objects
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 [...]
Answer Question
| November 24, 2011 9:13 PM
Crystal Reports 8.5, Crystal Reports error messages, Crystal Reports Errors, Oracle 10, Windows XP
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 [...]
Answer Question
| November 24, 2011 9:13 PM
Crystal Reports 8.5, Crystal Reports error messages, Crystal Reports Errors, Oracle 10, Windows XP
error in alert.log in oracle 10.2.0.3
ERROR IN KQLMBIVG SEE LCK TRACE FILE —error is there in alert.log file
Answer Question
| June 7, 2010 9:25 AM
Linux error messages, Oracle 10, Oracle 10.2.0.3, Oracle error messages
ERROR IN KQLMBIVG SEE LCK TRACE FILE —error is there in alert.log file
Answer Question
| June 7, 2010 9:25 AM
Linux error messages, Oracle 10, Oracle 10.2.0.3, Oracle error messages
I would like to install Oracle database on OS X MacBook
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. [...]
Answer Question
| April 20, 2010 6:23 PM
Mac OS X, Oracle 10, Oracle 10.2.0.4, Oracle Database Versions
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. [...]
Answer Question
| April 20, 2010 6:23 PM
Mac OS X, Oracle 10, Oracle 10.2.0.4, Oracle Database Versions
Oracle usernames
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.
Answer Question
| October 27, 2009 2:37 PM
Oracle 10, Oracle User Profiles, username
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.
Answer Question
| October 27, 2009 2:37 PM
Oracle 10, Oracle User Profiles, username
Oracle: Can a character set be changed after a schema has been created?
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 [...]
Answer Question
| October 22, 2009 3:06 PM
Oracle 10, Oracle 10.2.0.1.0
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 [...]
Answer Question
| October 22, 2009 3:06 PM
Oracle 10, Oracle 10.2.0.1.0
About Oracle Forms & Reports
I am beginner of forms and reports.i need basic coding site for forms and reports pls anyone help me
Answer Question
| July 22, 2009 7:20 AM
Oracle 10, Oracle Forms, Oracle Reports
I am beginner of forms and reports.i need basic coding site for forms and reports pls anyone help me
Answer Question
| July 22, 2009 7:20 AM
Oracle 10, Oracle Forms, Oracle Reports
java.lang.NoClassDefFoundError
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) [...]
Answer Question
| November 9, 2012 11:40 PM
Java development, JDeveloper, Oracle 10, Oracle Application Server, Oracle development, Oracle JDeveloper, Web development
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) [...]
Answer Question
| November 9, 2012 11:40 PM
Java development, JDeveloper, Oracle 10, Oracle Application Server, Oracle development, Oracle JDeveloper, Web development
How to begin tracing a connection Oracle 10.2.0.3 server running on Solaris 10
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?
Answer Question
| August 21, 2008 3:49 PM
Oracle 10, Solaris 10
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?
Answer Question
| August 21, 2008 3:49 PM
Oracle 10, Solaris 10
Need help with a slow pl/sql script
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 [...]
Answer Question
| June 17, 2008 11:00 AM
Oracle 10, PL, PL/SQL, script, SQL
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 [...]
Answer Question
| June 17, 2008 11:00 AM
Oracle 10, PL, PL/SQL, script, SQL
Options available for implementing external account authentication with Windows AD with Oracle 10.2.0.3 on Linux
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 [...]
Answer Question
| April 23, 2008 5:17 PM
Active Directory, Linux, Oracle 10, Oracle 10.2.0.3, Oracle Internet Directory
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 [...]
Answer Question
| April 23, 2008 5:17 PM
Active Directory, Linux, Oracle 10, Oracle 10.2.0.3, Oracle Internet Directory
ASM State in GMON Trace File
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 [...]
Answer Question
| April 14, 2008 2:39 PM
ASM, GMON, Oracle 10, Oracle administration, Red Hat Enterprise 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 [...]
Answer Question
| April 14, 2008 2:39 PM
ASM, GMON, Oracle 10, Oracle administration, Red Hat Enterprise Linux
Where does Oracle automatic backup create the backup file?
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?
Answer Question
| September 9, 2011 3:18 PM
DBCA, Flash Recovery, Oracle 10, Oracle backup
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?
Answer Question
| September 9, 2011 3:18 PM
DBCA, Flash Recovery, Oracle 10, Oracle backup
Export Oracle 10g and Import to Oracle 9i
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 [...]
Answer Question
| December 16, 2009 7:36 PM
Data warehouse, Oracle 10, Oracle 9, Oracle import/export, Red Hat Enterprise Linux
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 [...]
Answer Question
| December 16, 2009 7:36 PM
Data warehouse, Oracle 10, Oracle 9, Oracle import/export, Red Hat Enterprise Linux
Oracle 10.2.0.2 on AIX5L
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?
Answer Question
| March 6, 2008 7:45 PM
AIX, AIX 5L, Oracle 10
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?
Answer Question
| March 6, 2008 7:45 PM
AIX, AIX 5L, Oracle 10
Parameter file
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 [...]
Answer Question
| December 18, 2007 12:36 PM
EM DB Control, Oracle 10, Oracle 10g, Oracle Enterprise Manager
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 [...]
Answer Question
| December 18, 2007 12:36 PM
EM DB Control, Oracle 10, Oracle 10g, Oracle Enterprise Manager
Why numeric data truncated to be integer when declaring NUMBER data type in Oracle 10g
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 [...]
Answer Question
| December 3, 2007 9:55 PM
Oracle 10, Oracle NUMBER data type
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 [...]
Answer Question
| December 3, 2007 9:55 PM
Oracle 10, Oracle NUMBER data type
Tracing on Oracle 10
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 [...]
Answer Question
| October 5, 2007 3:00 PM
Oracle, Oracle 10
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 [...]
Answer Question
| October 5, 2007 3:00 PM
Oracle, Oracle 10
1
