DirkNachbar / Docker

Docker image for Oracle Forms & Reports
GNU General Public License v3.0
44 stars 56 forks source link

Database connection and file permission issues #4

Open ysdkzhh opened 6 years ago

ysdkzhh commented 6 years ago

Hi, I did the following according to the readme file:

 mkdir -p /opt/oracle/oradata
 mkdir -p /opt/oracle/user_projects
 # Make sure that your oracle user on the Docker Host got:
 # uid=54321(oracle) gid=54321(oinstall)
 chown -R oracle:oinstall /opt/oracle/oradata
 chown -R oracle:oinstall /opt/oracle/user_projects
 chmod -R 777 /opt/oracle/oradata
 chmod -R 777 /opt/oracle/user_projects

I also have a running database that I can connect from my laptop, and modified DC_HOSTNAME, SID, PDB in the setenv.sh file to connect to that database. But I got the following errors with database connection:

    RCU Logfile: /tmp/RCU2018-10-25_18-33_1725930400/logs/rcu.log

Processing command line .... Unable to connect to the database using the provided details. Enter a valid hostname and port or check if the listener is up and running.

ERROR - RCU-6090 Connection step validation failed. CAUSE - RCU-6090 Skipping main operation: failed to connect to database because database details were missing or invalid. ACTION - RCU-6090 Provide correct database details and try again.

and then a few steps down this error:

--> Step: writeDomain and closeTemplate

com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: Error writing domain: com.oracle.cie.domain.script.ScriptException: 60308: Domain location not writable. 60308: The domain location does not have write permission. 60308: Correct permissions or select different domain location.

Error: runCmd() failed. Do dumpStack() to see details. mkdir: cannot create directory '/opt/oracle/user_projects/domains': Permission denied

Can you please tell me what I missed here and how to fix the errors?

Thanks, Heather

oraclejoshi commented 5 years ago

Hi Dirk,

We are also facing same issue for RCU connection as stated above.... can you please help in resolving the same

dbissue

gururaj0 commented 5 years ago

I edited the setenv.sh script to replace with actual values from your DB/container.

Repository Connect export DC_DBUSER=sys export DC_DBPWD=A1B2_c3d4# export DC_DBROLE=SYSDBA export DC_COMPONENTPWD=A1B2_c3d4# export DC_SCHEMA_PREFIX=${DC_DOMAIN_NAME} export DC_DB_HOST=xxxxxxxxxx export DC_DB_PORT=${DC_ORCL_PORT} export DC_DB_SERVICE=${DC_ORCL_PDB} export DC_DB_OMF=false export DC_DB_USER_PW=A1B2_c3d4# export DC_PWDFILE=/tmp/passwords.txt

--

rpcarun commented 4 years ago

Hi Dirk, Please help to resolve the issue in creating RCU. Tried using the same credentials to connect to the DB from the container and its getting connected. But RCU fails with database details are missing or invalid.

Also, getting 60308: The domain location does not have write permission error. The folder structure has 777 permission from root to last folder.

TauqeerAhmad104 commented 2 years ago

Did anyone Fixed this issue? I am facing the same problem and no luck so far. Please shear if you managed to make it work.

kk-hiraskar commented 1 year ago

Same issue :-(

time="2023-08-30T15:37:41Z" level=info msg="Using caching dir: xxxxxxxxxxx"
time="2023-08-30T15:37:41Z" level=info msg="Using 'xxxxx' backend"
time="2023-08-30T15:37:41Z" level=info msg="Using caching dir: xxxxxxxxxxx"
time="2023-08-30T15:37:41Z" level=info msg="Using 'xxxxx' backend"

        RCU Logfile: /tmp/RCU2023-08-30_15-37_649442477/logs/rcu.log

Processing command line ....
Unable to connect to the DB. Check if DB connection details entered are correct. 
   Invalid username/password.
Enter valid username/password

ERROR - RCU-6090 Connection step validation failed.
CAUSE - RCU-6090 Skipping main operation: failed to connect to database because database details were missing or invalid.
ACTION - RCU-6090 Provide correct database details and try again.