Oracle Converged Database for Developers - Series

Ettore Volpicelli-Oracle

Did you join us during one of the sessions or you had the chance to watch on demand? Please submit here your questions!

A note from our Oracle Instructors:

Before starting LAB 11 ORDS please do the following steps to change the ORDS_PUBLIC_USER:

Launch your browser to the following URL:

http://[your instancepublic-ip address]:8080/guacamole

2. Provide login credentials

Username: oracle

 Password: Guac.LiveLabs_

3. Click on Terminal icon on the desktop to start a terminal

. oraenv

 convergedcdb

 sqlplus / as sysdba

 alter user ords_public_user identified by Oracle_4U;

 exit

4. Stop compute instance

5. Start compute instance and database

User_R9X6Q

I joined the training session "Oracle Converged Database for Developers" on 11th February 2021 and have created a free trial cloud account for this session.

I created one stack and after some successful attempts with its jobs finally I deleted the stack. After that I have created the second stack with a new public key. I have troubles with this new stack. The stack looks OK, it's status is available.

But I'm not able to create an "Apply" job in this stack. Every time the job finishes with the "failed" status with this error:

Error: 400-LimitExceeded

Service: CoreInstance

Error Message: The following service limits were exceeded: standard-e2-core-count. Request a service limit increase from the service limits page in the console.

OPC request ID: efc6f14f292ff1d22cdb06a9769e8ac6/E246D6CD41C8E40F760F8D89280B66CA/3F95D3D1F5928B5A5D7DD68877DDF2F5

Suggestion: The following service limits were exceeded: standard-e2-core-count. Request a service limit increase from the service limits page in the console.

 on instance.tf line 9, in resource "oci_core_instance" "cvgdb-workshop"

   9: resource "oci_core_instance" "cvgdb-workshop" {

I tried to create a "destroy" job and a "plan" job, both of them finished successfully. But still it is not possible to create an "apply" job, with plan resolution automatically approve or with the created plan job, every time it fails with the error described above.

Associated resources of the failed apply jobs (same for all):

Could you please help me with it?

Thanks.

VictorMartin-Oracle

https://community.oracle.com/tech/developers/discussion/comment/16785070#Comment_16785070

Hello,

Thanks for attending the workshop.

Your trial account has service limits applied by default to protect your credits if someone launches more than they expected or any expensive services. Compute has different service limits depending on the shapes (the machine's size: number of CPUs, etc.).

The error message you got:

Error Message: The following service limits were exceeded: standard-e2-core-count. Request a service limit increase from the service limits page in the console.

It tells us that you don't have the count for VM.Standard.E2 shapes. I recommend you to identify what shapes you have instances and edit the stack accordingly.

• View Service limits: Open the Console. Open the navigation menu. Under Governance and Administration, go to Governance and click Limits, Quotas and Usage.
• Edit your (active) stack: Go to your stack and click Edit, review the shape used on your stack and change it to the one with available shape count.

After that, you should be able to run the apply job successfully.

NOTE: Another feature to check the number of compute instances and other resources in your tenancy is Tenancy Explorer. It is the best way to identify any compute with the shape you are running off.

I hope this help!

user578783

Hi, Following this lab and hit a problem. I'm creating the resource stack using region UK South(London) . In the configuration variables page, under Options, the INSTANCE SHAPE drop-down is greyed out, there is no option to populate it. Obviously can't get any further creating the stack without this. Any ideas - something to do with being on an always free tier account?

VictorMartin-Oracle

https://community.oracle.com/tech/developers/discussion/comment/16785378#Comment_16785378

Hello and thank you for joining us at the Workshop.

The common scenarios for that to happen is that your trial is expired or run out of free credits. Did you create a new trial with us on that day? Brand-new trials should be fine with Flex/NoFlex shapes, basically turning on or off the checkbox.

To check the shapes' availability, you can go to View Service Limits documentation that explains the steps. With that information, we should be able to help you more.

Hope this help, and don't hesitate to come back and post an update.

user578783

https://community.oracle.com/tech/developers/discussion/comment/16785397#Comment_16785397

Thanks for that, I was trying to use my Free Tier (always free) account which doesn't have credits. Problem is with registering a new account for every demo/oracle lab etc is that you end up with lots of cloud accounts! Thanks again.

VictorMartin-Oracle

https://community.oracle.com/tech/developers/discussion/comment/16785698#Comment_16785698

Some of the live labs can be done with Always Free. Converged DB is definitely an exception. I will raise the issue of having to create a lot of cloud accounts. Thanks for the feedback!

Dr. Minale Ashagrie

Hi their

I joined the February 11th first session and configure the Trial account successfully

Moreover I was able to connect the virtual (graphic) desktop using my public IP based on Lab 4 (Initialize Environment)

When I attempt to connect to the virtual desktop I got the message as shown below. I tried several times but not able to connect to the graphic desktop

Can you please recommend me how to fix this problem?

I thank you in advance

User_PP2WK

Hi,

I am still stuck. I was able to get through up to the end of labs 5. But I cannot get past 6:

I am getting two (2) main issues. outlined below

1. I try to go to http://<my_generated_ip>:8080/guacamole

but I get website unavailable. So I can't login that way.

1. (auto formatting eh)
2. Also, when I try to run the script .env_setup_db-workshop.sh

I get a few permission denied . I don't get the "Finished starting servers" . A bit frustrating since that's the end of that workshop.

Okay, I missed this completely on the 10th. I can see it after pasting the output from console into notebook.

There are a few Invalid username/password; logon denied errors --

ERROR: ORA-01017

and ERROR : ORA-01005 : null password given

It's asking for a password but I don't know what it should be? is it the one(s) we have already been using? I attach the file

Oracle_script_Output.txt

Solutions: ? for issue 1 I think it's to do with firewall. We have a policy here of blocking almost everything and then unblocking specific services. so we tend to have to do it for each saas we have to use. Unfortunately I'm not in charge of that so I have to put in a request but I need to know IP ranges, servernames( if possible ) and required ports.

They will probably not clear before the end of this session. ( part 2 ) So I'll be playing catch up. : Now saying all that. I actually went home and tried it from there but found I couldn't even connect so maybe Issue 1 is connected to Issue 2?

GeorgeConstantin-Oracle

https://community.oracle.com/tech/developers/discussion/comment/16786426#Comment_16786426

Hi Minale, please try the following workaround.

$ sudo su - oracle

$ vncserver -kill :1

$ vncserver

Root cause: This is the VNC session that guac uses not restarting. Usually caused by a vnc lockfile, the fix is to ssh on as opc and execute the above commands.

fkeles-Oracle

https://community.oracle.com/tech/developers/discussion/comment/16786442#Comment_16786442

@User_PP2WK

Your guacamole session is up and running. You should try using it, it saves you from a lot of hustle. Just replace <my_generated_ip> with your public IP which I was able to obtain from your attached document, and it is running.

For Permission Denied messages, it is generally related to user. You should run env_setup_db-workshop.sh script with oracle user. Switch to with "sudo su - oracle" then execute the script.