Hi,
Been trying to create the schemas using rcu as a standalone (DB running on my machine).
The version is 11g.
I'm using MySQL for DB (Version: 5.5.42-1) and have followed the steps as in the documentation. When I run rcu from command line, I get an error :
Processing command line ....
Invalid database type. Valid database types are: ORACLE , {1} and {2}
RCU-6090:Skipping Main operation: Failed in Connection step validation
Same is information from the logs.
The command I've run is :
./rcu -silent -createRepository -databaseType MYSQL -connectString 127.0.0.1:3306:ORACLE -dbUser ORACLE -component MDS -tablespace MDS -tempTablespace IAS_TEMP
I hope that I've provided the parameters correctly.
The db name and username is the same and in caps viz ORACLE. I did this as per notes found in the documentation.
The reason I'm doing this by command line is because, the GUI gave me an SDU Mismatch and no further information, when I provided the connection details.
My system meets all the requirements (or so I think) that the certification xls seems to require.
OS: debian linux (Jessie) - 64bit.
However, I have installed the ia32-sun-java6-bin package (from 6.26-squeeze1) and modified the rcu file in <RCU_HOME>/bin
This was done because out of the box the RCU wizard did not come up and a forum Q advised people to point to the native jre in the system.
This got the wizard running but the SDU mismatch had me wondering about the a 32/64 bit issue and I installed ia32-sun-java6-bin. But the SDU still showed up . Finally got a ('sensible?!') error from the command line.
I've also set the following configuration parameters for MySql:
mysql>SET GLOBAL INNODB_FILE_PER_TABLE="ON";
mysql>SET GLOBAL INNODB_FILE_FORMAT="Barracuda";
mysql>SET GLOBAL INNODB_LARGE_PREFIX="ON";
mysql>SET GLOBAL LOG_BIN_TRUST_FUNCTION_CREATORS="ON";
I've not fully understood what they mean, but discussion forms seem to indicate that this is required. So I did it. I have the (same) error before and after adding this. So ...
Now, I've run out of ideas to resolve this so any pointers or solutions are welcome.
My main question is:
Why do I get Invalid Database type? Have I missed installing something?
I downloaded the disks from Oracle Business Intelligence Applications (11.1.1.7.1) Downloads all the 64-bit linux disks and unzipped them and followed instructions in the documentation and the documentation states that MySQL is supported.
Thanks in advance for your time and efforts.
AK
P.S. Hoping that this posted in the correct forum. If no please advise. Thx!
.