Forum Stats

  • 3,733,054 Users
  • 2,246,687 Discussions
  • 7,856,491 Comments

Discussions

Oracle Converged Database for Developers - Series

Ettore Volpicelli-Oracle
Ettore Volpicelli-Oracle Member Posts: 11 Employee
edited March 4 in Workshops

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

Comments

  • User_R9X6Q
    User_R9X6Q Member Posts: 0

    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
    VictorMartin-Oracle Principal Cloud Engineer Dublin, IrelandMember Posts: 4 Employee

    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
    user578783 Member Posts: 2 Blue Ribbon

    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
    VictorMartin-Oracle Principal Cloud Engineer Dublin, IrelandMember Posts: 4 Employee

    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
    user578783 Member Posts: 2 Blue Ribbon

    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
  • VictorMartin-Oracle
    VictorMartin-Oracle Principal Cloud Engineer Dublin, IrelandMember Posts: 4 Employee

    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
    Dr. Minale Ashagrie Member Posts: 0 Green Ribbon

    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
    User_PP2WK Member Posts: 0 Green Ribbon

    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

    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
    GeorgeConstantin-Oracle Member Posts: 4 Employee
    edited February 25

    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
    fkeles-Oracle Member Posts: 5 Employee

    @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.

  • User_Q0DEZ
    User_Q0DEZ Member Posts: 1 Green Ribbon

    Question about Lab 5 JSON:

    I followed the steps and at step 1: Open sqlplus as the user appjson, I can't connect with the appjson user.

    Step 2, I can't connect to SQL Developer with the prowieded data (Status: Failure -Test failed: IO Error: The Network Adapter could not establish the connection).

    Any idea?

  • fkeles-Oracle
    fkeles-Oracle Member Posts: 5 Employee

    Are you running sqlplus command and sqldeveloper inside your guocamole session or on your own desktop?

    What error message do you see with sqlplus?

    SqlDeveloper connection error might be related to:

    • Wrong IP used as hostname on connection screen. If you are using guacomole use localhost if connecting from your own machine use public IP of the compute instance.
    • Service might be down. Make sure your compute instance is running, you have completed environment setup and initialization steps, and you can connect with guacomole.
  • User_Q0DEZ
    User_Q0DEZ Member Posts: 1 Green Ribbon

    I am running sqlplus command and sqldeveloper inside my guocamole session.

    slqplus:

    Error: ORA-12541: TNS: no listener (so i have to provide the user-name and the password but nothing happend)

    SqlDeveloper connection error:

    The IP is correct. I tried on my own machine using public IP (same error).

    I tried it again using guacomole using localhost (same error)

  • fkeles-Oracle
    fkeles-Oracle Member Posts: 5 Employee


    Great, let's make sure your database and everything else is running.

    • Please open a terminal window inside your guacamole session, make sure you are using oracle user by typing "whoami".
    • If not oracle switch to oracle user "sudo su - oracle".
    • Then navigate to scripts directory "cd /u01/script"
    • and then run the script to start components "./env_setup_db-workshop.sh"

    Exact steps on how to restore after a restart can be found here: http://bit.ly/lab_guide_converged_db_part1

    User_Q0DEZ
  • User_J8GBN
    User_J8GBN Member Posts: 2 Green Ribbon

    Hello,

    I am stuck on lab4 because when I successfully sign into my Guacamole session and try to start the database and applications, I cannot find the directory /u01/script. The folder /u01 is empty, and I can't find the startup script ./env_setup_db-workshop.sh anywhere else on the VM.

    Does anyone know why this could have happened?

    Thank you!

  • User_8UZYU
    User_8UZYU Member Posts: 2 Employee
    edited March 4

    Hi all,

    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


    Thanks,

    Roxana

  • fkeles-Oracle
    fkeles-Oracle Member Posts: 5 Employee

    Hello User_J8GBN,

    This shouldn't be the case. I don't know what was the problem. At this point I would ask you kindly to start over

    • First destroying the erroneous deployment by Resource Manager - Stacks - Your Stack then Terraform Actions dropdown menu Destroy. This will terminate all the resources (network, vm, etc.) created by this stack.
    • Then creating a new stack as described in Day 1 guide here: http://bit.ly/lab_guide_converged_db_part1

    Once you verified everything is as it meant to be you can continue the labs. Feel free to ask questions when you need help.

    Thank you.

  • user12109523
    user12109523 Member Posts: 1 Green Ribbon

    Hello,

    I receive the following error at lab9, while trying to load the graph into memory (step 4):

    The graph was created successfully (step 2) and I was able to query it (step 3), but now I am stuck...

    Could you, please, help me?

    Thank you!

  • fkeles-Oracle
    fkeles-Oracle Member Posts: 5 Employee

    Hello user12109523,

    I think you need to restart your client. Please run ./02_graph_client.sh (Step 1.2) and then /open /u01/script/graph_startup/03_graphload.jsh (Step 1.3) and after these you can continue with Step 4.

Sign In or Register to comment.