Tuesday, November 30, 2010

Oracle SOA Suite 11gR1 PS2 Installation Traps

1. SOAINFRA user issue
In the domain creatioin, the environment check will report can not find the SOAINFRA user in schema_version_registry.

Error Message:

Component Schema=SOA Infrastructure
Driver=oracle.jdbc.xa.client.OracleXADataSource
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_SOAINFRA
Password=********
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='SOAINFRA' and version='11.1.1.2.0'

CFGFWK-60850: Test Failed!
CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.



Solution:

The error is really caused by the incorrect RCU. RCU is 11.1.1.3.0, but the version in above query is still 11.1.1.2.0. It can be fixed by the follow command.
./Oracle_SOA1/bin/psa -dbType Oracle -dbConnectString localhost:1521:xe -dbaUserName sys -schemaUserName DEV_SOAINFRA

2. Download updates issue.

NOTE: 
In the updates checking process, you have to provide a user name and password of oracle website. Please make sure you provide a correct password before click Next button. I selected the Save Password and I didn't find a way to change it after I clicked the Next button.
Even you provide a correct user name and password, you may still get an error message. From the installation guide, it mentioned ‘If there is a problem connecting to the repositories it may be caused by a proxy server. If so go to JDeveloper – Tools -> Properties -> Web Browser and Proxy and set the proxy server and proxy exclusions to appropriate values for your environment. Then restart JDeveloper.’. But it didn’t tell you how to modify it. I ever tried to deselect the proxy but it failed. When you try the download, you will get the same error and the original setting would come back automatically.
(The JDeveloper – Tools -> Properties -> Web Browser and Proxy should be JDeveloper – Tools -> Preferences -> Web Browser and Proxy.)

Error Message:
"An error occurred downloading updates. Click Back to return to the previous page and retry installation, or Cancel to close wizard. Unexpected end of file from server."

Solution:
1. Directly download for Oracle website and manually install it.
2. Open the preference of Jdeveloper by menu Tools-->Preferences, select the Web browser and Proxy setting and modify the proxy host name to localhost, otherwise, you will be always failed.

Comment:
'I ever tried to deselect the proxy but it failed. When you try the download, you will get the same error and the original setting would come back automatically. '
Maybe I made a mistake and didn't restart the JDeveloper. Now I have successfully deselected the proxy and can update the JDeveloper.


No comments: