How to change existing DB details in SMP Server

[Former Member]

Dear Experts,

I have SMP3.0 with SP08 installed. I have tagged Oracle with SID as a DB during installation.

Now I need to change the DB server name, and need to change the SID to Service Name.

I dont need to change the password of the DB.

So I know where to change the server name (in connection.properies file)

Below is my connection.properies file.

-----------------------------------------------------------------------------------------------------------

javax.persistence.jdbc.driver=oracle.jdbc.OracleDriver

javax.persistence.jdbc.url=jdbc:oracle:thin:@dbserver.org.com:1521:SAPSMP

javax.persistence.jdbc.user=smp_own

javax.persistence.jdbc.password={enc}F1wXBScfPEaQkVitJWMk2TlIBUelLIqCvxgPxZ9yFqw=

eclipselink.target-database=Oracle

com.sap.persistence.jdbc.connection.pool.max_active=8

com.sap.persistence.jdbc.connection.pool.max_wait_millis=30000

com.sap.persistence.jdbc.connection.pool.min_evictable_idle_time_millis=90000

com.sap.persistence.jdbc.connection.pool.min_idle=1

eclipselink.cache.size.ApplicationConnectionInfo=5000

eclipselink.cache.size.APNSConfig=5000

eclipselink.cache.size.BBConfig=5000

eclipselink.cache.size.NotificationTargetConfig=5000

eclipselink.cache.size.GCMConfig=5000

eclipselink.cache.size.WNSConfig=5000

eclipselink.cache.size.Application=50

eclipselink.cache.size.EndpointConfiguration=50

eclipselink.cache.size.ApplicationsToBackendConnections=300

connectionTestRetryInterval=30000

connectionTestRetryCounter=5

connectionTestStatement=update SMP_CLUSTER_MEMBER set LAST_CONNECTED = (select sys_extract_utc(systimestamp) from dual) where HOSTNAME = ? and DIRECTORY = ?

-----------------------------------------------------------------------------------------------------------

dbserver.org.com:1521:SAPSMP

here SAPSMP is the SID name. now if i want to replace SID with Service name, is it the same way as above?

(dbserver.org.com:1521:ServiceName)

Please suggest.

Thanks

Aditya

[Kevin_SAP · Accepted solution]

Aditya,

This is not supported.  Once the server is installed, you cannot migrate to a different database nor change the connection details. Although not supported, using servicename for Oracle syntax for JDBC is:

jdbc:oracle:thin:@//HOSTNAME:PORT/SERVICENAME

or try

jdbc:oracle:thin:@dbserver.org.com:1521/SERVICENAME

Mind you, this still isn't officially supported changing connection specs as this is stored multiple places.  I am not sure if the / needs an escape character, but I don't think so.

Regards,

Kevin