Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Hot answers tagged

10 votes
Accepted

Web 8.5 Deployer Error when Publishing

Yes, it turns out we were indeed missing a Content Delivery hotfix. We installed the latest cumulative CD hotfix (CD_8.5.0.9057), which solved our issue. The specific hotfix that originally caught our ...
user avatar
10 votes
Accepted

Oracle Content Delivery CreateTridionSYSUser.sql errors

For anyone else stuck with this, here's the solution. Oracle 12c introduces multitenancy. With this architecture the Tridion Content Delivery database must be set up in the pluggable database rather ...
user avatar
5 votes
Accepted

Maintaining Oracle DB SDL Tridion 2011 SP1

Doesn't that same documentation explain what these scripts do? (It does, AFAIK) Only AnalyzeStats.sql and RebuildIndexes.sql are intended for regular maintenance; the other scripts are analytical -- ...
user avatar
4 votes

Conversion of Tridion CMS from MS SQL Server to Oracle

I've done it once for a customer, it was a horrible job to do since the sequences didn't migrate well with the data migration assistant from Oracle (but that might have changed as it was a long time ...
user avatar
  • 29.6k
4 votes

Conversion of Tridion CMS from MS SQL Server to Oracle

Yes, it's possible, I've done it before, but don't expect to get SDL support afterwards. I've migrated Oracle to MS SQL, but steps are still the same: Create a database on Oracle. It should be of ...
user avatar
4 votes
Accepted

Setup and user priviledges for content delivery with Oracle on Amazon RDS

I've found a very informative answer by Nuno on this subject. It seems that Oracle can not be used with cloud service providers such as RDS and Azure due to this specific problem with limitations on ...
user avatar
3 votes

A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM"

I think that that Stored Procedure is used when a Directory Service user ("LDAP user" if you wish) logs in. This means it is a very commonly used Stored Procedure and thus it is very unlikely a ...
user avatar
3 votes
Accepted

Content Porter 2013 SP1 Import Oracle DB Error

It appears from the following error message (at the end of your first line of logging): Oracle.DataAccess.Client.OracleException: ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], []...
user avatar
3 votes

Content Porter Tool SQL Server/Oracle Issues?

The problems you may spot are related to database and not to Tridion per se. Even more you might have problems migrating between the databases of the same type. For example: you may have different ...
user avatar
3 votes

Content Porter Tool SQL Server/Oracle Issues?

I would not expect any issue because the Content Porter calls the Tridion Core Service API which is an abstract layer on top of the database. However I did not try it myself so will let others ...
user avatar
3 votes
Accepted

Content Porter 2013 SP1 with Oracle

I was informed by SDL support that Oracle RAC configurations of Active-Active are not supported. We switched to a stand-alone instance for the CM and the problem was solved.
user avatar
2 votes

ORA-12154: TNS:could not resolve the connect identifier specified

Check the spacing of entries in TNSnames.ora file. it looks simple however it shows same error TNS:could not resolve the connect identifier specified. We had a space at the start of entry.
user avatar
2 votes
Accepted

Case insensitive queries for Tridion and Oracle DB as Broker DB

Are you using API queries, or are you querying the database directly? Do you have some examples? Have you checked with your Oracle DBA as well for possible solutions? Here is another post which can ...
user avatar
2 votes
Accepted

sdl web 8 'this implementation is not part of the windows platform FIPS validated cryptographic algorithms'

Got it working. I just navigated into the FipsAlgorithmPolicy folder and changed the "Enabled" DWORD from 1 to 0 and the install worked just fine from HKEY_LOCAL_MACHINE\System\CurrentControlSet\...
user avatar
2 votes

Oracle Content Delivery CreateTridionSYSUser.sql errors

This is an Oracle specific error (not related to Tridion) and it occurs because of the scope/container where you are trying to create the user in the Oracle DB. You should try option mentioned in the ...
user avatar
2 votes
Accepted

Content Porter Tool SQL Server/Oracle Issues?

Note that Content Porter is not intended for database migration purposes. It doesn't port all data in the system, you loose version histories and you will hit size limitations if you try to export ...
user avatar
2 votes

Web 8.5 Deployer Error when Publishing

Looks like Oracle connectivity issues. Try to verify following to fix that issue. Ensure your Microservice server installed oracle client and the tnsnames.ora file configured and file that contains ...
user avatar
  • 7,495
2 votes
Accepted

A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM"

bump up the 'open_cursor' to 2000 (from 400) seem to have helped. For example: ALTER SYSTEM SET OPEN_CURSORS=2000 SID='*' SCOPE=BOTH; Of course, the 2000 value is varied from one system to another......
user avatar
2 votes

A database error occurred while executing Stored Procedure "EDA_TRUSTEES.GETLIST_DGM"

Are you getting this error only when you try to create an item using Core service, but you have no issues with create a item inside CME manually? If so, we may be logging as different users with ...
user avatar
  • 1,231
1 vote

TDSE: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I would try to isolate this to being a "plain old ORACLE" problem if possible. Try testing the connection with TNSPING etc., as described in the ORACLE Documentation. If you can reproduce your ...
user avatar
  • 18.5k
1 vote

Content Porter 2013 SP1 Import Oracle DB Error

After working with DBA to have the Tridion CM schema/db on an Active/Passive scenario within a cluster per SDL Model. I was able to successfully promote content via Content Porter I am not sure if ...
user avatar
1 vote

Conversion of Tridion CMS from MS SQL Server to Oracle

In addition to what others has suggested, please also follow the Installation Manual for SDL Tridion as you may need to apply some additional patch while you shift to Oracle. Regarding where all you ...
user avatar
  • 15.9k

Only top scored, non community-wiki answers of a minimum length are eligible