oracle/dino-date

DinoDate is "a fun site for finding your perfect Dino partner". It is a learning platform to showcase Oracle Database features using examples in multiple programming languages.

dino-date's Issues

12g2

Can you release DinoDate so it works with 12g2, 18c, and 19c?

Make purpose more clear on home pae

The home page needs to both (a) project the fun/silliness of DinoDate (Strength in numbers and Based on science) and (b) the serious aspect (Learning Platform). Right now they are blended, and it is hard to tell what is what.

Please make very clear that this is primarily about learning how to leverage Oracle DB for appdev.

Also, Home does not take you home.

Node messages.js missing sendMessage

The sendMessage function was never added to the Node layer.

Without this function, the Node version is unable to send an individual message from one member to another.

Add on a footer: Powered by Oracle Database, Oracle Jet and ORDS

Additional schemas missing from installation instructions

The installation instructions warn about the need to create a schema called DD but don't warn about the other two schemas that are also dropped and created as needed: DD_LOGGER and DD_NON_EBR. Please update to include this information. Thanks!

Create environment with Docker

Would be very useful having a Docker environment to automate the installation process.

I'll work in this feature and going to make a pull request.

SQLPlus

Could not install with SQLPlus (watch out because the article advises to use it). We could install it with Toad or SQL Developer.

Installation yields error ORA-955: name is already used by an existing object

This occurs at the attempt to create index DD_FT_MEMBERS

Markdown error in RestfulAPI.md

Several tables not formatted correctly

example:
| Header Variable | Type | Required | Details | | ------------- |:-------------:|:-------------:|:-------------:|:-------------| | userToken | Number | Yes | Value returned from login |

ORA-65096: invalid common user or role name

Just downloaded the Dino Date app for Oracle 19.3 recently and I get the "ORA-65096: invalid common user or role name" error:

[oracle@localhost coreDatabase]$ sqlplus sys@orclcdb as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 5 01:16:15 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> @dd_master_install

PL/SQL procedure successfully completed.

CREATE USER dd IDENTIFIED BY dd
            *
ERROR at line 1:
ORA-65096: invalid common user or role name


Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost coreDatabase]$

The documentation says this about the error:

ORA-65096: invalid common user or role name
Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must consist only of ASCII characters, and must contain the prefix specified in common_user_prefix parameter.

Action: Specify a valid common user or role name.

All Oracle Components Required!!!

Hi, in order to be able to perform a clean install of Dino-date... we had to install all the components of Oracle (Oracle Text, Spatial, Olap, etc...). As you know, this are components that cause your costs to increase (a lot) as must be licensed... so, we wanted to know if we can install dino-date without having to deploy components that we know that our database is not required to use (Eg. Spatial, etc...).
Thanks.

Merge send message and broadcast message functionality

There's no need to have separate API endpoints for sending a message and a broadcast.

Will need to change:

• /nodejs/routes/route.js
• /python/app.py
• /commonClient/app/components/inbox/inbox.js
• /RestfulAPI.md

Add another attribute "messageType" to the message. Use the values 'broadcast' and 'single' to route message functionality.