Home / user-7381

Vimvq1987's questions

Martin Hope
Vimvq1987
Asked: 2011-02-08 21:38:48 +0800 CST
  • 3

I have an instance of Oracle 10g R2 installed on Windows Server 2003. This instance was running a database which does not have any backup. Now the OS went down, could not be repaired, and all I got is the running files of the old instance.

How can I restore the database from these files to new instance?

A step-by-step guide will be much appreciated because I'm new with Oracle.

windows-server-2003 database oracle
Martin Hope
Vimvq1987
Asked: 2011-01-07 19:42:32 +0800 CST
  • 0

Oracle is marketing Exadata to our company, and they're focusing on Smartscan, which is, advertised 10x more effective than traditional solution. I don't really understand (and somewhat don't really believe) this solution, because they assume that data is put on separated storage, and no indexes are used, so "1TB data was scanned and only 2MB is returned".

So, I want to ask you: is Smartscan really effective. Is it true solution that greatly improves performance or just a buzzword?

database oracle
Martin Hope
Vimvq1987
Asked: 2010-04-03 09:29:54 +0800 CST
  • 3

I wanted to try HAProxy/Linux Virtual Server like front-end load-balancers, but as far I know, they're Linux-based software. I don't have any experiences with Linux yet. so there're quite many questions to ask:

  • What is the best Linux distro(s) for load-balancing?
  • I plan to use VirtualPC to run some virtual machines. How much RAM is the best for each machine run that distro? I want to simulate a load-balancer which can handle about 100 hits/second, is it possible?

Thank you very much!

linux load-balancing virtual-machines
Martin Hope
Vimvq1987
Asked: 2010-03-31 19:32:59 +0800 CST
  • 8

Based on this question: Widely-used load balancing solutions?, LVS may be the right solution for my problem.

But when I went to its homepage http://www.linuxvirtualserver.org/, I found that LVS has been updated since Nov, 2008. The world's moving fast, and I don't know if LVS was obsolete or not.

Is LVS standing still, or there're some better solutions to replace it?

Thank you so much.

linux load-balancing lvs
Martin Hope
Vimvq1987
Asked: 2010-03-23 04:23:36 +0800 CST
  • 3

I asked this question, and a bit disappointed that NLB was not a widely-used solution.

I want to ask about widely-used solutions in the world now. Can you give me a list and a brief introduction for each? Cause of limitation of my thesis resource, I need to focus on software-only, Windows-based solution (both database level and system level are welcome).

windows windows-server-2003 load-balancing
Martin Hope
Vimvq1987
Asked: 2010-03-20 08:41:07 +0800 CST
  • 3

I'm about to study about NLB on Windows Server 2003. It archives both of my interests now: scalability and high-availability. But I don't know about its power in production environment.

  • Is NLB a efficient solution?

    How does it implement in real-world? Is it popular?

    What are its limit?

Thank you so much for answering my questions. :)

windows networking load-balancing web-server high-availability
Martin Hope
Vimvq1987
Asked: 2010-03-06 01:12:26 +0800 CST
  • 4

I want to study about high-availability server, and then build a demo system (which contains HA web server - IIS, and a HA database - SQL Server ). I have some experiences about high-availability SQL-Server, but I don't know that at system level, are HA solutions different from database level?

How to I start to study this? Any leads? Any books? Any information?

Thank you very much!

sql-server iis high-availability
Martin Hope
Vimvq1987
Asked: 2010-01-28 07:08:27 +0800 CST
  • 0

I want to write to program to connect to a database mirroring, and now I'm confused with the connection string. My database mirroring was installed on three SQL Server instances on three virtual PCs. I want my program to run on one of them and connect to the database. The database will be switched roles (principal becomes mirror, and vice-versa).

I know 2 connection strings, but I really doubt that there are some better solutions. Some solution to configure the database, so I don't have to switch the connection strings. In other words, the connection to database mirroring is transparent to the client. Clients don't know about the database mirroring, they just want to know the connection string. How can I do that?

Thank you very much to your help.

virtualization sql-server connection database configuration
Martin Hope
Vimvq1987
Asked: 2010-01-22 02:59:38 +0800 CST
  • 0

Sorry if it's a noob question.

I now have 3 virtual PCs, which all installed windows server 2003. In order to create an database mirroring demo, I have to know the full domain name of them. These virtual PCs use Local only network connection and they see each other.

I tried to create a domain using one of them as domain controller, but then the SQL Server instance on it cannot see these others. I got stuck with that.

How can I do this? A detail tutorial would be great helpful.

Thank you very much!

sql-server windows-server-2003 active-directory database
Martin Hope
Vimvq1987
Asked: 2010-01-17 02:41:08 +0800 CST
  • 0

I'm going to demo a high-availability SQL Server database to my mentor. My current PC configurations are:

Pentium E6300

2G of RAM

Windows 7 Ultimate

I planned to create 3 virtual machines by Microsoft Virtual PC, all of them install Windows Server 2003 R2 Standard and SQL Server 2005 Enterprise SP3 to be the Server Role, Mirror Role and Witness Role. I thought that it'll work, but I doubt there are better solutions for me to create a demo system:

  • Using only 3 instances of SQL Server (without Virtual machine and, of course, without Windows Server) run directly on my machine.
  • Another ways that I've not known yet.

My question is: - Which choice is the simplest? - Which choice is the best demonstration for the abilities of database mirroring?

Thank you very much.

virtualization sql-server windows-server-2003 high-availability
Martin Hope
Vimvq1987
Asked: 2010-01-09 20:06:40 +0800 CST
  • 1

I used Virtual PC to create a virtual machine with configuration:

CPU: Intel Pentium E6300 2.8Ghz overclocked to 3.66Ghz (which supports VT technology)

RAM: 600MB

I thought it was enough for me to install SQL Server 2005 enterprise on it. But installer still tells me that the virtual machine does not meet the hardware requirements. Did I forgot something about this?

virtualization sql-server hardware
Martin Hope
Vimvq1987
Asked: 2010-01-05 06:55:48 +0800 CST
  • 5

I'm studying about high-availability on SQL Server for my thesis. I've learned there're several solutions to archive this:

  • Failover clustering
  • Log shipping
  • Replication

As I know, these solutions were supported in previous version of SQL Server 2008. SQLS 2008 provides database mirroring, which is supposed as a better solution. I really doubt about this. Can you please tell me the cons and pros of these solutions, what strategies they should be used and what strategies should not. Detail info and explain would help me a lot

Thank you very much.

sql-server
Martin Hope
Vimvq1987
Asked: 2009-07-07 02:05:50 +0800 CST
  • 1

I used Visual Studio 2005 to open a remote website. This remote website runs on Windows Server 2003 enterprise, (IIS 6.0). I installed frontpage server extensions for IIS, but VS 2005 still says that it "unable to open the web "". The web server does not appear to have the Frontpage Server extensions intalled"

Can you help me?

iis visual-studio