Skip to Main Content
Forums

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Feedback: Documentation for "Deploying Infrastructure using Terraform Workshop"

Wade W-OracleAug 6 2021

Hi,
I've just completed the "Deploying Infrastructure using Terraform Workshop" and would like to provide two pieces of feedback.
The terraform-demo.zip file no longer contains terraform.tfvars per the instructions. It looks like variables.tf should be modified instead.
An error occurs while creating the compute instance. Searching on the image ID it seemed OK to me (Oracle Linux 7.9) so I tried a few different shapes anyways but eventually let it go.

Error Message: Shape VM.Standard2.1 is not valid for image ocid1.image.oc1.iad.aaaaaaaajlpkjb5lpw36fx2nsxmw7cxle2r5ox7wtj3wcgnvviih6p725jba.

Note that terraform-demo.zip was downloaded per the instructions using:

curl https://objectstorage.us-ashburn-1.oraclecloud.com/p/XXL2U0n_53VH8Rl9s3M0okgSRgxI41o9lcTkuk-cB5hA7L9tOma0YKKC54Btl0g9/n/ociobenablement/b/hol-labs/o/terraform-demo.zip -o terraform-demo.zip

Comments

Check if your Windows temp is not full.
Test the Database connection(SYS) from local or from the same machine where you are installing FMW.
Test the DB connection on FMW machine using SQL*plus and SQL Developer. If you do not have SQL*plus, install the instant client to test the Database connection https://www.oracle.com/database/technologies/instant-client/downloads.html
Check for the DB alert/listener logs if the connection from RCU is made to the Database.
If nothing works, enable SQL*Net tracing and check what is happening post you give DB credentials in RCU.
Thanks, Suresh

SANPAT

Dear Suresh,
Checked all your given 5 points, but didn't find any problem, even able to login.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ppn)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date 29-NOV-2021 10:28:50
Uptime 0 days 0 hr. 35 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\App\Oracle19c\network\admin\listener.ora
Listener Log File C:\App\Oracle\diag\tnslsnr\ppn\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ppn.primepak.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ppn.primepak.com)(PORT=5500))(Security=(my_wallet_directory=C:\APP\ORACLE\admin\ppn\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ppn" has 1 instance(s).
Instance "ppn", status READY, has 1 handler(s) for this service...
Service "ppnXDB" has 1 instance(s).
Instance "ppn", status READY, has 1 handler(s) for this service...
The command completed successfully

SQL> SELECT name,VALUE FROM V$DIAG_INFO where name = 'Diag Alert';
NAME--------------------------------------------------------------
VALUE--------------------------------------------------------------------------------
Diag Alert
C:\APP\ORACLE\diag\rdbms\ppn\ppn\alert

sanjay

Moving this thread to a more appropriate area. Posting in "Forms" was not the right place for this issue.

1 - 3

Post Details

Added on Aug 6 2021
#resource-manager-terraform
0 comments
202 views