Unable to access successfully after import (IIS)

[kasparov]

I have a database running Oracle 10.2.0.1.0. Our users connect to the database using IIS (we're on version 6).

I am trying to port the data into our TEST system from LIVE. I can do this 2 ways (both work):
[ul]
[li] using export/import; or [/li]
[li] create a text version of the control file on LIVE, edit this accordingly, copy data, etc files to TEST & recreate control files on TEST.[/li]
[/ul]

If I do either of these the new TEST database is OK through Sqlplus. I can access, update & retrieve data with no problems. But I cannot then connect using the browser (I get the standard IE "The page cannot be displayed" error message.

I am not changing IIS or any of it's associated files at all - the only files changing are the Oracle database files.

Our IIS set up uses a Default Web Site & accesses 'Login.aspx' to present the login screen.

I know this seems a fairly open ended question but can anyone shed any light on why our connection may fail after I've refreshed/recreated the TEST database?

I (think) I've tried all the obvious things, e.g. stop/start IIS, reboot the server, check file permissions, I've looked for references to the live instance & server in the new TEST database (I found a few, deleted them & no difference - though still fine in Sqlplus).

Unfortunately our TEST system is unsupported so we're on the verge of paying our suppliers to come & help us but I'd much rather we fixed this ourselves.

Thanks for any advice, Chris

 

[Welshbird]

Sorry - just to clarify:

Have you ever been able to connect to the test database via the ASP login? It does sound slightly like this is where the issue is rather than the Oracle end, as you can get to the Oracle stuff via standard tools.

Just a though though..

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[kasparov]

Hi Fee - Yes, I have an old-ish copy of the test database which works fine (& I can restore that anytime I want by closing the database & copying the old files back to the correct directory).

More info - I've checked permissions on my new & old files (they are the same).

The original test database was built using the tools our system suppliers gave us, I built the new one by:
[ul]
[li]starting with the working test database then either [/li]
[li]importing from a live export or [/li]
[li]rebulding by copying database files & recreating control files. [/li]
[/ul]

So I guess it must be something in the Oracle database - but I've tried everything I can think of!

Thanks, Chris

 

[Beilstwh]

An ASP page can connect via two ways. One method (ADO) specifies the ip of the server and it's sid, user name, and password. The second method specifies an ODBC connection. When you clone a database by copying it's data files and control file, it will maintain it's original sid, user names, and password. If you are connecting via ODBC, is they correct. If you are connecting via ADO, is the IP and password/sid correct?

Bill
Oracle DBA/Developer
New York State, USA