Oracle Database and schemas...please help!
-
Greeting Mango Fam. The question I have today is can you install or import OE schema into Oracle 11g XE? Either it's not possible or no one cared to post this scenario online. I'm studying for the for the Associate test. One of the tutorials call for me to work with the OE schema. I learned that it doesn't automatically come with XE.
If I d/l standard to use for my tutorial is there a cost?
If anyone has any valuable resource that they can share to help me prep for this test, I would greatly appreciate it.In advanced, thank you for any and all the help.
-
I initially read that as "mango farm", which isn't as weird as it sounds. Lol.
We are the orchard I guess.
-
Haven't worked with Oracle is over a decade, I'm afraid.
-
I guess no one have knowledge on this subject. This is a first. Hmmm.
-
@MrWright4hire said in Oracle Database and schemas...please help!:
I guess no one have knowledge on this subject. This is a first. Hmmm.
Oracle is super rare in the SMB market. Even in the enterprise space I've rare seen it. Where it exists it's primarily legacy stuff that people want to replace. It would be pretty surprising to have much info on it here.
-
Is there any suggestion as to what field of DB is in the now since Oracle is out?
-
It's not that Oracle is out. Loads of enterprises depend on it. It's depressing to support though, because mostly you are on projects that got stuck with it. It's rarely the database that people choose when they have a choice. Even in big finance it was considered the database of last resort. SQL Server, Sybase, PostgreSQL, MySQL/MariaDB, Cassandra and such here all choices first.
-
You need to define your purpose first. Learning database in vacuum is rather random. What is your goal in learning a database.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
-
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
But the price is way different. Enterprise base license per unit (sockets * cores per socket * core factor) is $47,500, plus another $10,500 for updates/support.
So for 4 machines with a low core count to save money:
4 servers * 2 sockets per server * 8 cores per socket * 0.5 core factor=32
32*$47,500=$1,520,000
-
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
But the price is way different. Enterprise base license per unit (sockets * cores per socket * core factor) is $47,500, plus another $10,500 for updates/support.
So for 4 machines with a low core count to save money:
4 servers * 2 sockets per server * 8 cores per socket * 0.5 core factor=32
32*$47,500=$1,520,000
Yeah. That's because no one uses Oracle by choice. Only those that are stuck and have no option. So they can charge anything that they want.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
@stacksofplates said in Oracle Database and schemas...please help!:
@scottalanmiller said in Oracle Database and schemas...please help!:
It's depressing to support though
This......
And also, there is no normal licensing for virtualized environments. If you have an Oracle VM with 4 cores and your host has 32 cores, you have to pay licensing for 32 cores.
Same as SQL Server in that way.
But the price is way different. Enterprise base license per unit (sockets * cores per socket * core factor) is $47,500, plus another $10,500 for updates/support.
So for 4 machines with a low core count to save money:
4 servers * 2 sockets per server * 8 cores per socket * 0.5 core factor=32
32*$47,500=$1,520,000
Yeah. That's because no one uses Oracle by choice. Only those that are stuck and have no option. So they can charge anything that they want.
Ya it's insane. Large systems like that get so entrenched that it's easier to pay the licensing than to leave.
-
I always wondered why DB2 wasn't more popular. The free version offers much more than Oracle and it's easier to work with (at least in my opinion).
edit: more popular than Oracle. It's still really popular. #6 in rankings http://db-engines.com/en/ranking
-
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
Scott, the reason why I would like to learn DB is to try a different field. I need to build up my certs on my resume. I'm tired of doing contract work here in Ontario. I want to permanent gig.
So what DB certs do any of you gents suggest to go for? I'm curious as to what your thoughts are. -
@MrWright4hire said in Oracle Database and schemas...please help!:
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
What defines number one? It's certainly not the most used. It's nowhere close. How do they collect that data? They don't have access to my info or any other database user that I know. So how do they get that info?
And number one doesn't make something a good career. Are there Oracle DBAs out there? Yes. And there many new ones? No.
-
Number nine DBMS on that list isn't even a DBMS. Seems sketchy.
-
Also MySQL and MariaDB are the same product. Put them together and Oracle isn't on top even in that list.
-
But more importantly than position is change rate. Oracle shows as falling for years. A falling system has incumbent specialists in the field with seniority and experience that you will never get. How do you plan to unseat them when there are fewer and fewer jobs in the field year over year.
-
@scottalanmiller said in Oracle Database and schemas...please help!:
@MrWright4hire said in Oracle Database and schemas...please help!:
@stacksofplates and @scottalanmiller the ranking still shows Oracle as #1. Somebody has to be spending the money on the product if it's still listed as #1. Am I missing something here?
What defines number one? It's certainly not the most used. It's nowhere close. How do they collect that data? They don't have access to my info or any other database user that I know. So how do they get that info?
And number one doesn't make something a good career. Are there Oracle DBAs out there? Yes. And there many new ones? No.
http://db-engines.com/en/ranking_definition
Just general popularity.
