ORA – 00202 Oracle Problem with Control File

ORA-00202: controlfile: ‘C:\ORACLE\ORADATA\ORACLE91\CONTROL02.CTL’ ORA-27091: skgfqio: unable to queue I/O ORA-27070: skgfdisp: async read/write failed OSD-04006: ReadFile() failure, unable to read from file O/S-Error: (OS 23) Data error (cyclic redundancy check). i find this problem on one of my server database. this problem will make oracle fail to mount and open. if you try to connect [...]

Error When exporting data from Oracle DB 9i 9.2.0.5

When exporting data from Oracle DB 9i 9.2.0.5, encountered by the error: . exporting pre-schema procedural objects and actions . exporting foreign function library names for user QLNS . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user QLNS EXP-00008: ORACLE error 942 encountered ORA-00942: table or view [...]

Get & set NLS_LANG_XXX from / to Oracle DB

1. To get currently used character set, issue: SELECT * FROM nls_database_parameters WHERE parameter LIKE ‘%CHARACTERSET%’. nls_database_parameters is a view. 2. Check and update, for example, to set nls_characterset = UTF8,nls_nchar_characterset = UTF8, use table props$: UPDATE props$ SET value$ = ‘UTF8′ WHERE NAME LIKE ‘%CHARACTERSET%; commit; There you go… Minh Tran

How to change the IAS_Admin password (Oracle 9i)

If you want to change the IAS_Admin password, you need to delete the <credentials> line associated with ias_admin in the jazn_data.xml file. However, you would need to shut down the EMWebsite prior to doing this. .Edit the following file and locate the line that defines the credentials property for use the ias_admin user: %ORACLE_HOME%\sysman\j2ee\config\jazn-data.xml The [...]