topic ORA-12519, TNS:no appropriate service handler found in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ora-12519-tns-no-appropriate-service-handler-found/m-p/309197#M262327 <HTML><HEAD></HEAD><BODY><SPAN>Platform: Alfresco 4.2.1 Enterprise Edition</SPAN><BR /><SPAN>OS: Windows 7</SPAN><BR /><SPAN>Database: Oracle Express: 11g</SPAN><BR /><BR /><SPAN>We are going to be transferring our users from Alfresco 2.9 Community to Alfresco 4.2.4 Enterprise.</SPAN><BR /><SPAN>A consultant had written scripts to export the data from 2.9 for an import into 4.2.4</SPAN><BR /><BR /><SPAN>While we await for our licence approval, we are testing the installation and customisations to get a head start on the project.</SPAN><BR /><BR /><SPAN>(we are going to 4.2.4 for now due to the Explorer interface being removed from releases after this).. Eventually we will follow the upgrade path to get onto the latest platform version. We have some custom modifications that we have made to the explorer ui and some actions that we wrote that will be applied to via an amp deployment.</SPAN><BR /><BR /><SPAN>I have tried deploying just the alfresco.war explorer 4.2.4 and it works fine. When I apply the amp and install/deploy from scratch, I get ORA-12519, TNS:no appropriate service handler found. The database tables get created ok. The last thing that is successful before the exception is Startup of replication subsystem.</SPAN><BR /><BR /><SPAN>Startup of 'Replication' subsystem, ID: [Replication, default] complete</SPAN><BR /><SPAN> 2015-11-02 11:24:30,171&nbsp; ERROR [post.lookup.PostLookup] [DefaultScheduler_Worker-6] Exception during update of posts: </SPAN><BR /><SPAN> org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><BR /><SPAN>I have attached the console log file (tomcat.log)</SPAN><BR /><BR /><SPAN>My alfresco-global.properties is:</SPAN><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>###############################</SPAN><BR /><SPAN>## Common Alfresco Properties #</SPAN><BR /><SPAN>###############################</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Sample custom content and index data location</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>dir.root=C:/u01/alfresco/alf_data</SPAN><BR /><SPAN>dir.keystore=${dir.root}/keystore</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Sample database connection properties</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.username=username</SPAN><BR /><SPAN>db.password=password</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># External locations</SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>ooo.exe=soffice</SPAN><BR /><SPAN>ooo.enabled=false</SPAN><BR /><SPAN>jodconverter.officeHome=C:/Progra~2/OpenOffice.org</SPAN><BR /><SPAN>jodconverter.portNumbers=8101</SPAN><BR /><SPAN>jodconverter.enabled=true</SPAN><BR /><SPAN>img.root=C:/Progra~2/ImageMagick-6.3.5-Q16</SPAN><BR /><SPAN>swf.exe=C:/Progra~2/SWFTools/pdf2swf</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Windows specific environment variables (should not be set on unix) for ImageMagick</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>img.coders=${img.root}/modules/coders</SPAN><BR /><SPAN>img.config=${img.root}/config</SPAN><BR /><SPAN>img.gslib=${img.root}</SPAN><BR /><SPAN>img.dyn=${img.root}/</SPAN><BR /><SPAN>img.exe=${img.root}/convert</SPAN><BR /><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Property to control whether schema updates are performed automatically.</SPAN><BR /><SPAN># Updates must be enabled during upgrades as, apart from the static upgrade scripts,</SPAN><BR /><SPAN># there are also auto-generated update scripts that will need to be executed.&nbsp; After</SPAN><BR /><SPAN># upgrading to a new version, this can be disabled.</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.schema.update=true</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># MySQL connection</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=org.gjt.mm.mysql.Driver</SPAN><BR /><SPAN>#db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Oracle connection</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@localhost:1521:xe</SPAN><BR /><SPAN>db.port=8080</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># SQLServer connection</SPAN><BR /><SPAN># Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode</SPAN><BR /><SPAN># Enable TCP protocol on fixed port 1433</SPAN><BR /><SPAN># Prepare the database with:</SPAN><BR /><SPAN># ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON; </SPAN><BR /><SPAN>#s:sqlserver://localhost:1433/alfresco</SPAN><BR /><SPAN>#db.txn.isolation=4096</SPAN><BR /><BR /><SPAN>#db.driver=net.sourceforge.jtds.jdbc.Driver</SPAN><BR /><SPAN>#db.url=jdbc:jtd</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=org.postgresql.Driver</SPAN><BR /><SPAN>#db.url=jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># DB2 connection</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=com.ibm.db2.jcc.DB2Driver</SPAN><BR /><SPAN>#db.url=jdbc:db2://localhost:50000/alfresco:retrieveMessagesFromServerOnGetMessage=true;</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Index Recovery Mode</SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>#index.recovery.mode=AUTO</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Outbound Email Configuration</SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>#mail.host=</SPAN><BR /><SPAN>#mail.port=25</SPAN><BR /><SPAN>#mail.username=anonymous</SPAN><BR /><SPAN>#mail.password=</SPAN><BR /><SPAN>#mail.encoding=UTF-8</SPAN><BR /><SPAN><A class="jive-link-email-small" href="mailto:#mail.from.default=alfresco@alfresco.org" rel="nofollow noopener noreferrer">#mail.from.default=alfresco@alfresco.org</A></SPAN><BR /><SPAN>#mail.smtp.auth=false</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Alfresco Email Service and Email Server</SPAN><BR /><SPAN>#————-</SPAN><BR /><BR /><SPAN># Enable/Disable the inbound email service.&nbsp; The service could be used by processes other than</SPAN><BR /><SPAN># the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.</SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>#email.inbound.enabled=true</SPAN><BR /><BR /><SPAN># Email Server properties </SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>#email.server.enabled=true</SPAN><BR /><SPAN>#email.server.port=25</SPAN><BR /><SPAN>#email.server.domain=alfresco.com</SPAN><BR /><SPAN>#email.inbound.unknownUser=anonymous</SPAN><BR /><BR /><SPAN># A comma separated list of email REGEX patterns of allowed senders.</SPAN><BR /><SPAN># If there are any values in the list then all sender email addresses</SPAN><BR /><SPAN># must match. For example:</SPAN><BR /><SPAN>#&nbsp;&nbsp; .*\@alfresco\.com, .*\@alfresco\.org</SPAN><BR /><SPAN># Allow anyone:</SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>#email.server.allowed.senders=.*</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># The default authentication chain</SPAN><BR /><SPAN># To configure external authentication subsystems see:</SPAN><BR /><SPAN># </SPAN><A href="http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems</A><BR /><SPAN>#————-</SPAN><BR /><SPAN>#authentication.chain=alfrescoNtlm1:alfrescoNtlm</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># URL Generation Parameters (The ${localname} token is replaced by the local server name)</SPAN><BR /><SPAN>#————-</SPAN><BR /><SPAN>#alfresco.context=alfresco</SPAN><BR /><SPAN>#alfresco.host=${localname}</SPAN><BR /><SPAN>#alfresco.port=8080</SPAN><BR /><SPAN>#alfresco.protocol=http</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#share.context=share</SPAN><BR /><SPAN>#share.host=${localname}</SPAN><BR /><SPAN>#share.port=8080</SPAN><BR /><SPAN>#share.protocol=http</SPAN><BR /><BR /><SPAN>#imap.server.enabled=true</SPAN><BR /><SPAN>#imap.server.port=143</SPAN><BR /><SPAN>#imap.server.host=localhost</SPAN><BR /><BR /><SPAN># Default value of alfresco.rmi.services.host is 0.0.0.0 which means 'listen on all adapters'.</SPAN><BR /><SPAN># This allows connections to JMX both remotely and locally.</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>alfresco.rmi.services.host=0.0.0.0</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># RMI service ports for the individual services.</SPAN><BR /><SPAN># These seven services are available remotely.</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Assign individual ports for each service for best performance </SPAN><BR /><SPAN># or run several services on the same port. You can even run everything on 50500 if needed.</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Select 0 to use a random unused port.</SPAN><BR /><SPAN># </SPAN><BR /><SPAN>#avm.rmi.service.port=50501</SPAN><BR /><SPAN>#avmsync.rmi.service.port=50502</SPAN><BR /><SPAN>#attribute.rmi.service.port=50503</SPAN><BR /><SPAN>#authentication.rmi.service.port=50504</SPAN><BR /><SPAN>#repo.rmi.service.port=50505</SPAN><BR /><SPAN>#action.rmi.service.port=50506</SPAN><BR /><SPAN>#wcm-deployment-receiver.rmi.service.port=50507</SPAN><BR /><SPAN>#monitor.rmi.service.port=50508</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN><BR /><BR /><BR /><SPAN>We also have a datasource.. I'm not 100% sure if 4.2.4 is picking up the properties file, or using this datasource. We used a datasource in 2.9 but 4.2 seems to be configured differently… For now, I've left it with both the properties and datasource.</SPAN><BR /><BR /><SPAN>C:\Program Files\Apache_Software_Foundation\apache-tomcat-7.0.42\webapps\alfresco\WEB-INF\classes\alfresco\extension\data-source-context.xml</SPAN><BR /><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>&lt;?xml version='1.0' encoding='UTF-8'?&gt;</SPAN><BR /><SPAN>&lt;!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' '</SPAN><A href="http://www.springframework.org/dtd/spring-beans.dtd" rel="nofollow noopener noreferrer">http://www.springframework.org/dtd/spring-beans.dtd</A><SPAN>'&gt;</SPAN><BR /><BR /><SPAN>&lt;!– Over-rides the datasource bean in core-services-context.xml to support jndi lookup –&gt;</SPAN><BR /><SPAN>&lt;beans&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;!– Datasource bean –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jndiName" value="java:comp/env/jdbc/nhpols_dsn" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&lt;/bean&gt;</SPAN><BR /><SPAN>&lt;/beans&gt;</SPAN><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><BR /><BR /><SPAN>The tns names seems to be ok since it's creating the database structure and I can log in via sql developer with no issues.</SPAN><BR /><BR /><SPAN>Does anyone have a suggestion what to look for? We will have a licence for enterprise in the near future so we can open an official ticket then if we have not resolved it by then. We'd like to get it resolved asap though so we can start testing the upgrade process once we get an official licence.</SPAN></BODY></HTML> Mon, 02 Nov 2015 19:57:06 GMT cdn_alfresco_de 2015-11-02T19:57:06Z ORA-12519, TNS:no appropriate service handler found https://connect.hyland.com/t5/alfresco-archive/ora-12519-tns-no-appropriate-service-handler-found/m-p/309197#M262327 Platform: Alfresco 4.2.1 Enterprise EditionOS: Windows 7Database: Oracle Express: 11gWe are going to be transferring our users from Alfresco 2.9 Community to Alfresco 4.2.4 Enterprise.A consultant had written scripts to export the data from 2.9 for an import into 4.2.4While we await for our licence Mon, 02 Nov 2015 19:57:06 GMT https://connect.hyland.com/t5/alfresco-archive/ora-12519-tns-no-appropriate-service-handler-found/m-p/309197#M262327 cdn_alfresco_de 2015-11-02T19:57:06Z Re: ORA-12519, TNS:no appropriate service handler found https://connect.hyland.com/t5/alfresco-archive/ora-12519-tns-no-appropriate-service-handler-found/m-p/309198#M262328 <HTML><HEAD></HEAD><BODY><SPAN>solved my problem:</SPAN><BR /><A href="https://www.talendforge.org/forum/viewtopic.php?id=35959" rel="nofollow noopener noreferrer">https://www.talendforge.org/forum/viewtopic.php?id=35959</A><BR /><BR /><SPAN>After running below two queries in oracle DB my job worked fine ..</SPAN><BR /><SPAN>Thanks for your help..</SPAN><BR /><BR /><SPAN>ALTER SYSTEM SET PROCESSES=200 SCOPE=SPFILE;</SPAN><BR /><SPAN>ALTER SYSTEM SET OPEN_CURSORS=500;</SPAN></BODY></HTML> Mon, 02 Nov 2015 21:56:41 GMT https://connect.hyland.com/t5/alfresco-archive/ora-12519-tns-no-appropriate-service-handler-found/m-p/309198#M262328 cdn_alfresco_de 2015-11-02T21:56:41Z