Oracle 10

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. Software/Hardware used: Oracle 10g

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...

About Oracle Forms & Reports

I am beginner of forms and reports.i need basic coding site for forms and reports pls anyone help me

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...

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?

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 ...

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...

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 what...

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?

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...

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?

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 is not...

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...

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...