Perhaps more samples or documentation/wiki update regarding creating a new oracle database using Roundhouse

[chaitanyagurrapu]

Hi,
I've asked this question on Stackoverflow here (http://stackoverflow.com/questions/15469634/can-i-create-a-brand-new-oracle-db-schema-with-roundhouse).

Not sure about the etiquette of cross posting back on Github. I am sorry if it is rude or frowned upon.

But I seem to be getting an Argument Exception with "The OracleParameter is already contained by another OracleParameterCollection" error.

I just can't seem to get the settings correct to create a new Oracle DB. The connection strings and the users to specify in those in connection string seem particularly tricky. It either says invalid logon/user. If the user was created at a database level. Or it throws the Argument Exception when I use the "System" user with the appropriate password.

Perhaps samples folder can be updated with an example project to create a new dummy oracle db and create one table inside it? Alternately can the Wiki be expanded to provide more info regarding how create a new Oracle DB? Mainly around what users/connection strings to do the initial schema/db create versus what users/connection strings to use while running the rest of the scripts.

[ferventcoder]

Try CSA (aka connection string admin) for a user/schema that would be considered global to the database. I also posted information on your question. I haven't worked with Oracle in so long I am not in a position to give you a good answer at the moment.

[chaitanyagurrapu]

Thanks for the quick reply, that was very impressive. I mainly wanted to check that there wasn't something obvious I was missing. Looks like I will have to dig deeper and think of more out of the box solutions. It is not as straight forward as it was with SQL Server.

I have tried the CSA as well, but via the config file, not the command line. The updated config since I posted the question is given below

    .
    .
    .
    <Environment>LOCAL</Environment>
    <DBConnectionString>Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dev-mac-303.qtest.local)(PORT = 1521)))(CONNECT_DATA = (SID = DEVEL)));User Id=mytest;Password=mytestdevel;Persist Security Info=false;</DBConnectionString>
    <DBConnectionStringAdmin>Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dev-mac-303.qtest.local)(PORT = 1521)))(CONNECT_DATA = (SID = DEVEL)));User Id=System;Password=password;Persist Security Info=false;</DBConnectionStringAdmin>
  </PropertyGroup>
  <Target Name="ApplyDatabaseChanges">
    <Roundhouse
        ServerName="$(DBServer)"
        DatabaseName="$(DBName)"
        ConnectionString="$(DBConnectionString)"
        ConnectionStringAdmin="$(DBConnectionStringAdmin)"
        CommandTimeout="60"
    .
    .
    .

I presume the config file element is the same thing as the CSA option you are talking about? This is the one that gives me the ArgumentException with "OracleParameter is already contained ..." It seems to come the closest to working. i.e it at least seems to get past the login issues and presumably fails at a point further along. It almost seems like it's related to this issue here #58 , but according to the thread that seems to have been fixed and that is what I have on my machine.

I will dig through and see if I can track down the cause and figure out any workarounds.

[ferventcoder]

Cool, let me know if you find any.