Hi all,
I have searched previous posts and gotten some help on this problem but as i am new to Oracle some of the help is a little advanced for me.
The problem - Oracle database is installed on a HP machine with win XP. Oracle App server is installed on another machine on the network with Win XP Pro. I could connect from the app server to the database with no problems up until a few days ago. The HP machine with the database was changed over from a wireless network connection to a wired one. The IP address of this machine is assigned dynamicaly so it may have changed. Now the App server machine cannt connect to the database thro odbc, or sql*net. I can connect to the database thro odbc on the same machine.
Attempts to solve - I have tried deleting the listener on the database machine and recreating it. I have reconfigured the nameing service on the app server. I have reinstalled the odbc driver. I can ping the database machine but still cant connect to the database. I get connection timed out but if anything our network is faster now than it was before.
I have read suggestions to 'use the tsping utility' but i dont know where this tsping utility is. Also it was suggested that i set the connection variable in the listener.ora file to a higher number or 0 but i can't see that variable in the listener file. The files are below. I know this is something simple but its driving me nuts. Any help??
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HPDESKTOP)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = HPDESKTOP)(PORT = 2484))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(SERVER = HPDESKTOP)(PIPE = ORAPIPE))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora1.appligenics.com)
(ORACLE_HOME = c:/oracle)
(SID_NAME = ORA1)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)
# tnsnames.ora Network Configuration File: C:\OraHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HPDESKTOP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora1.appligenics.com)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
# sqlnet.ora Network Configuration File: C:\OraHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT)
I have searched previous posts and gotten some help on this problem but as i am new to Oracle some of the help is a little advanced for me.
The problem - Oracle database is installed on a HP machine with win XP. Oracle App server is installed on another machine on the network with Win XP Pro. I could connect from the app server to the database with no problems up until a few days ago. The HP machine with the database was changed over from a wireless network connection to a wired one. The IP address of this machine is assigned dynamicaly so it may have changed. Now the App server machine cannt connect to the database thro odbc, or sql*net. I can connect to the database thro odbc on the same machine.
Attempts to solve - I have tried deleting the listener on the database machine and recreating it. I have reconfigured the nameing service on the app server. I have reinstalled the odbc driver. I can ping the database machine but still cant connect to the database. I get connection timed out but if anything our network is faster now than it was before.
I have read suggestions to 'use the tsping utility' but i dont know where this tsping utility is. Also it was suggested that i set the connection variable in the listener.ora file to a higher number or 0 but i can't see that variable in the listener file. The files are below. I know this is something simple but its driving me nuts. Any help??
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HPDESKTOP)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = HPDESKTOP)(PORT = 2484))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(SERVER = HPDESKTOP)(PIPE = ORAPIPE))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora1.appligenics.com)
(ORACLE_HOME = c:/oracle)
(SID_NAME = ORA1)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
)
)
# tnsnames.ora Network Configuration File: C:\OraHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HPDESKTOP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora1.appligenics.com)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
# sqlnet.ora Network Configuration File: C:\OraHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT)