Tuesday, December 20, 2011

Flex: Cannot upload larger files

I had a very strange problem with my file upload in flex. While it was working for smaller files, it threw weird errors for large files ( files greater than 30MB or so)

I got "Error #2038: File I/O Error." some times, and then "SecurityError: Error #2000: No active security context." error.

After some wild google chase, figured out that the problem was coming from IIS Server and Flex is not reporting the error correctly.


By default, IIS rejects files larger than 4MB or so, In order to fix this I used to add the following.

<system.web>
<httpRuntime maxRequestLength="102400" executionTimeout="600" />    <!-- 100mb ,10 min-->
</system.web>


but for IIS 6 or IIS 7, You also need a new section to allow large file uploads (100MB in my case)


    <system.webServer>
    <security>
      <requestFiltering>
        <requestLimits       maxAllowedContentLength="100000000"    />
      </requestFiltering>
    </security>   
  </system.webServer>

and this fixed it.

Monday, December 19, 2011

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

Launch SQL Plus from Oracle\bin folder ( not from Client folder)

SQL> conn sys/sys as sysdba
Connected to an idle instance.


SQL> startup mount;
ORACLE instance started.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []


SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.
Database mounted.

SQL> recover database;
Media recovery complete.

SQL> alter database open;
Database altered.

SQL> conn scott/tiger@orcldb
Connected.

Your database is good to go now, You better take a backup of your system.

Saturday, December 17, 2011

Plex Media Server: Unable to connect

Installed Plex Media server on Windows 7 Ultimate, and I always got unable to connect to localhost.

To fix, I just replaced Localhost in the URL with the IP Address as shown below, and it started working

So, I changed URL from

http://localhost:32400/manage

 to

http://127.0.1:32400/manage





Thursday, December 15, 2011

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error

You get this error when the listeners port numbers dont match.

You have a port number (1521) specified in tnsnames.ora, There should be a correspondng listener running on the same port on the target database server. If the listener on the target database server is running on a different port, then you get this error.


ORA-12541: TNS:no listener

OK, Almost every body who have worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12541: TNS:no listener"  mean ?

This means, TNS Listener server is down on the target database server. Check if the listener is up and running.




If your database is running on a windows box, go to services on the database server and check the service is running.

ORA-12545: Connect failed because target host or object does not exist

OK, Almost everbody who has worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12545: Connect failed because target host or object does not exist"  mean ?


Say from SQLPlus, you are issuing the following command

SQL> Conn scott/tiger@orcldb;

SO, SQLPlus, looks for the entry "orcldb" in your client tnsnames.ora file.

In tnsnames.ora, you will find an entry something similar to this

orcldb=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <db_machine_name or ip address>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db_name)
    )
  )

so "ORA-12545: Connect failed because target host or object does not exist" means, either your db_machine_name/ip address is incorrect or your machine cannot connect to db_machinge_name/ip_address
for various reasons like network issues etc


ORA-12154: TNS:could not resolve the connect identifier specified

OK, Almost everbody who has worked in Oracle would have seen this error message. This is one of most frustrating and most common error

What does "ORA-12154: TNS:could not resolve the connect identifier specified"  mean ?


Say from SQLPlus, you are issuing the following command

SQL> Conn scott/tiger@orcldb;

SO, SQLPlus, looks for the entry "orcldb" in your client tnsnames.ora file.

If it cannot find orcldb in tnsnames.ora, then you get ORA-12154: TNS:could not resolve the connect identifier specified

 Fix your tnsnames.ora, and you should be fine.

Thursday, December 1, 2011

ORA-12638: Credential retrieval failed

Toad threw this error today, but I was able to connect to the database using SqlPlus.

The problem is coming from your sqlnet.ora

Check if your SQLNET.AUTHENTICATION_SERVICES.  It should be set to NONE instead of NTS

Old entry
SQLNET.AUTHENTICATION_SERVICES= (NTS)

Correct Entry
SQLNET.AUTHENTICATION_SERVICES= (NONE)