Solved

Configure Oracle Instance Issue

Hi,

When configuring Oracle Instance of my bizagi project, I obtain the error "Could not resolve the instance server-oracle:1521/baor11gr2". Any help please?

Comments (10)

photo
1

Dear User,

Regarding this issue, please verify the listener of your Oracle. After this, verify the ODP installation according this article: http://help.bizagi.com/bpmsuite/en/index.html?installing_oracle_data_provide.htm

We look forward to hearing from you

photo
1

Thanks you for your help. I check the listener of Oracle; it is running. Concerning the installation of ODP, I read the article. It is mentionned in this article that this step is needed for the .Net Engine. I'm working with J2EE Engine(JBoss). My problem still persist. I tried with an existing server of oracle,It doesn't work also.

photo
1

Thanks for your help. I'll check the db connection.

I'm trying to create a new project to turn my workflow into running applications. I'm at the first level.

photo
1

I checked the list of dba_users and I did'nt find a new user created by Bizagi. I found only the BizagiAdmon user. I'm wondering if I must create it by myself or I must edit the configureInstanceForBizAgi-11g.sql?

Thanks in advance.

photo
1

Dear User,

Have you been able to connect from your Windows to Oracle Server using SQL Plus(sqlplus.exe) with the user SYS?

As it is the first level, you need to automate your process using Bizagi Studio on Windows. Please install the ODP according the architecture of Bizagi Studio. That means if your Bizagi Studio is x64 Bits, you need to install only ODP x64Bits, but it is x32 Bits, so install only x32 Bits: http://help.bizagi.com/bpmsuite/en/index.html?installing_oracle_data_provide.htm

Regards

photo
1

I added a Bizagi User using SQLPLUS:

CREATE USER bizagiuser PROFILE DEFAULT

IDENTIFIED BY bizagi DEFAULT TABLESPACE BIZAGI

TEMPORARY TABLESPACE TEMP

QUOTA UNLIMITED ON BIZAGI

QUOTA UNLIMITED ON BIZAGIIDX

ACCOUNT UNLOCK;

Should I have to install ODP because I read the article of Installing ODP and this step is additional for .Net Engine?

Actually I tried to create a new project and I get the error server unreacheble.

photo
1

Dear User,

Regarding the attached image, you need to verify Bizagi Operation Service. It should be up. If it is up, restart it.

Regarding your question, yes. It is necesary because Bizagi Studio is built in .NET so that it needs to have a connection to oracle.

Regards

photo
1

Thanks a lot.

photo
1

I installed the oracle data provider and I still get the error: server unreacheable. I'm not working with a remote server. Please how can i check if the user is included in the server's bizagi group?

photo
1

Hi,

Thanks a lot for your help. Finally, it works.