Hello,
I started working with Node.js and oracledb in order to access the database.
I'm testing this on Application Container Cloud and the Database Cloud.
I followed the tutorial : Oracle Application Container Cloud Service: Building a RESTful Node.js Web Service with Oracle Database Cloud Service
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/apaas/node-cloud-REST-DB/nodecloud-RESTDB.html#section4
It looks there are some errors in the tutorial
Amongs others the connection properties. Below the described connection setup from the tutorial, deployment in this way is not possible,
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
var connectionProperties = {
user: process.env.NODE_ORACLEDB_USER || "oracle",
password: process.env.NODE_ORACLEDB_PASSWORD || "oracle",
connectString: process.env.NODE_ORACLEDB_CONNECTIONSTRING || "localhost/xe"
};
I changed the connection to the following (I copied the connection string from the DB Cloud instance)
var connectionProperties = {
user: process.env.NODE_ORACLEDB_USER || "MyUser",
password: process.env.NODE_ORACLEDB_PASSWORD || "MyPassword",
connectString: process.env.NODE_ORACLEDB_CONNECTIONSTRING || "[IP ADDRESS DB SERVER]:1521/[PDB].[XXXX]"
};
Now the application deployment fails one step further
ORA-01045: user [DEMO-USER] lacks CREATE SESSION privilege; logon denied
I created this DB user with the following privilges/roles
CONNECT, CREATE SESSION, RESOURCE
I am able to connect from SQL Developer towards the DB Cloud instance.
What could be the reason of this issue?
I even tried adding DBA privileges to the DB user, same result.
Thanks
Léon