New Oracle Server, while I was on vacation

[Traver]

Our company has changed our Oracle server, that host my citrix datastore.
The database admin states that everything was moved to the new Server, but my citrix servers, can´t acess the Datastore.
I get an

"The datastore is not available. Some features may not be available. error code 1612"

I assume I should do a DSMAINT CONFIG. And I have tried, but
I get a message, in the console
"Failed to connect to the data store"

The new server is called gis01, the old was gis03.
The datanameserver, knows the new server as gis01 AND gis03
because then we don´t have to change a lot of service files.
The old password dosn´t work anymore ( and the DB admin is on vacation), but I know another password that works fine.

....
Lots of options, what is the right solution

 

[JeffHicks]

So the DB admin changes servers then goes on vacation. Are you sure we don't work for the same company? I have nothing to add technically. I have always stuck with SQL server and know next to nothing about Oracle. Can you connect to the database via a dsn? When I have moved the datastore in a SQL world, I generally edit the mf20.dsn (or rather edit a copy of mf20.dsn) and test the connection. If this works, I will use dsmaint config to point it to the new dsn. You might could try this slightly more manual approach. Good luck.

 

[Traver]

It looks like there are missing some tables on the Oracle server.
I am looking for information about what tables should be made on the Oracle server. Then I can create the new tables, or might find them on the old server.

The new serer got the same name as the old. And I have changed the mf20.dsn a couple of times using name and ip, without succes.

Does anybody know the structure and the contenxt of the tables that MFXP user makes on the oracle server. On page 73 inth e admin guide 1.0 it says something about the MFXP that should make these tables.

 

[Traver]

Problem is solved.


I managed to make a new DNS file.
First I used a Microsoft for oracle client, that was an error. Then I used Oracle ODBC driver. when that was i place, the dsmaint config command worked fine.
Got hold of the new password. That helped too.