MySQL Forums - Oracle

HTML tags and special characters issue (1 reply)

Koushik Neelakantha — Fri, 25 Aug 2023 11:13:59 +0000

Hello everyone,

We are facing special characters and HTML tags issue in our data. we are trying to load the data from Hive to Oracle DB through IICS(informatica cloud).Hive data is populating correctly but data in oracle is getting populated with HTML tags and some special characters. This is for datatype CLOB columns only.

Need help to remove the tags and characters.

Regards,
Koushik.

Oracle's Sequence alternatives in MySQL (1 reply)

Julián Jorge Sanmartino — Sun, 09 Jul 2023 22:04:47 +0000

We are migrating all our applications from OracleDB to MySQL, and we have some concerns. We want to know if MySQl covers the next feature offered by OracleDB:
- Sequences: We use sequences to generate the primary keys of our data, is it possible to do the same in MySQL? We care a lot about the performance when inserting new values, and I've been told that MySQL's auto increment is slower than Oracle's Sequences.

Also, does the MySQL paid version offer support for migrating from oracle to MySQL? Is there a tool to automatically migrate all data?

Can't Connect To MySQL Local Database From Local Node App (1 reply)

Kon Tiki — Thu, 18 Nov 2021 18:57:13 +0000

CONSOLE OUTPUT
==============

[nodemon] starting `node app.js`
HTTP Server for NodeApp started at port 3000
We're in to the back end of NodeApp !
Someone has POSTed data to the Node server ...
URL trimmed endpoint: reg-user
Input Value: tamjk
In router.js now ...
Endpoint: reg-user Data: tamjk
Handler: authen.js
In handler authen.js now ...
Mode: reg Field: user Value: tamjk
In format validation now ...
Format Validation Message: Valid format
Connecting to user-data database checking user ...
In MySQL Query script now ...
Query: SELECT user FROM users WHERE user = 'tamjk'
Router returned message undefined
Callback Message: undefined
Message: undefined
Sent back response: undefined
_http_outgoing.js:696
throw new ERR_INVALID_ARG_TYPE('first argument',
^

TypeError [ERR_INVALID_ARG_TYPE]: The first argument must be of type string or an instance of Buffer or Uint8Array. Received undefined
at write_ (_http_outgoing.js:696:11)
at ServerResponse.write (_http_outgoing.js:661:15)
at reqCallback (/home/sandbar/Desktop/nodeapp-local/app.js:116:6)
at IncomingMessage. (/home/sandbar/Desktop/nodeapp-local/app.js:87:10)
at IncomingMessage.emit (events.js:327:22)
at endReadableNT (_stream_readable.js:1327:12)
at processTicksAndRejections (internal/process/task_queues.js:80:21) {
code: 'ERR_INVALID_ARG_TYPE'
}
[nodemon] app crashed - waiting for file changes before starting...

How do I calculate my Storage Clause values? (no replies)

Naveen Thinarthan — Thu, 05 Aug 2021 10:20:51 +0000

Hey, can someone please tell me how do i calculate the values for my storage the one i have here doesn't work and throws a error. Thank you very much.

Create table MOVIE

(

MOVIE_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_NAME Varchar2(55),

MOVIE_RELEASE_DATE date,

MOVIE_RATING Varchar2(5) DEFAULT 'NR',

CHECK (MOVIE_RATING = 'G'OR MOVIE_RATING = 'PG' OR MOVIE_RATING = 'PG-13' OR MOVIE_RATING = 'R' OR MOVIE_RATING = 'NC'),

TOTAL_SALES number(10),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);

CREATE TABLE Producer(

Pro_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL UNIQUE,

Pro_fname Varchar2(30),

Pro_lname Varchar2(30),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);

CREATE TABLE Theater(

Tht_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

Tht_name Varchar2(55),

Tht_address Varchar2(350),

Tickets_sold NUMBER(19),

CHECK (Tickets_sold >=0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);

CREATE TABLE Ticket_Price(

Ticket_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

Tht_ID number(10) NOT NULL UNIQUE,

Ticket_Price number(10) ,

CHECK (Ticket_Price >=0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

FOREIGN KEY (Tht_ID) REFERENCES Theater(Tht_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);

CREATE TABLE Main_Actor(

Actor_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

First_Name Varchar2(20),

Last_Name Varchar2(20),

Payment_amount number(10),

CHECK (Payment_amount >0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);

CREATE TABLE Supporting_Actor(

sActor_ID number(10) PRIMARY KEY NOT NULL,

MOVIE_ID number(10) NOT NULL,

First_Name Varchar2(20),

Last_Name Varchar2(20),

Payment_amount number(10),

CHECK (Payment_amount >0),

FOREIGN KEY (MOVIE_ID) REFERENCES MOVIE(MOVIE_ID),

STORAGE (INITIAL 1G NEXT 50K MINEXTENTS 1 MAXEXTENTS 5 PCTINCREASE 50 )

);

Unable to start msyqld service after modifying datadir from default /var/lib/mysql to /u01/mysql (1 reply)

Jamsher Khan — Tue, 22 Dec 2020 17:25:23 +0000

Hi,

Mysql Version : Server version: 8.0.22 MySQL Community Server - GPL
OS Version : OEL 7.9

I am unable to start mysqld service after I changed datadir location from default /var/lib/mysql to /u01/mysql

2020-12-22T13:28:34.343524Z 0 [Warning] [MY-010091] [Server] Can't create test file /u01/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2020-12-22T13:28:34.343623Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 68273
2020-12-22T13:28:34.348703Z 0 [Warning] [MY-010091] [Server] Can't create test file /u01/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2020-12-22T13:28:34.348716Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /u01/mysql/ is case insensitive
2020-12-22T13:28:34.349653Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-12-22T13:28:34.349907Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22) MySQL Community Server - GPL.

Please help to fix this issue.

Best Regards
Jamsher

MySQL CPU usage and CPU wait (no replies)

Yossi Nixon — Sun, 06 Dec 2020 11:51:36 +0000

Hi,
For Oracle and SQL Server we could get the CPU usage and CPU wait information at the statement/request level, is there any equivalent in MySQL?

Variable select_full_join (1 reply)

George Kup — Fri, 06 Nov 2020 14:56:08 +0000

Hello. If the select_full_join variable is increased, then, as they say in the manuals, it is necessary to take all measures to optimize queries. But if a ready-made program is used and queries cannot be optimized, can the join_buffer_size parameter be increased? Will it give something.

MySQL Vs Oracle (no replies)

Aqib Gulzar — Wed, 21 Oct 2020 10:14:03 +0000

What are the advantages of MySQL when compared with Oracle?

Help me to convert oracle data base into SQL (3 replies)

John Thombson — Fri, 07 Aug 2020 16:34:56 +0000

My website is https://packagingbee.com and I want my database to be converted from oracle to MySQL. Plz help currently I', using wordpress

How to read an Online view available in oracle from MySQL (1 reply)

Alex Kuruvilla — Thu, 11 Jun 2020 14:42:50 +0000

How to read an Online view available in oracle from MySQL.I need to read the data from MySQL.
From Oracle I can read MySQL Data through DB Link.
Regards,

Is there PL/SQL like backend langauge in MySQL? (1 reply)

Sebastian Vasta — Sun, 31 May 2020 19:58:36 +0000

Hi, new to MYSQL.

I want to know if MySQL has an equivalent to PL/SQL in Oracle???

Does MySQL have packages, functions, procedures, data types like PL/SQL???

Migrating data from oracle to mysql (1 reply)

Hemkalyan Pal — Tue, 23 Jun 2020 22:58:44 +0000

I need to migrate the data from oracle 12c to Mysql latest community version how to migrate easily please suggest for migrate the data. Thanks in advance.

Get last record/row in a table (1 reply)

Michael Pettinicchi — Sat, 21 Sep 2019 21:02:30 +0000

I want to get the last record/row in a table. I believe the way to do it is by using "order by" but in reverse order. But how do I specify "reverse order"?

Migrating data from oracle to mysql (1 reply)

sreekanth pm — Tue, 12 Mar 2019 14:49:22 +0000

Hello everyone,

I need to migrate the data from oracle 12c to Mysql community version 5.1. I have tried with option migration wizard using Mysql work bench. But no luck it not working.. Any idea to migrate the data. Thanks in advance.

Database Migration from Oracle to MySQL (1 reply)

vicky garg — Tue, 05 Mar 2019 21:27:26 +0000

I have Oracle database and I want to migrate tables and Store procedures from Oracle to MySQL.Please suggest any tools to do this task.

How to skip the validation of primary Key in MYSQL (1 reply)

krishna kumar — Wed, 11 Jul 2018 00:37:50 +0000

i am trying to migrate the database from oracle to MYSQL. Oracle has duplicate values in a table, i am assuming primary key might have been enabled with novalidate option. Could someone guide me the equivalent method to perform the same in MYSQL.

Note:- i have tried 'alter table table_name add primary key (column1, column2) enable novlidate' , but this didnt work.

Migrate oracle database to Mysql (3 replies)

Amar Prabhat — Thu, 24 May 2018 08:14:17 +0000

Hello Everyone,

I need to migrate my oracle database to MySQL. Please guide me on the options, how I can migrate it whether by using an open source tool, paid tool or by any other way.

Thanks in advance. Any help appreciable.

migration issue from mysql5.7.17-log to oracle11g (no replies)

Rajesh K — Tue, 24 Apr 2018 16:53:11 +0000

when trying to migrate from mysql5.7.17-log to oracle11g, I am getting error as "migration actions have failed. check the migration reports for details: capture classic capture you have an error in SQL syntax. Check the manual that corresponds to your MYSQL server version for the right syntax to use near '-old' at line 1". Please suggest how to get rid if this. Thanks

C (1 reply)

Rajesh K — Fri, 30 Mar 2018 16:40:02 +0000

I AM CURIOUS TO KNOW WHY THERE IS ANOTHER DB FROM ORACLE WHERE THRE IS ALREADY ONE. LONG STORY SHORT WHAT WAY MYSQL IS SPECIAL THAN NORMAL ORACLE.

DISABLING a TRIGGER and RESTARTING one database in MYSQL (1 reply)

HITESH SHETTY — Fri, 22 Dec 2017 15:35:35 +0000

Hello Experts,

I am in need to disable a specific trigger "SET_DUE_DATE" which has been set for a particular DB, and then i need to restart that DB alone.

Can you help me with the steps to be followed. I would also need your help to see if this trigger has been disabled, post disabling.

Please let me know how i can achieve this.

mysql command line client (no replies)

Bernhard Sept — Fri, 12 May 2017 15:41:49 +0000

Hello!

How can I install the mysql command line Client for the mysql Oracle Server?

I am running a Windows machine, where I see mysql in start - Programme - Mysql Folder.

However I do not see any link to the mysql command line Client.

I opend the Windows command line and entered mysql -help: nothing happened

I hope someone can help me

Regards

Bruno

link between oracle and mysql (no replies)

suresh kumar — Fri, 07 Apr 2017 23:48:05 +0000

SQL> select * from bike @link1;

mno bname count
---------- ---------- ----------
duke ktm 6
apache tvs 29
activa honda 24
fz-16 yamaha 16

SQL> select mno from bike;

MNO
----------
duke
apache
activa
fz-16

SQL> select mno from rsk.bike @link1;
select mno from rsk.bike @link1
*
ERROR at line 1:
ORA-00904: "MNO": invalid identifier

i have created a link for mysql in my oracle but i can select all the rows
you can see that on the above code then why cann't access the single row from
mysql. And also i can't update the specific value in mysql via oracle using link

How to replace the TABLE identifier generator with either SEQUENCE or IDENTITY in a portable way (no replies)

Edwin Desouza — Wed, 18 Jan 2017 03:21:54 +0000

How to replace the TABLE identifier generator with either SEQUENCE or IDENTITY in a portable way

https://vladmihalcea.com/2017/01/17/how-to-replace-the-table-identifier-generator-with-either-sequence-or-identity-in-a-portable-way/

Invalid column number - Delayed binding at fetch time failed (no replies)

Ashok Kumar Jayaraman — Mon, 12 Dec 2016 05:15:12 +0000

Hi

We use Informatica service to read from MySQL DB. We are experiencing an inconsistent issue where the job fails with the below error. When we simply restart the job, it completes without any issues. The columns are mapped to their corresponding equivalent data types available in Informatica and most of the times the job completes without any issues.

Can you please advise what situation the below error would occur?
Note:
It takes less than 5 mins to complete the job, but whenever there is issue, the job runs for over 2 hrs and then eventually gives the below error, at which point we restart the job that completes as expected.

2016-12-11 13:46:40 : ERROR : (43956 | READER_1_2_1) : (IS | uat_integration_service_bd) : node09_dukebiqd88 : RR_4035 : SQL Error [
FnName: Bind Col -- [MySQL][ODBC 3.51 Driver][mysqld-5.6.20-log]Invalid column number
Database driver error...Delayed binding at fetch time failed.].

connecting MySQL to Oracle database (2 replies)

sonu jha — Sun, 13 Nov 2016 06:29:40 +0000

Hi,

How can I connect MySQL 5.6 to Oracle 11g database to fetch data from Oracle database tables.

MySQL is installed on a Windows server 2012 in a Virtual machine and Oracle database is on Linux.

Thank you.

ndb cluster data node ulimit settings (no replies)

Subhajit Chakraborty — Fri, 14 Oct 2016 12:54:04 +0000

In an NDB cluster setup on a VM environment, we have configured management node, data node and sql node in a single node, with 2 servers in cluster.

So both nodes have management node, data node and sql node components.
What should be the value for "max locked memory". It's 64KB by default on most Linux systems; of course, this is very small for a data node.

Whats the implication of setting it to "unlimited" in an NDB cluster environment? Whats the use of this parameter?

NDB Server version: 5.6.29-ndb-7.4.11-cluster-commercial-advanced-log
Storage provisioned through Oracle VM
OS: RHEL 6.5

Convert stored procedure from Oracle to MySQL (no replies)

Anil Vidhani — Tue, 20 Sep 2016 08:23:39 +0000

Hi All,

I want immediate help to convert below stored procedure from oracle to mysql migration project. please help me out.

mostly the issue with how to achieve start with .... connect by and start with ...connect by prior.

delimiter //
create PROCEDURE SP_Recon_Limit(IN p_le_short_name varchar(4000),
IN p_br_short_name varchar(4000)
)
BEGIN
DECLARE v_txn_exists integer default 1;
DECLARE v_parent_facility integer;
DECLARE v_facility_nt facility_nt;
DECLARE connect by
declare c_facility cursor for
select distinct a.ADV_FACI_ID,
a.CURRENCY_ID,
a.OBLIGOR_ID,
a.ADV_FACI_AMOUNT,
a.ADV_FACI_NAME,
case (select 1 from m_obligor where obligor_id = a.obligor_id and reference_id like 'H%') when 1 then 'Y' else 'N' end as IS_DUMMY,
(case when exists(select 1 from t_advance_facility where parent_advf_id = a.ADV_FACI_ID) then 'Y' else 'N' end) as IS_MULTIENTITY
from t_advance_facility a
where a.valid_flag = 'T'
and a.parent_advf_id is null
and a.LEGAL_ENTITY_BRANCH_ID in (select sk_legal_entity_branch_id from r_legal_entity_branch
where LEGAL_ENTITY_ID = (select sk_legal_entity_id from m_legal_entity where legal_entity_shortname = p_le_short_name)
and BRANCH_ID = (select branch_id from m_branch where branch_shortname = p_br_short_name))
and (a.ADV_FACI_STATUS in (6,21,16,26,27,30,43)
or (a.ADV_FACI_STATUS in (9, 8, 11, 7, 24, 25) and a.ADV_FACI_AMOUNT > 0)) prior
a.adv_faci_id = a.parent_advf_id;
cursor c_sub_facility(f_id in number) is
select ADV_FACI_ID,
CURRENCY_ID,
OBLIGOR_ID,
ADV_FACI_AMOUNT,
ADV_FACI_NAME
from t_advance_facility
where parent_advf_id = f_id;
begin
delete from dbs_recon_limit;
declare v_facility cursor for c_facility LOOP
BEGIN
SAVEPOINT start_transaction;
select ADV_FACI_ID bulk collect into v_facility_nt from t_advance_facility
start with ADV_FACI_ID = v_facility.ADV_FACI_ID
connect by prior adv_faci_id = parent_advf_id;
end SP_Recon_Limit;
//
delimiter;

Help convertin pl/sql to mysql (no replies)

Bob Bell — Fri, 15 Jul 2016 15:51:31 +0000

I am in need of converting the following pl/sql to mysql, and thought this community might be able to help. Having
a heck of time emulating in MySql. It is the subtraction/addition of the interval statement with the julian part that
I cannot figure out. I will also, post in some MySql areas, and any insight appreciated.

trunc(to_number(to_char(sysdate,'j'))/7) - trunc(to_number(to_char(trunc(sysdate,'yy') - interval '3' month, 'j' ))/7) + 1 as sysdate_fiscal_week_offset1,
trunc(to_number(to_char(sysdate,'j'))/7) - trunc(to_number(to_char(trunc(sysdate,'yy') + interval '9' month, 'j' ))/7) + 1 as sysdate_fiscal_week_offset2

Thanks,
Bob

Windows server 2012 IIS 8 php data post upload failure to mysql (no replies)

james romine — Mon, 16 May 2016 05:37:23 +0000

Hello, I'm getting a php data upload fail when attempting to transfer data up to a mysql database from a html5/webgl built app off of Unity. All of the data downloads work regardless of the upload issue. The upload issue happens after an indeterminable amount of time.

The only error I'm seeing anywhere is :
A fatal alert was generated and sent to the remote endpoint. This may result in termination of the connection. The TLS protocol defined fatal error code is 10. The Windows SChannel error state is 1203.

This is only happening when the server is booted up however. The server is an EC2 Amazon m4 large. No errors can be found for each attempt to post data to the mysql database. The downloads can be seen being pulled in the cpu usage and then upload fails afterwards.

This has happened once before, there was a full mysql reinstall, base reload of the table/schema and the problem persisted. Wiped the VM, did an identical install, and everything worked great until the same problem suddenly happened.

I'm leaning towards some time out limit, blocking, or other that has occurred but have been unable to locate any issue.

Any help is appreciated.

Importing .dmp database oracle (no replies)

Marouen Bali — Sun, 13 Mar 2016 08:49:25 +0000

Hi freinds,

I have oracle databases (.dmp files) stored in my machine (not in a server).

I installed Mysql (mysql-installer-community-5.7.9.0)

I installed Navicate lite

how can i process to import my .dmp files to mysql??and using what software

I want a full process to find a solution

Thks a lot