| Re: Scripts for cold backup's not working [message #51769] |
Wed, 12 June 2002 17:31 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
ensure that the Oracle Networking Products have been installed, including the Oracle TCP/IP Protocol adapter.
set LISTENER.ORA's CONNECT_TIMEOUT_LISTENER parameter to 0.
Stop the listener and restart it.
From the database server make sure that SQLNET.ORA file contains
AUTOMATIC_IPC=OFF parameter.
from server check using
sqlplus username/password@service_name where service_name is an entry in the
TNSNAMES.ORA file pointing back to the server.
Does the ora-12203 error occur??If so, then the server files is the issue and is not set up right.
- Verify oracle_home is set correctly
- Verify TNS_ADMIN is set correctly, if using it.
- Verify listener.ora, tnsnames.ora and sqlnet.ora
file is correct and is in the correct location.
- BEQ protocol is installed in the background
automatically when sqlnet is installed, but make
sure its visible in the nt.rgs text file in the
orant/orainst directory.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
