Jump to content

Not able to connect to Oracle during configuration.


Recommended Posts

Hi,

 

I have successfully installed Plastic SCM 5.0.43.495 on a 64-bit Windows 2008 R2 server.

Then, when I got the connection details from our Oracle DBA, I started the Plastic SCM Server administration tool and tried to do a Migrate database backend to Oracle. 

I entered the values for Server, Oracle SID and Admin User name/Password. I left the default Port and Admin connection mode details (1521 and sysdba resp.) untouched.

Then I clicked on Test connection and immediately got a popup showing the following error message:

 

License not found. Please view "Licensing" topic in dotConnect for Oracle documentation for details or contact Devart technical support.

 

I found on the internet that dotConnect is a product from company Devart, but that is as far as our knowledge goes. We haven't installed this product on the server so we don't know where this message comes from.

It also doesn't matter what kind of details are entered; we always get this message.

 

Does anybody know where this message comes from and what we can do to solve this problem?

 

Thanks.

Link to comment
Share on other sites

Hi Carlos,

 

Thanks for your quick response.

 

I'm not sure what you mean by ".net4 installer" and ".net2 installer". We have .NET Framework 4.5 installed, or are you referring to something else? Do I need to download something from the Plastic downloads page?

 

Kind regards,

 

Ruud.

Link to comment
Share on other sites

  • 4 weeks later...

Hi Carlos,

 

Thanks. It has been a while due to several circumstances.

 

It seems we're getting there slowly, but we came across the following error when trying to create a repository: "Error trying to create the database rep_2: ORA-00955: name is already used by an existing object".

We have tried several times but similar messages keep appearing. According to the DBA the user and tablespace "rep_2" are created at the same time we tried it.

 

See also below extract from the oracle log.

 

Please help us in getting to get this resolved since we don't know how to proceed.

 

Thanks in advance.

 

2013-12-16 15:01:41,901 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 INFO  Operations - Create repository MAGMA
2013-12-16 15:01:43,526 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 INFO  Security - Creating new user or group S-1-5-21-839522115-606747145-725345543-37121
2013-12-16 15:01:45,667 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in DoExecuteDatabaseScript. ORA-00955: name is already used by an existing object
ORA-06512: at line 1
   at xc.u.d()
   at Devart.Data.Oracle.a7.c()
   at Devart.Data.Oracle.p.a(Int32 A_0, aw A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
   at aee.a(CmConnection A_0, String A_1, Boolean A_2)
 
2013-12-16 15:01:45,667 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error trying to create the database rep_2: ORA-00955: name is already used by an existing object
ORA-06512: at line 1
2013-12-16 15:01:45,682 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in CreateSingleRepository. The database rep_2 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object
ORA-06512: at line 1
   at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName)
   at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId)
 
2013-12-16 15:01:45,682 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR Operations - Plastic server version: 5.0.44.505
 
2013-12-16 15:01:45,682 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR Operations - OnError catching exception The database rep_2 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object
ORA-06512: at line 1
 
2013-12-16 15:01:45,745  NT AUTHORITY\SYSTEM at  ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:The database rep_2 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object
ORA-06512: at line 1
 
2013-12-16 15:01:45,745  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   538|rect:  0|sentb:  1559|sendt:  0|prt:    3891|th:   15|dest:   0|mt:    3891|sert:   0|zip:   0|    10.12.57.160|CreateRepository
2013-12-16 15:02:16,494 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - Tcp transport error. ReceiveMessageStatus Connection closed
2013-12-16 15:02:16,494 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - conn        5 Tcp transport error. Connection closed
2013-12-16 15:06:07,221 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 INFO  Operations - Create repository MAGMA
2013-12-16 15:06:11,783 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in DoExecuteDatabaseScript. ORA-00955: name is already used by an existing object
ORA-06512: at line 1
   at xc.u.d()
   at Devart.Data.Oracle.a7.c()
   at Devart.Data.Oracle.p.a(Int32 A_0, aw A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
   at aee.a(CmConnection A_0, String A_1, Boolean A_2)
 
2013-12-16 15:06:11,799 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error trying to create the database rep_4: ORA-00955: name is already used by an existing object
ORA-06512: at line 1
2013-12-16 15:06:11,799 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TSDVADC24 ERROR DataManager - Error in CreateSingleRepository. The database rep_4 can't be created. Check the server log (plastic.server.log). Error: ORA-00955: name is already used by an existing object
ORA-06512: at line 1
   at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName)
   at Codice.CM.Data.BaseDataManager.CreateSingleRepository(Int64 repId)
Link to comment
Share on other sites

Hi,

 

You installed Plastic .net2 installer, right?

 

When you are running the command "cm lrep", are you able to list the repositories? Could you post the output?

 

The error is happening after creating a new repository using Plastic GUI?

 

Could you add a database suffix to the "db.conf"  file (server folder) and restart the Plastic server service??

<DbConfig>
  <ProviderName>oracle</ProviderName>
  <ConnectionString>Direct=true;User={0};Password={0};Data Source=localhost;Port=1521;SID=orcl</ConnectionString>
  <AdminConnectionString>Direct=true;User Id=sys;Password=mypwd;Data Source=localhost;SID=orcl;Connect Mode=sysdba</AdminConnectionString>
 <DatabaseCreationCommands>
 create smallfile tablespace @PlasticDatabase datafile
 '@PlasticDatabase.dbf' size 10M reuse autoextend on next 10M;
 create user @PlasticDatabase identified by @PlasticDatabase
 default tablespace @PlasticDatabase temporary tablespace Temp account
 unlock quota unlimited on @PlasticDatabase;
 grant connect, resource, create session, create table, 
 create view, create any index to @PlasticDatabase;
 </DatabaseCreationCommands>
  <DatabaseSuffix>suffix</DatabaseSuffix>
</DbConfig>
 
Regards,
Carlos
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...