Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maswien

    sql help

    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...
  2. maswien

    setup scale out reporting service

    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...
  3. maswien

    setup scale out reporting service

    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...
  4. maswien

    setup scale out reporting service

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

    setup scale out reporting service

    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...
  6. maswien

    requirement for sql clustering

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

    requirement for sql clustering

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

    message in error log

    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?
  9. maswien

    message in error log

    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...
  10. maswien

    strange issue

    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!
  11. maswien

    strange issue

    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...
  12. maswien

    question regarding database auditing

    Very good suggestion! Thanks Dennis
  13. maswien

    question regarding database auditing

    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...
  14. maswien

    strange issue

    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...
  15. maswien

    strange issue

    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.
  16. maswien

    strange issue

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

    strange issue

    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..."...
  18. maswien

    need help on upgrade

    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...
  19. maswien

    need help on upgrade

    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...
  20. maswien

    need help on upgrade

    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.

Part and Inventory Search

Back
Top