Upload TEXT file in Oracle Database

How to upload TEXT file in Oracle Database

Eg: Text file:

Eg: Control file:

Note: Control file you can see the above.

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected

Dear Friends,

If your getting below "Warning" message frequently in the alert.log file...

"WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected."

Kindly check the following metalink note: 428441.1

Solution: The parameter "AQ_TM_PROCESSES" should not be set "0" or "Unset". Set it atlest for "1".

It is dynamic parameter so no need to bounce the db server.

SQL>alter system set AQ_TM_PROCESSES=1;

WARNING: inbound connection timed out (ORA-3136)

When you see below error in the alert.log file reguraly

"WARNING: inbound connection timed out (ORA-3136)"

Reason & Explanation: Metalink Note: 465043.1

NOTE: It is normal warnings message , can be ignored.

Solution: set the following parameter in the sqlnet.ora / listener.ora file

Both parameter will be set in the 'SERVER' side.

In the sqlnet.ora

SQLNET.INBOUND_CONNECT_TIMEOUT = 120

In the listener.ora

INBOUND_CONNECT_TIMEOUT_LISTENER = 110

Control Files Problem: Ora-202, Ora-27037, Vms Error 2, Ora-205 During Startup

If your getting "Control Files Problem: Ora-202, Ora-27037, Vms Error 2, Ora-205 During Startup" error during startup the database.

Error Description from alert.log file

ORA-00202: control file: '/db/app/oracle/Db_1/oradata/orcl/control01.ctl*.core_dump_dest='ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directory

Reason: Check metalink NOTE:300064.1

Solution: "Shutdown" the database and open new sqlplus session and startup.

ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

One of our Production database we are getting following ORA-00600 error

OS: Windows 2003

DB: 10.2.0.4.0 (Jan-09 CPU Applied)

ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

Solution:

There is no solution yet on metalink...

Kindly submit "Trace Files" & "Alert Log" to Oracle Support

Above Error Fixed In the 11.2 Version

Metalink Note: 756784.1

Temporary Workaround:

If

An ORA-600 can occur while recompiling stored PLSQL if a procedure / function argument name matches to a columnname referred to in that function / procedure .

Then

Change the Function/procedure's argument name so that it does not match to any column name being referred in the function/procedure body.

Database Created as 32bit Or 64bit Platform

We can check the Database Created as 32bit Or 64bit Platform through below sql query

SQL> select metadata from sys.kopm$ ;
METADATA

-----------------------------------------------------------0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405
0607080823472323081123081141B023008300B207D0030000000000000000000000000000000000
0000000000000000000000000000000000000000

If above Colored Character Is "B023" means 32bit

Or

If it is "B047" means 64bit.

Thanks.