Hi expert,

I have installed Oracle 10.2.0 on open SUSE 11.1 Linux with no errors recorded from the installation. I have started the database listener however, I cannot startup the database. I have used two different methods of startup, and both of them gave me these errors:

ORA-10997: another startup/shutdown operation of this instance in progress

ORA-09967: unable to create or open lock file

Linux Error 2: No such file or directory

In both cases, the ORACLE_HOME and ORACLE_SID variables were set. I have tried ”startup force” command in sqlplus, but I still cannot start up the database. Can someone offer a solution for this problem?

Thanks to all.

Good day,

Let me put this issue in this way: I have 4 databases on my Informix server 11.5 say A, B, C, D. I can connect to B, C and D which are the default Informix databases and A is created by the DBA.

The information about A:

1- This database is created from an earlier existing database on an older version

2- Not sure what was the platform on which the Informix was running, from which this database has been imported

3- The newer version of Informix runs on Windows Server 2003

Now when I try to connect to the database, it gives me 23197: Database locale information mismatch.

Hello,

Hi,

I would like to configure an enterprise replication between two databases (for only specific tables) in one single database server. Can this be accomplished by creating an alias name for the dbserver and using the actual dbservername and the dbserveralias to start replication?

I.e., DBSERVER=ids_em, DBSERVERALIAS=ids_em_alias, 1st db=test, 2nd db=test1, specific tables to be replicated from test to test1.

I don’t want to use triggers, as triggers are immediate and any error on “test1” would prevent the transaction from getting committed even in the db “test”. So I preferred to use ER in background. Can anybody help me out?

Regards.

Hi,

I am using the Informix database with dbaccess data_base_name. Could you please let me know how to execute a SQL query every month end without modification of the query? For example every end of month I have a dozen of SQL queries to be executed and I have to send the results to my colleagues but I have to edit each of them to modify the period from Day 1 to Day 30 if it’s November or from Day 1 to Day 31 if it’s December, etc.

How should I write these fields in my SQL script?

Thanks.

Good day,

I am working on converting windows applications, so it can be used with SQL server and Informix database. In a SQL server, the return data type of the SUM () function is the same as the data type of the column begin summed. So, if I sum integer field I get integer data type. It appears in Informix, that no matter what I SUM (), I get a float data type.

I have two questions:

1-Is there a setting that could change this?

2-What other aggregate functions does this apply to?

Thank you in advance for your help.

Regards.

Hello,

I am confused. DISTINCT or GROUP BY which one has a better performance in Informix database? I am new to the Informix database. By the way, in my Select query there is no aggregate function. It’s a direct Select query with WHERE clause and I used DISTINCT, but one of my seniors told me that GROUP BY has a better performance than DISTINCT. Is it true? Please let me know the details or post any article url explaining this issue.

Thanks.

Hi all,

I am working with two databases in Informix 10. Each one is on a different machine and I am trying to copy some data from one table to an identical table in the other database. Both databases are in UTF-8.

Hi experts,

I would like someone to help me with migration that I must execute soon. I will migrate an older Informix database to a newer Oracle 11g database. This is my first big migration experience and I have some questions.

First, I would like to know if Oracle Migration workbench already does what Oracle says and migrates easily or should I expect problems with its usage? My second question is, if I must do the migration manually, which steps do you recommend? I really need any help, suggestions and advice on this issue.

Thanks.

Hi!

I need your help. I am unable to install SQL SERVER 2005 on my PC. I have WINDOWS 7 in my computer. Can you refer me any software which can be compatible with my windows and also I may run SQL 2005 on my PC EFFICIENTLY? Because right now I have SQL server but it runs with many errors. And even sometimes it creates problem while connecting the PC with database.