How to run TN scripts ?to create tables in backend. can run scripts through database component configurator.?
how explain step by step

Thanks&regards
siva

1.) Create a user in your database with dba privilege

2.)go to the folder where webMethods installed: C:\webMethods7\common\db\scripts\oracle\tradingnetworks\10\create\ora_tns_c_ddl.sql

copy the content in your sql developer, paste it and run as a script.

3.)go to jdbc pool in Administrator: create a new JDBC pool and associate the connection pool to your TN

4.) restart the server

Thanks

You can run scripts using Database Configurator as well…

Hi
i created jdbc pool successfully .
im useing oracle9i.
my problem is Create a user in your database with dba privilege.
can any one tell me with clear information.

Thanks
siva

May be you can take some DBA help and create the wM user (WEBMDATA or something per doc) in the backend via Oracle Enterprise manager.How did you ran the scripts with out user?

Review the wM installation docs,it explains the db configuration.Use the Database Component Configurator.

Check out these articles:
[url]http://advantage.webmethods.com/article/?id=1614333683[/url]

[URL]http://www.databasedesign-resource.com/users-in-oracle.html[/URL]

HTH,
RMG