Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Technical Questions or Issues

Thread Tools Search this Thread Display Modes
Old 04-12-2008, 08:38 AM
Arjen Visser Arjen Visser is offline
Dbvisit Team
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 383
Default Using IP address instead of FQN

In the process of setting up a new Standby DB I had to change the FQN in the DDC file to an IP address. When I did that and ran the dbvist process it gave the following error. It used the IP address of the standby DB to send the files but when it contacted the standby it gave an error. Curious why it returned an error. It looks like it returned the hostname of the standby server and compared that to the DESTINATION parameter and since one was a FQN and the other was an IP it didnít like that. Why should that matter?

[oracle@db1 dbvisit]$ ./dbvisit dbvprod1
================================================== ===========
Dbvisit Standby Database Technology ( (pid 24668)
dbvisit started on db1.1918.ash.prodata.com: Fri Apr 11 11:01:14 2008
================================================== ===========
First time Dbvisit runs, Dbvisit installation will be copied to
Transferring dbv_functions to host
Transferring dbvisit to host
Transferring dbvisit_setup to host
Transferring dbv_oraStartStop to host
Transferring dbv_dbvprod1.env to host
Transferring dbv_ORACLE_SID.env to host
Contacting Standby Database dbvprod1 on
200804111101 - Problem with obtaining the last sequence from standby database on
================================================== ===========
Dbvisit Standby Database Technology (
================================================== ===========
Dbvisit Error: 705.

Unknown host server db1.1918.dr.prodata.com. Server name db1.1918.dr.prodata.com not found in Dbvisit Database configuration (DDC)
file dbv_dbvprod1.env. Server names in Dbvisit Database configuration (DDC) file are db1.1918.ash.prodata.com and
HOSTNAME_CMD is set, so hostname is determined by HOSTNAME_CMD (/bin/hostname). Please ensure this command returns the correct hostname.
Note that server names are case sensitive.

================================================== ===========
Dbvisit Standby Database Technology
================================================== ===========
Please check Standby Database is up and runnning on, else please contact Dbvisit support.
Dbvisit terminated.
Return code = 193
Reply With Quote
Old 04-12-2008, 08:40 AM
Arjen Visser Arjen Visser is offline
Dbvisit Team
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 383
Default Hostname_cm

In order for Dbvisit to determine which function to perform (primary database functions or standby database functions) it compares the DESTINATION and SOURCE parameter to the hostname command of the server.
If you use an IP address for the DESTINATION, then this will not match what is returned by the hostname command on the server and Dbvisit will error.

There is a way round this by setting the HOSTNAME_CMD variable in the DDC file.
If this is set, then Dbvisit does not use the hostname command, but the result of HOSTNAME_CMD.

For example:

If hostname.sh contains:

Then Dbvisit will accept this IP address as the hostname.

This is useful when Dbvisit is used in a cluster and the virtual cluster name should be used instead of the physical hostname.
Reply With Quote

705, hostname, hostname_cmd

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT +12. The time now is 09:14 PM.