DIFFERENCE BETWEEN ORACLE AND MySQL -01

Share via:

DIFFERENCE BETWEEN ORACLE AND MySQL.

  • The Oracle Database is an object-relational database management system (ORDBMS).
  • MySQL is an open source relational database management system (RDBMS).
    Both the Oracle Database and MySQL are database management systems currently produced and managed by the Oracle Corporation.
  • The Oracle Corporation is a multinational computer technology corporation based in Redwood City, California, USA.
  • It specializes in developing and marketing computer hardware systems and enterprise software products.
  • The company also builds tools for database development and systems of middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software.

Here i’m listing 10  differences between ORACLE & MySQL.

Differences between Oracle and MySQL
SNO ORACLE MySQL
1 The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS).
MySQL is the world’s most used RDBMS, and runs as a server providing multi-user access to a number of databases.
2 In Oracle, Database and schema have different meanings. In MySQL, Database and schema are same.
3 In Oracle we have pfile and spfile to make changes to database(Parameters) In MySQL we have my.cnf file to make changes (Variables)
4 Default location of Pfile or SPfile is $ORACLE_HOME/dbs
Ex : cat $ORACLE_HOME/dbs/init$ORACLE_SID.ora
Default location of my.cnf file is /etc/my.cnf.
Ex :$ cat /etc/my.cnf
5 Oracle will run with default port 1521 MySQL will run with default port 3306.
port=3306 in my.cnf file
6 Oracle have Tablespace,Role Managment,Snapshots,
Synonyms and Packages.
MySQL does not have Tablespace, Role management, snapshots, synonym
and packages.
7 Oracle requires username, password, and profile validation at the time of logging.
Sqlplus / as sysdba
For remote connection
Ex : Sqlplus scott/tiger@tnsname
Connecting to different databases on same server.
net_service_name=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=host1)(PORT=1630))
(CONNECT_DATA=
(SERVICE_NAME=service_name)))
Ex :sqlplus scott/tiger@net_service_name
MySQL requires username, password, and host.(Mentioning host is not mandotory )
Ex : $mysql -uroot -ppassword
To connect remotely.
Ex :$ mysql -uroot -ppassword -h 192.168.0.150Connecting to different instances on same server.
Ex :$ mysql -uroot -ppassword -h 192.168.0.150 -p 4205
Note :We need to use different port numbers to connect different instances.
8 In Oracle to check database details we have v$database dictionary views In MySQL we have show databases command.
Ex : mysql> show databases;
9 In Oracle to check currently connected session
we use v$Session view
In MySQL to check currently connected session we use

Ex : mysql> show processlist;

10 Oracle Support Pl-SQL, in addition to SQL MySQL also support SQL & Pl-SQL.

 

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (7 votes, average: 4.29 out of 5)
Loading...

Add Comment