Hi Gurus,
We have completed installation of the ORDS 17.4 latest version in system. PFB details of steps.
--Details of installation
[oracle@duketrdd112 ords]$ java -jar ords.war install advanced
This Oracle REST Data Services instance has not yet been configured.
Please complete the following prompts
Enter the location to store configuration data:/u00/app/oracle/product/11.2.0.4/DEVOIC/ords/conf
Enter the name of the database server [localhost]:duketrdd112v.corp.cox.com
Enter the database listen port [1521]:1539
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1
Enter the database service name:DEVOIC
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:1
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires SYS AS SYSDBA to verify Oracle REST Data Services schema.
Enter the database password for SYS AS SYSDBA:
Confirm password:
Retrieving information.
Enter the default tablespace for ORDS_METADATA [SYSAUX]:
Enter the temporary tablespace for ORDS_METADATA [TEMP]:
Enter the default tablespace for ORDS_PUBLIC_USER [USERS]:
Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2
Jan 10, 2018 6:13:59 AM
INFO: Updated configurations: defaults, apex_pu
Installing Oracle REST Data Services version 17.4.1.353.06.48
... Log file written to /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/logs/ords_install_core_2018-01-10_061359_00837.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/logs/ords_install_datamodel_2018-01-10_061445_00051.log
... Log file written to /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/logs/ords_install_apex_2018-01-10_061504_00112.log
Completed installation for Oracle REST Data Services version 17.4.1.353.06.48. Elapsed time: 00:01:27.181
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
Enter 1 if using HTTP or 2 if using HTTPS [1]:1
Enter the HTTP port [8080]:
2018-01-10 06:15:48.712:INFO::main: Logging initialized @304471ms to org.eclipse.jetty.util.log.StdErrLog
Jan 10, 2018 6:15:48 AM
INFO: HTTP and HTTP/2 cleartext listening on port: 8080
Jan 10, 2018 6:15:48 AM
INFO: Disabling document root because the specified folder does not exist: /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/conf/ords/standalone/doc_root
2018-01-10 06:15:49.064:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT
2018-01-10 06:15:49.110:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2018-01-10 06:15:49.110:INFO:oejs.session:main: No SessionScavenger set, using defaults
2018-01-10 06:15:49.111:INFO:oejs.session:main: Scavenging every 660000ms
Jan 10, 2018 6:15:49 AM
INFO: No encryption key found in configuration, generating key
Jan 10, 2018 6:15:49 AM
INFO: No mac key found in configuration, generating key
Jan 10, 2018 6:15:49 AM
INFO: Updated configurations: defaults
Jan 10, 2018 6:15:49 AM
INFO: Updated configuration with generated keys
Jan 10, 2018 6:15:49 AM
INFO: Validating pool: |apex|pu|
Jan 10, 2018 6:15:49 AM
INFO: Pool: |apex|pu| is correctly configured
Jan 10, 2018 6:15:49 AM
INFO: Using configuration folder: /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/conf/ords
config.dir
Jan 10, 2018 6:15:49 AM
INFO: Oracle REST Data Services initialized
Oracle REST Data Services version : 17.4.1.353.06.48
Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT
2018-01-10 06:15:49.817:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@5db250b4{/ords,null,AVAILABLE}
2018-01-10 06:15:49.827:INFO:oejs.AbstractConnector:main: Started ServerConnector@441772e{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2018-01-10 06:15:49.828:INFO:oejs.Server:main: Started @305587ms
2018-01-10 06:16:21.846:INFO:oejs.AbstractConnector:Thread-3: Stopped ServerConnector@441772e{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2018-01-10 06:16:21.847:INFO:oejs.session:Thread-3: Stopped scavenging
2018-01-10 06:16:21.851:INFO:oejsh.ContextHandler:Thread-3: Stopped o.e.j.s.ServletContextHandler@5db250b4{/ords,null,UNAVAILABLE}
[oracle@duketrdd112 ords]$ java -jar ords.war user devoic_ords "SQL Developer","Listener Administrator"
Enter a password for user devoic_ords:
Confirm password for user devoic_ords:
Jan 10, 2018 6:18:45 AM oracle.dbtools.standalone.ModifyUser execute
INFO: Created user: devoic_ords in file: /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/conf/ords/credentials
Post this We have started the ORDS in stand alone mode
-- details
[oracle@duketrdd112 ords]$ java -jar ords.war
Verify ORDS schema in Database Configuration apex with connection host: duketrdd112v.corp.cox.com port: 1539 service name: DEVOIC
Retrieving information.
Jan 10, 2018 6:19:14 AM oracle.dbtools.rt.config.setup.SchemaSetup install
INFO: Oracle REST Data Services schema version 17.4.1.353.06.48 is installed.
2018-01-10 06:19:14.693:INFO::main: Logging initialized @6081ms to org.eclipse.jetty.util.log.StdErrLog
Jan 10, 2018 6:19:14 AM
INFO: HTTP and HTTP/2 cleartext listening on port: 8080
Jan 10, 2018 6:19:14 AM
INFO: Disabling document root because the specified folder does not exist: /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/conf/ords/standalone/doc_root
2018-01-10 06:19:15.065:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT
2018-01-10 06:19:15.112:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
2018-01-10 06:19:15.113:INFO:oejs.session:main: No SessionScavenger set, using defaults
2018-01-10 06:19:15.113:INFO:oejs.session:main: Scavenging every 600000ms
Jan 10, 2018 6:19:15 AM
INFO: Validating pool: |apex|pu|
Jan 10, 2018 6:19:15 AM
INFO: Pool: |apex|pu| is correctly configured
Jan 10, 2018 6:19:15 AM
INFO: Using configuration folder: /u00/app/oracle/product/11.2.0.4/DEVOIC/ords/conf/ords
config.dir
Jan 10, 2018 6:19:15 AM
INFO: Oracle REST Data Services initialized
Oracle REST Data Services version : 17.4.1.353.06.48
Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT
2018-01-10 06:19:15.790:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@dbd940d{/ords,null,AVAILABLE}
2018-01-10 06:19:15.800:INFO:oejs.AbstractConnector:main: Started ServerConnector@6ab7a896{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
2018-01-10 06:19:15.800:INFO:oejs.Server:main: Started @7188ms
*** After this when I tried to connect from SQLDEVELOPER with user created devoic_ords in above comment I got error as HTTP://1.1 404 Not found
in the ORDS sever end i got below mentioned issue.
Jan 10, 2018 6:19:46 AM
INFO: Configuration properties for: |apex|pu|
cache.caching=false
cache.directory=/tmp/apex/cache
cache.duration=days
cache.expiration=7
cache.maxEntries=500
cache.monitorInterval=60
cache.procedureNameList=
cache.type=lru
db.hostname=duketrdd112v.corp.cox.com
db.port=1539
db.servicename=DEVOIC
debug.debugger=false
debug.printDebugToScreen=false
error.keepErrorMessages=true
error.maxEntries=50
jdbc.DriverType=thin
jdbc.InactivityTimeout=1800
jdbc.InitialLimit=3
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=10
jdbc.MaxStatementsLimit=10
jdbc.MinLimit=1
jdbc.statementTimeout=900
log.logging=false
log.maxEntries=50
misc.compress=
misc.defaultPage=apex
security.crypto.enc.password=******
security.crypto.mac.password=******
security.disableDefaultExclusionList=false
security.maxEntries=2000
db.password=******
db.username=ORDS_PUBLIC_USER
Jan 10, 2018 6:19:46 AM
WARNING: *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***
Jan 10, 2018 6:19:46 AM
WARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***
Jan 10, 2018 6:19:46 AM
SEVERE: *** Error: Could not obtain a database connection because all connections in the pool: |apex|pu| were in use. Borrowed Connections: 0 Available Connections: 0 Maximum Connections: 0 ***
Jan 10, 2018 6:19:46 AM
WARNING: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:2013)
at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:198)
at oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4353)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1924)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1901)
at oracle.dbtools.common.jdbc.DataSourceConnection.getConnection(DataSourceConnection.java:46)
at oracle.dbtools.common.pools.DataSourceTargetImpl.connection(DataSourceTargetImpl.java:41)
at oracle.dbtools.url.mapping.db.targets.SchemaTargetsProvider$SchemaLoader.load(SchemaTargetsProvider.java:256)
at oracle.dbtools.url.mapping.db.targets.SchemaTargetsProvider.schemaTarget(SchemaTargetsProvider.java:75)
at oracle.dbtools.url.mapping.db.DatabaseURLMappingImpl.checkSchemaMapping(DatabaseURLMappingImpl.java:474)
at oracle.dbtools.url.mapping.db.DatabaseURLMappingImpl.resolve(DatabaseURLMappingImpl.java:170)
at oracle.dbtools.url.mapping.URLMappingCache.load(URLMappingCache.java:245)
at oracle.dbtools.url.mapping.URLMappingCache.map(URLMappingCache.java:64)
at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:103)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:83)
at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:85)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:72)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)
at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
at oracle.dbtools.http.filters.Filters.filter(Filters.java:65)
at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:81)
at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:49)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:113)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:841)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:535)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:561)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:133)
at oracle.ucp.common.Database.createPooledConnection(Database.java:256)
at oracle.ucp.common.Service.create(Service.java:758)
at oracle.ucp.common.Service.create(Service.java:588)
at oracle.ucp.common.Topology.create(Topology.java:145)
at oracle.ucp.common.Core.growBorrowed(Core.java:699)
at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:205)
at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionAndValidate(UniversalConnectionPoolImpl.java:148)
at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:122)
at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:172)
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.borrowConnection(OracleJDBCConnectionPool.java:613)
at oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool.borrowConnection(OracleConnectionConnectionPool.java:97)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1989)
... 61 more
Caused by: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:384)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:273)
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1649)
at oracle.jdbc.pool.OracleDataSource$1.build(OracleDataSource.java:1643)
at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:103)
... 73 more
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:271)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:317)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)
... 81 more
** Gurus could anyone of you help me with what could be the issue and how can i resolve this.
Thanks in advance,
Shrinidhi Joshi