Search results for query: *

From what FALCONSEYE described, if we have another record like following in the table temp_p, 7 person7 2 it should be included in the result. But none of the query from Mufasa or FALCONSEYE returns this record. I think the correct answer should like following: select * from tmp_p...

Thanks a lot denny! I turned on the anonymous access and specified a windows account being used by the anonymous user, grant this account the access to all the databases that can be used as datasource. It works! You reminded me license issue, this sounds a Microsoft trick. If we use the scale...

We configure the clustering as following: IIS group IP address: vitual IP fot IIS Service to failover IIS network name resource IIS script resource since SSRS is not cluster aware we install 2 standalone reporting service on 2 nodes, connect to the same database, the user view report...

Long time no see :-) thanks a lot denny!

Hi, We want install 2 reporting service on a 2 node sql clustering. I read some articles and awared of the scale out need use Enterprise Edition of SQL Server. the problem is we already have the standard edition of sql clustering setup, can we install the SSRS using enterprise edition? Is it...

thanks a lot! It's old article but still good.

I'm new to the SQL Clustering. Can someone give me some good reading material for me to start to know it?

also I found there are 8 CPUs on the server and the TEMPDB only have one file. Is that asking for competition on the data file? Do I need to add more data files for the TEMPDB? If the TEMPDB should be sized 8G and we have 8 CPUs, do I need to have 8 datafiles for TEMPDB and each of them at 1G?

We have a lot of message like following: SQL Server has encountered 294 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000814. The offset of the latest long I/O is...

I found the following article: http://www.databasejournal.com/features/oracle/article.php/3600931 talking about migrate database using RMAN cross platform. I need do more test like you mentioned and script and time every step. Thanks a lot!

Thanks a lot! These issues was because of bad design at the beginning. We already allocate another server to migrate the application to. By that time, the connecting problem will solved as well. This is just phase I, the phase II is to move the database from the windows platform to unix. The...

Very good suggestion! Thanks Dennis

Someone deleted the databases on purpose, the SQL Server starting fine and most of the critical production databases are gone. The people who did this must have dba password or can physically logon the box. Looks like the error logs are also modified. Is there any way we can trace this event in...

Your answer really makes sense to me. But for some reason the application for the 9i database was installed on the database server, this makes things complicated. After I updated the MDAC which is related to microsoft ole db I guess, the clients can't connect to the database anymore if the 10G...

Hi thargtheslayer , You mean I deinstall both the 9i client and 10G client on the server? We can't touch the 9i environment because we have a 9i production database here.

Another clue, it actually say ' th microsoft ole db provider error, can resolve serverice name ...". May be I need to install mdac 2.8?

I have a windows box have oracle 9i installed. I install another oracle 10G home and create a 10G database. I didn't touch the existing 9i database, but the application running on the same box that connecting to the 9i database stops working. Give me error like 'can't resolve service name..."...

Thank you everybody! I finally restored the database using RMAN, it's amazing tool! The 100G database restore just matter of a couple of hours on a windows box! I'm sure I want use it forever! And I found why the upgrade failed, the DBUA reied to create a account 'DMSYS' which uses TEMP as the...

Thanks a lot Mufasa and Jasper! The real life situation is just always complicated. I'm doing the upgrade on a less critical 9i database, this means we have another 9i production database which is more critical in the same box. I can't unintall oracle 9i, even worse I can't even reboot the box...

Hi Mufasa, I didn't do export so I have no way to upgrade it to 10G now. The current issue is to restore it back, the problem is the windows OS, I can't just copy back evrything. I need to take care of windows service, registry stuff, I'm fear maybe I miss something when restore the DB.