rollbase private installation with oracle 11g

Posted by shilpi.agarwal3373 on 16-Mar-2016 08:43

Following are the steps to install rollbase with oracle-

unzip the fiiles

copy webapps to tomcat\webapps

copy lib to tomcat\lib

Then Launch sql developer and connect to my database (orcl) with the admin (sys/sysadmin) credentials.

Now, create a new user by setting username and password. (jktech/jktech)

Now, login to sql developer on the same db(orcl) with the newly created user credentials and try running the create_ora.sql on the query editor.

It is creating the rb schema. 

now edit database.xml file-

<Database name="orcl" isDefault="yes" isExternal="no"
MinConnections="3" MaxConnections="10"
MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"
MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">
<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>
<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>
<DbUser>jktech</DbUser>
<Password>jktech</Password>
</Database>

edit components.xml file

edit shared.properties file

start tomcat webserver

So an error appears-

Database RB is not found.

and so many error occurs....

Rollbase - Forum

All Replies

Posted by shilpi.agarwal3373 on 16-Mar-2016 08:43

please suggest

Posted by Mani Kumar on 16-Mar-2016 08:55

Did you comment out the other Databases from the Databases.xml?

Also,  are there any existing customer records that are still pointing to the RB DB? Please check.

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:02

yes.. i commented out the other databases from databse.xml file.

This is database.xml

<!-- Sample configuration file for Progress Rollbase Private Cloud evaluation -->

<Databases>

<!--

$BEGIN_COMMENT_OTHER$

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="yes">

<Driver>com.mysql.jdbc.Driver</Driver>

<Url>jdbc:mysql://localhost:3306/RB_DBO</Url>

<DbUser>root</DbUser>

<Password>...</Password>

</Database>

$END_COMMENT_OTHER$

-->

<!-- sample template for Oracle using DataDirect driver -->

<Database name="orcl" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>

<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>

<DbUser>jktech</DbUser>

<Password>jktech</Password>

</Database>

<!-- sample template for SQLServer using DataDirect driver

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.sqlserver.SQLServerDriver</Driver>

<Url>jdbc:rollbase:sqlserver://localhost:1433;databaseName=RB_DBO;integratedSecurity=true;ConnectionRetryCount=10;ConnectionRetryDelay=10</Url>

<DbUser>root</DbUser>

<Password>...</Password>

</Database -->

<!-- sample template for OpenEdge usage -->

<!--

$BEGIN_COMMENT_OPENEDGE$

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="yes">

<Driver>com.ddtek.jdbc.openedge.OpenEdgeDriver</Driver>

<Url>jdbc:datadirect:openedge://$DB_HOST_NAME$:$DB_PORT_NUMBER$;databaseName=$DB_NAME$</Url>

<DbUser>$DB_USER_NAME$</DbUser>

<Password>$DB_PASSWORD$</Password>

</Database>

$END_COMMENT_OPENEDGE$

-->

<!-- sample template for DataDirect Cloud usage

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="yes">

<Driver>com.ddtek.jdbc.ddcloud.DDCloudDriver</Driver>

<Url>jdbc:datadirect:ddcloud://service.datadirectcloud.com:443;databaseName=RB_DBO</Url>

<DbUser>root</DbUser>

<Password>...</Password>

</Database -->

</Databases>

are there any existing customer records that are still pointing to the RB DB? Please let me know What u mean by this?

Posted by Mani Kumar on 16-Mar-2016 09:06

You should not rename the Database name. Please change the <Database name="orcl"  to <Database name="RB" and restart the server.

Posted by Manooj Murali on 16-Mar-2016 09:08

Hi Shilpi -

Can you try by renaming the name="orcl" to name="RB" ?

Regards.

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:13

Both places, database.xml and in the Oracledb ?

Posted by Mani Kumar on 16-Mar-2016 09:23

No, I guess you would have created Database with name "RB_DBO" this should be fine (This is what you are accessing from <Url> tag).

Please make this change in the Database.xml only.

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:24

i rename the database name from orcl to RB and then restart the webserver then following error appears-

java.sql.SQLNonTransientConnectionException occurs- and so many error appears. please find attached doc

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:29

Mani- U mean to say

<!-- sample template for Oracle using DataDirect driver -->

<Database name="RB_DBO" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>

<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>

<DbUser>jktech</DbUser>

<Password>jktech</Password>

</Database>

Is this Ok?

Posted by Mani Kumar on 16-Mar-2016 09:29

Attachment is missing, can you please re-attach the doc?

Also, can you please try restarting again?

Posted by Mani Kumar on 16-Mar-2016 09:31

Sorry if I've confused you. It should be only "RB" as below.

<!-- sample template for Oracle using DataDirect driver -->

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>

<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>

<DbUser>jktech</DbUser>

<Password>jktech</Password>

</Database>

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:35

Mani-- it is not working..   java.sql.SQLNonTransientConnectionException occurs- and so many error appears -

An error occured while attaching the doc..Sorry.

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:37

Should i change the db name orcl to RB in Oracledb only? Please suggest.. It is very high priority.. I stucked badly.

Posted by shilpi.agarwal3373 on 16-Mar-2016 09:54

Following are the files-

components.xml

<Components>

<Component name="MASTER" type="MASTER">

<DisplayName>Master Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/master/</ExternalRoot>

<Props>

<ResourcesCheck>2</ResourcesCheck>

<ExpirationDays>30</ExpirationDays>

</Props>

</Component>

<Component name="PROD1" type="PROD">

<DisplayName>Production Server 1</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/prod1/</ExternalRoot>

<Props>

<Power>1.0</Power>

</Props>

</Component>

<Component name="REST" type="REST">

<DisplayName>REST Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/rest/</ExternalRoot>

</Component>

<!--<Component name="RSS" type="RSS">-->

<!--<DisplayName>RSS Server</DisplayName>-->

<!--<InternalRoot>localhost:$HTTP_PORT$/.../InternalRoot>-->

<!--<ExternalRoot>http://{!#HOST_NAME}/rss/</ExternalRoot>-->

<!--<Props>-->

<!--<MinRequestIntervalMins>60</MinRequestIntervalMins>-->

<!--</Props>-->

<!--</Component>-->

<Component name="ROUTER" type="ROUTER">

<DisplayName>Router Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/router/</ExternalRoot>

<Props>

<StatusCheckInterval>10</StatusCheckInterval>

<CustWeight>3</CustWeight>

<CleckLoginURL>true</CleckLoginURL>

</Props>

</Component>

<Component name="SEARCH" type="SEARCH">

<DisplayName>Search Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/search/</ExternalRoot>

<Props>

<CloseAfterMin>60</CloseAfterMin>

<MaxSearchResults>200</MaxSearchResults>

<LockTimeoutSec>30</LockTimeoutSec>

<RAMBufferMB>64</RAMBufferMB>

</Props>

</Component>

<Component name="STORAGE" type="STORAGE">

<DisplayName>Storage Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/storage/</ExternalRoot>

<Props>

<LogFormat>[%d] %m%n</LogFormat>

<MaxBackupIndex>3</MaxBackupIndex>

<CloseAfterMin>30</CloseAfterMin>

<LogFileSize>300KB</LogFileSize>

<MaxSystemBackups>5</MaxSystemBackups>

</Props>

</Component>

<Component name="WORKFLOW" type="WORKFLOW">

<DisplayName>Workflow Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/workflow/</ExternalRoot>

<Props>

<EventCheckMins>1</EventCheckMins>

</Props>

</Component>

<Component name="WEBAPI" type="WEBAPI">

<DisplayName>SOAP Server</DisplayName>

<InternalRoot>localhost:8080/.../InternalRoot>

<ExternalRoot>http://{!#HOST_NAME}/webapi/</ExternalRoot>

</Component>

</Components>

database.xml

I rename database name "orcl" to "RB".

<!-- sample template for Oracle using DataDirect driver -->

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>

<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>

<DbUser>jktech</DbUser>

<Password>jktech</Password>

</Database>

Still i am getting the error-  java.sql.SQLNonTransientConnectionException -------- and so on.

Please suggest what should be done..

Posted by Mani Kumar on 16-Mar-2016 10:07

Can you please share a set of log for " java.sql.SQLNonTransientConnectionException"

Posted by Manooj Murali on 16-Mar-2016 10:20

Hi Shilpi -

Let the db name in oracle database be RB_DBO.. Please do not change it.

Just change the database name="RB".

Now, even after this, it things do not work, then please try to access the database by providing the url,username & password you provided in the database.xml in the SQL developer and see if you can access the database. Also, if you can login, then please try to check if the schema has the rollbase tables.

Regards.

Posted by shilpi.agarwal3373 on 17-Mar-2016 00:44

Hi Manooj,

I have created oracle blank database named "orcl".

Craete new user with user name and password is "jktech", "jktech".

Launch sql developer and make a connection and give all the details like connection name, host, port , database name

Run create_ora.sql script and it is successfully creating a databse schema.

Edit database.xml file.. (here database name changed to RB from "orcl")

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>

<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=RB_DBO;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>

<DbUser>jktech</DbUser>

<Password>jktech</Password>

</Database>

Then start tomcat server and an error SSqlNonTransientConnectionException occurs and so many errors.

. and suggest me what can be the possible solution.. Also an error occurs while file is attaching , . so not able to send the error..

Posted by shilpi.agarwal3373 on 17-Mar-2016 00:55

You mean to say that Oracle database name should be "RB_DBO" and database name should be  "RB" in database.xml file. Am i correct?

Posted by Srinivas Panyala on 17-Mar-2016 01:17

Are you able to connect "orcl" database from oracle sqlplus client?

Please edit database.xml like below.

<Database name="RB" isDefault="yes" isExternal="no"

MinConnections="3" MaxConnections="10"

MaxInUseConnTimeMins="30" MaxNotUsedConnTimeMins="1"

MaxConnLifetimeMins="60" TxIsolation="2" useTxRecovery="no">

<Driver>com.rb.jdbc.oracle.OracleDriver</Driver>

<Url>jdbc:rollbase:oracle://172.18.0.240:1521;ServiceName=orcl;ConnectionRetryCount=10;ConnectionRetryDelay=10;identifySystemTables=false</Url>

<DbUser>jktech</DbUser>

<Password>jktech</Password>

</Database>

Thanks

Srinivas

Posted by shilpi.agarwal3373 on 17-Mar-2016 01:57

ya Thanks a lot.. Now it works.. Succefully installed rollbase with oracle.

This thread is closed