Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Service Registry Setup fails to create oracle database schema

31360Dec 2 2008 — edited Mar 17 2009
I have installed Oracle Service Registry 10.3 on my laptop with Vista Operating System. Oracle Service Registry 10.3 is deployed in the Oracle Weblogic Server 10gR3. When I use the Service Registry Setup to create a schema in the Oracle 11g Database, I get the following exceptions:

Preparing LDAP backend ...
Preparing database account backend ...
Preparing database account backend ...
Copying JDBC drivers C:\oracle\product\11.1.0\db_1\jdbc\lib\ojdbc5.jar...
Creating schema ...
Importing system data ...
c:\oracle\registry_10_3/etc/db/data/groups.xml
[java] [java] ERROR: database_core.com.systinet.uddi.database.ApiManager - Can not connect database.
[java] [java] EXCEPTION: (12021) Cannot obtain new connection.
[java] [java] com.systinet.uddi.database.DatabaseCoreException: (12021) Cannot obtain new connection.
[java] [java] at com.systinet.uddi.database.ConnectionPoolImpl.reinit(ConnectionPoolImpl.java:89)
[java] [java] at com.systinet.uddi.database.ConnectionPoolImpl.init(ConnectionPoolImpl.java:69)
[java] [java] at com.systinet.uddi.database.Database.init(Database.java:125)
[java] [java] at com.systinet.uddi.database.ApiManager.<init>(ApiManager.java:102)
[java] [java] at com.systinet.uddi.database.ApiManager.getApiManager(ApiManager.java:69)
[java] [java] at com.systinet.uddi.database.ApiManager.getApiManager(ApiManager.java:54)
[java] [java] at com.systinet.uddi.permission.PermissionApiImplCore.<init>(PermissionApiImplCore.java:109)
[java] [java] at com.systinet.uddi.permission.PermissionApiImplCore.getApiInstance(PermissionApiImplCore.java:130)
[java] [java] at com.systinet.uddi.permission.PermissionApiImpl.init(PermissionApiImpl.java:69)
[java] [java] at com.systinet.uddi.permission.PermissionApiImpl.<init>(PermissionApiImpl.java:45)
[java] [java] at com.systinet.uddi.permission.PermissionApiImpl.getApiInstance(PermissionApiImpl.java:58)
[java] [java] at com.systinet.uddi.permission.module.LoadDownDBModule.init(LoadDownDBModule.java:33)
[java] [java] at com.systinet.uddi.module.ModuleRepository.initModules(ModuleRepository.java:160)
[java] [java] at com.systinet.uddi.module.ModuleRepository.load(ModuleRepository.java:127)
[java] [java] at com.systinet.uddi.module.ModuleRepository.getInstance(ModuleRepository.java:46)
[java] [java] at com.systinet.uddi.WaspUDDI.init(WaspUDDI.java:38)
[java] [java] at com.systinet.uddi.group.ei.ImportMain.optionConfigPath(ImportMain.java:46)
[java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] [java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] [java] at org.systinet.getopt.manager.GetoptManager.process(GetoptManager.java:290)
[java] [java] at com.systinet.uddi.group.ei.ImportMain.main(ImportMain.java:101)
[java] [java] Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
[java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
[java] [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
[java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
[java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
[java] [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:494)
[java] [java] at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
[java] [java] at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
[java] [java] at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
[java] [java] at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
[java] [java] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
[java] [java] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[java] [java] at java.sql.DriverManager.getConnection(DriverManager.java:154)
[java] [java] at com.systinet.uddi.database.UniversalDriver.getConnection(UniversalDriver.java:106)
[java] [java] at com.systinet.uddi.database.DriverManager.getConnection(DriverManager.java:37)
[java] [java] at com.systinet.uddi.database.UDDIDriverManager.getConnection(UDDIDriverManager.java:32)
[java] [java] at com.systinet.uddi.database.ConnectionPoolImpl.reinit(ConnectionPoolImpl.java:81)
[java] [java] ... 22 more
[java] [java] ERROR: account.com.systinet.uddi.account.database.DBAccountApiImpl - DatabaseCoreException: (12021) Cannot obtain new connection.
[java] [java] ERROR: account.com.systinet.uddi.account.AccountCoreApiImpl - Initialization of accounts has failed in the database. Database is not running.
[java] [java] ERROR: group.com.systinet.uddi.group.database.DBGroupApiImpl - DatabaseCoreException: (12021) Cannot obtain new connection.
[java] [java] ERROR: group_core.com.systinet.uddi.group.GroupCoreApiImpl - Initialization of groups has failed in the database. The database is not running.
[java] [java] ERROR: permission.com.systinet.uddi.permission.database.DBPermissionApiImpl - DatabaseCoreException: (12021) Cannot obtain new connection.
[java] [java] WARNING: permission.com.systinet.uddi.permission.PermissionApiImplCore - Permissions failed. Database is not running.
[java] [java] ERROR: permission.com.systinet.uddi.permission.PermissionApiImplCore - Permissions failed. Database is not running.
[java] [java] ERROR: group.com.systinet.uddi.group.ei.ImportImpl - DatabaseCoreException
[java] [java] EXCEPTION: (12021) Cannot obtain new connection.
[java] [java] com.systinet.uddi.database.DatabaseCoreException: (12021) Cannot obtain new connection.
[java] [java] at com.systinet.uddi.database.TransactionManager.getConnectionFromPool(TransactionManager.java:125)
[java] [java] at com.systinet.uddi.database.TransactionManager.initTransaction(TransactionManager.java:94)
[java] [java] at com.systinet.uddi.database.TransactionManager.beginReadWrite(TransactionManager.java:84)
[java] [java] at com.systinet.uddi.group.ei.ImportImpl.importData(ImportImpl.java:66)
[java] [java] at com.systinet.uddi.group.ei.ImportMain.optionImport(ImportMain.java:63)
[java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] [java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] [java] at org.systinet.getopt.manager.GetoptManager.process(GetoptManager.java:290)
[java] [java] at com.systinet.uddi.group.ei.ImportMain.main(ImportMain.java:101)
[java] [java] Exception in thread "main" org.systinet.getopt.manager.RuntimeWrappedException: A fatal error occurred in group management. For help please contact the administrator of the registry.
[java] [java] org.systinet.uddi.group.GroupException: A fatal error occurred in group management. For help please contact the administrator of the registry.
[java] [java] at com.systinet.uddi.group.ei.ImportImpl.importData(ImportImpl.java:76)
[java] [java] at com.systinet.uddi.group.ei.ImportMain.optionImport(ImportMain.java:63)
[java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] [java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] [java] at org.systinet.getopt.manager.GetoptManager.process(GetoptManager.java:290)
[java] [java] at com.systinet.uddi.group.ei.ImportMain.main(ImportMain.java:101)

[java] BUILD FAILED
[java] file:C:/oracle/registry_10_3/etc/bin/install-data.xml:273: Java returned: 1

[java] Total time: 23 seconds

Java returned: 1
Some of the previous process failed. See c:\oracle\registry_10_3\log\setup.log for more information.


I have checked the init.ora, the processes attribute is set 100. Here are contents the init.ora:

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.1.0'

Here are the contents the tnsnames.ora:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HMK-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

What am I missing? Please, help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2009
Added on Dec 2 2008
6 comments
2,868 views