Fusion and Oracle 12c issue

[arkadybocharov]

Just faced the issue when I try to install Oracle Database 12c Release 1 (12.1.0.2.0) and face ORA-12560 on database creation

After looking through Internet I've found out that this issue might be not the problem of specific Oracle Installation, but VMWare fusion and VMWare workstation incompatibility. Is there anyone who faced this issue and managed to solve it?

[Mikero]

Highly doubtful this is related to Fusion or Workstation, but I'm always happy to be proven wrong.

From some googling of the error:

"BY FAR the most common cause of ora-12560 on a windows machine is due to not having ORACLE_SID set properly.

If you try to connect like this:

c:> sqlplus scott/tiger

It will use the current value of ORACLE_SID to establish a bequeath (not network) connection to the database specified by ORACLE_SID.  If you don't have a local database running by that name, you get the error.

If you try to connect like this:

c:> sqlplus scott/tiger@orcl

It will take the value following the "@", look that up in tnsnames.ora, and attempt a network connection using the information found there.

ORA-12560: TNS:protocol adapter error | Oracle Community‌

Where did you see anything regarding VMware incompatibility?

[wila]

There appears to be a CPU issue with Oracle and newer type Macbook's see also:

https://medium.com/red-pill-analytics/does-oracle-database-12c-just-not-work-on-windows-2f73e1485904...

Looking for a way to mask off that part on the CPU so that it works.

--

Wil

[wila]

My friend who bumped into this issue managed to get Oracle 12c working on Fusion with the following CPU flags:

I had to guess a bit, but I got it!
/quote
cpuid.4.4.eax = "00000000000000000000000000000000"
cpuid.4.4.ebx = "00000000000000000000000000000000"
cpuid.4.4.ecx = "00000000000000000000000000000000"
cpuid.4.4.edx = "00000000000000000000000000000000"

--

Wil

[nobrakes]

Virtualized environments are rarely, if ever, to blame for a failing Oracle installation (or most anything else). They (VM;s) all do the job quite well.

Installations on Windows can occasionally pose some unique problems (like trying to install on a domain controller... um, don't ask). 

This should work for you in any case....

1) Run the Oracle installation as a "software only install", i.e., don't create a database.

2) Download and apply the most current (Oracle) Windows bundle patch.

3) After patching with the latest bundle run DBCA to create your database.  

That should get you going.

Regards...

[DaveP]

Thanks for this information I also had a problem and this fixes it. Same Oracle 12c VM running on HP Workstation and Windows or Linux and ESXi fine. My iMac fine but latest Macbook Pro had various TNS errors. It is due to a Perl segmentation fault that can happen on real machines as well. Luckily on VMware we can mask out the CPUID bits causing the issue.

Oracle Blog has the details VBox 5.0.10/12 issues with PERL and Seg Faults - UPDATE (Upgrade your Database - NOW!).