Recently after I configured database on testing machine and configure the forms to run on middle tier on testing machine (all windows environment), I came across the error ORA-12638.

After little bit of brains storming and checking online, I found out that one of the way to solve this error is to disable the Oracle Advanced Security Authentication and let database use the supplied user name and password to authenticate.
It can be disable by updating the sqlnet.ora file with the following entry:
SQLNET.AUTHENTICATION_SERVICES = (NONE)

Note : Default entry in my case was SQLNET.AUTHENTICATION_SERVICES= (NTS)
Guys do check out other method and let me […]

[Read more →]

While installing the database some time due some problem, everything is installed but enterprise manager does not work.
In another common case (I am not really talking about production servers here) due to some reason like change in ip addresses and so on, enterprise manager stops working.
Whatever the case, In simple words there is a requirement that we need to drop the existing setup of enterprise manager and create new one with new configuration.
Note here I am only talking about dropping and then creating again which I normally do with my development server off course there are other options too.
First drop […]

[Read more →]

Today I faced the problem of Oracle Forms 6i failing to connect to Oracle XE 10g on my colleague’s laptop.
I faced this problem before also but never thought of jotting it down.
Now I though it will be good idea and helpful to many of my colleagues and friends in Oracle community, if I do so!
Here is what I did to connect Oracle Forms 6i to Oracle XE 10g.
To make Oracle Forms 6i able to connect to Oracle XE 10g I set the database character set to UTF8.
Steps to do are as follows:
First I shutdown the database:
SQLPLUS>shutdown immediate
Then I start the […]

[Read more →]