On 8/22/07, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: > > Send Sequoia mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://forge.continuent.org/mailman/listinfo/sequoia > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Sequoia digest..." > > > Today's Topics: > > 1. Problem to configure Sequoia with Oracle (Rogelio Chavez) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 22 Aug 2007 18:41:34 -0500 > From: "Rogelio Chavez" <[EMAIL PROTECTED]> > Subject: [Sequoia] Problem to configure Sequoia with Oracle > To: [email protected] > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi, > > I trying Sequoia with Oracle, but I have some problems, I have raidb1 like > example. > > First, when I started the controller I get the next log, > > C:\Program Files\sequoia-2.10.9-bin\demo>demo-test > ****************************************************** > ****************************************************** > ** ** > ** Please press a key when hsqldb servers are ready ** > ** ** > ****************************************************** > ****************************************************** > Starting Controller with Raidb1 Configuration (press a key when ready) > Presione una tecla para continuar . . . 22:05:30,540 INFO > controller.core.Contr > oller Sequoia controller (2.10.9) > 22:05:30,602 INFO controller.core.Controller Loading configuration file: > ..\con > fig\controller\controller-test.xml > 22:05:30,696 INFO controller.core.Controller JMX is enabled > 22:05:30,728 INFO controller.core.Controller Starting JMX server on host: > 10.10 > 0.2.159 > 22:05:31,103 INFO backup.backupers.OctopusBackuper OctopusBackuper backup > compr > ession is set to true > 22:05:31,103 INFO controller.backup.BackupManager Registering backuper > Octopus > to handle format Octopus v3.4.1 database neutral dump compressed > 22:05:31,134 INFO DatabaseBackend.myDataBase.localhost1 Adding connection > manag > er for virtual user "user" > 22:05:31,134 INFO DatabaseBackend.myDataBase.localhost2 Adding connection > manag > er for virtual user "user" > 22:05:32,713 INFO controller.RequestManager.myDataBase Request manager > will > par > se requests with the following granularity: TABLE > 22:05:32,713 INFO controller.core.Controller Adding VirtualDatabase > myDataBase > 22:05:32,728 INFO controller.core.Controller Waiting for connections on > 0.0.0.0 > :25322 > 22:05:32,744 INFO controller.core.Controller Controller started on > 2007.08.22 3 > 4 at 10:05:32 PM GMT > 22:05:32,744 INFO controller.core.Controller Controller > 10.100.2.159:25322read > y, listening to requests ... > > > I think everything is right. > > After using the console I active the backends, the screen of the console > is > the next > > C:\Program Files\sequoia-2.10.9-bin\bin>console > Launching the Sequoia controller console > Initializing Controller module... > Initializing VirtualDatabase Administration module... > Initializing SQL Console module... > Sequoia driver (Sequoia core v2.10.9) successfully loaded. > localhost:1090 > admin myDataBase > Virtual database Administrator Login > admin > Virtual database Administrator Password > > Ready to administrate virtual database myDataBase > myDataBase(admin) > expert on > myDataBase(admin) > enable localhost1 > Enabling backend localhost1 from its last known checkpoint > Cannot enable backend localhost1 from a known state. Resynchronize this > backend > by restoring a dump. > myDataBase(admin) > force enable localhost1 > Enabling backend localhost1 with no checkpoint > myDataBase(admin) > enable localhost1 > Enabling backend localhost1 from its last known checkpoint > Cannot enable backend localhost1 from a known state. Resynchronize this > backend > by restoring a dump. > myDataBase(admin) > force enable localhost1 > Enabling backend localhost1 with no checkpoint > Backend localhost1 is already enabled > myDataBase(admin) > force enable localhost2 > Enabling backend localhost2 with no checkpoint > myDataBase(admin) > > > > > The problem is because in the controller log, appears some warnings > > 23:25:35,963 INFO DatabaseBackend.myDataBase.localhost1 Detected backend > as: Or > acle > 23:25:35,979 WARN DatabaseBackend.myDataBase.localhost1 > Statement.setCursorName > not supported. > 23:25:35,979 WARN DatabaseBackend.myDataBase.localhost1 > Statement.getGeneratedK > eys not supported. > 23:25:40,023 INFO controller.RequestManager.myDataBase Setting new > virtual > data > base schema. > 23:25:40,085 INFO controller.RequestManager.myDataBase Database backend > localho > st1 is now enabled > 23:25:56,595 INFO DatabaseBackend.myDataBase.localhost2 Detected backend > as: Or > acle > 23:25:56,611 WARN DatabaseBackend.myDataBase.localhost2 > Statement.setCursorName > not supported. > 23:25:56,611 WARN DatabaseBackend.myDataBase.localhost2 > Statement.getGeneratedK > eys not supported. > 23:26:00,485 INFO controller.RequestManager.myDataBase Virtual database > schema > merged with new schema. > 23:26:00,532 INFO controller.RequestManager.myDataBase Database backend > localho > st2 is now enabled > > > After this, I try to access with Squirrel client and when I start my > connection y receive the next message on the log > > 23:31:52,492 WARN > virtualdatabase.VirtualDatabaseWorkerThread.myDataBaseError > while calling databaseMetaDataGetSuperTables > java.sql.SQLException: Funci¾n no soportada > at oracle.jdbc.driver.DatabaseError.throwSqlException( > DatabaseError.java > :125) > at oracle.jdbc.driver.DatabaseError.throwSqlException( > DatabaseError.java > :162) > at oracle.jdbc.driver.DatabaseError.throwSqlException( > DatabaseError.java > :227) > at > oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException( > DatabaseError.java:537) > at oracle.jdbc.OracleDatabaseMetaData.getSuperTables > (OracleDatabaseMetaD > ata.java:3896) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseDyna > micMetaData.doGetSuperTables(VirtualDatabaseDynamicMetaData.java:1533) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseDyna > micMetaData.getSuperTables(VirtualDatabaseDynamicMetaData.java:1498) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork > erThread.databaseMetaDataGetSuperTables(VirtualDatabaseWorkerThread.java > :1473) > at > org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWork > erThread.run(VirtualDatabaseWorkerThread.java:565) > > > After this I can view the tables, do queries in backend localhost1, but in > localhost2 I receive simmilar message when I try to view the tables with > Squirrel I receive the next message > > > 23:36:09,228 WARN controller.RequestManager.myDataBase Failed to execute > reques > t select * from bitacora_mensaje_iso because of (Request select * from > bitacora_ > mensaje_iso failed on backend localhost1 (ORA-00942: table or view does > not > exis > t > )) > 23:36:09,228 WARN controller.virtualdatabase.myDataBase Request '1' > failed > (Req > uest select * from bitacora_mensaje_iso failed on backend localhost1 > (ORA-00942: > table or view does not exist > )) > 23:36:09,228 WARN > virtualdatabase.VirtualDatabaseWorkerThread.myDataBaseError > during command execution (Request select * from bitacora_mensaje_iso > failed > on b > ackend localhost1 (ORA-00942: table or view does not exist > )) > > My files for configuration are: > demo-test.bat > @echo off > title Sequoia RAIDb-1 demo > echo ****************************************************** > echo ****************************************************** > echo ** ** > echo ** Please press a key when hsqldb servers are ready ** > echo ** ** > echo ****************************************************** > echo ****************************************************** > > SET SEQUOIA_HOME="C:\Program Files\sequoia-2.10.9-bin" > SET JAVA_HOME="C:\Archivos de programa\Java\jdk1.5.0_08" > SET CLASSPATH_XTRA="C:/Program Files/sequoia-2.10.9-bin > /drivers/ojdbc14.jar" > > :begin > cd "%SEQUOIA_HOME%\bin" > > echo Starting Controller with Raidb1 Configuration (press a key when > ready) > start /B controller.bat -f ..\config\controller\controller-test.xml > > pause > echo Initializing controller > start console.bat -p 1090 -f ..\demo\init_controller_test.script > :end > > controller-test.xml > <?xml version="1.0" encoding="ISO-8859-1" ?> > <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER > 2.10.9//EN" " > http://sequoia.continuent.org/dtds/sequoia-controller-2.10.9.dtd";> > <SEQUOIA-CONTROLLER> > <Controller port="25322"> > <Report/> > <JmxSettings> > <RmiJmxAdaptor/> > </JmxSettings> > <VirtualDatabase configFile="oracle-test.xml" > virtualDatabaseName="myDataBase" autoEnableBackends="false" > checkpointName="Initial_empty_recovery_log"/> > </Controller> > </SEQUOIA-CONTROLLER> > > oracle-test.xml > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.9//EN" " > http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd";> > > <SEQUOIA> > > <VirtualDatabase name="myDataBase"> > > <Monitoring> > <SQLMonitoring defaultMonitoring="off"> > <SQLMonitoringRule queryPattern="^select" caseSensitive="false" > applyToSkeleton ="false" monitoring="on"/> > </SQLMonitoring> > </Monitoring> > > <Backup> > <Backuper backuperName="Octopus" > className=" > org.continuent.sequoia.controller.backup.backupers.OctopusBackuper" > options="zip=true"/> > </Backup> > > <AuthenticationManager> > <Admin> > <User username="admin" password=""/> > </Admin> > <VirtualUsers> > <VirtualLogin vLogin="user" vPassword="user"/> > </VirtualUsers> > </AuthenticationManager> > > <DatabaseBackend name="localhost1" driver="oracle.jdbc.OracleDriver" > url="jdbc:oracle:thin:@10.100.144.4:1521:dwbuild" > connectionTestStatement="select * from dual"> > <DatabaseSchema dynamicPrecision="table" > gatherSystemTables="false"/> > <ConnectionManager vLogin="user" rLogin="liqval_user3" > rPassword="liqval_user3"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > > <DatabaseBackend name="localhost2" driver="oracle.jdbc.OracleDriver" > url="jdbc:oracle:thin:@10.100.144.4:1521:dwbuild" > connectionTestStatement="select * from dual"> > <DatabaseSchema dynamicPrecision="table" > gatherSystemTables="false"/> > <ConnectionManager vLogin="user" rLogin="liqval_user" > rPassword="liqval_user"> > <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" > maxPoolSize="50" idleTimeout="30" waitTimeout="10"/> > </ConnectionManager> > </DatabaseBackend> > > <RequestManager> > <RequestScheduler> > <RAIDb-1Scheduler level="passThrough"/> > </RequestScheduler> > > <RequestCache> > <MetadataCache/> > <ParsingCache/> > <!-- <ResultCache granularity="table"/> --> > </RequestCache> > > <LoadBalancer> > <RAIDb-1> > <WaitForCompletion policy="first"/> > <RAIDb-1-LeastPendingRequestsFirst/> > </RAIDb-1> > </LoadBalancer> > > <RecoveryLog driver="oracle.jdbc.OracleDriver" > url="jdbc:oracle:thin:@10.100.144.6:1521:PINDEVAL" > login="ADMINWLES" > password="ADMINWLES"> > <RecoveryLogTable tableName="RECOVERY" logIdColumnType="NUMBER NOT > NULL" > vloginColumnType="VARCHAR(255) NOT NULL" > sqlColumnType="VARCHAR(255) NOT NULL"/> > <CheckpointTable tableName="CHECKPOINT" > checkpointNameColumnType="VARCHAR(255) NOT NULL"/> > <BackendTable tableName="BACKEND" > databaseNameColumnType="VARCHAR(255) NOT NULL" > backendNameColumnType="VARCHAR(255) NOT NULL" > checkpointNameColumnType="VARCHAR(255)"/> > <DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(255) NOT > NULL" > dumpDateColumnType="TIMESTAMP" > dumpPathColumnType="VARCHAR(255) NOT NULL" > dumpFormatColumnType="VARCHAR(255) NOT NULL" > checkpointNameColumnType="VARCHAR(255) NOT NULL" > backendNameColumnType="VARCHAR(255) NOT NULL" > tablesColumnType="VARCHAR(255) NOT NULL"/> > </RecoveryLog> > </RequestManager> > > </VirtualDatabase> > > </SEQUOIA> > > > Someone have some idea how to make this > > Thanks in advance > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://forge.continuent.org/pipermail/sequoia/attachments/20070822/8c93a96d/attachment.html > > ------------------------------ > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia > > End of Sequoia Digest, Vol 24, Issue 20 > *************************************** >
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
