remote host

Post Reply
User avatar
fabiana
Nouveau
Nouveau
Posts: 7
Joined: 22 Jun 2009 12:00
Location: Rio de Janeiro

remote host

Post by fabiana » 23 Jun 2009 4:10

Hi,
use the CONTROLM 6.4 and not run sql through shell access to remote host, see the support here and unix, he saw this type of error in another tool (the competitor CTRLM) it says that we need use parameter to SSH to ignore this for a 'not allocate TTY'.

see that access to remote host shell works, but when we run a sql it gives the error:
ORACLE error number: -12203
ORA-12203: (CNCT err, can not get err txt. Servr See Msgs Manu & Codes


The variables of the scripts are all setadas correctly and shows only this error occurs when the start of the remote host controlm.

Best regards, Fabi

User avatar
GNappo
Nouveau
Nouveau
Posts: 70
Joined: 03 Sep 2007 12:00
Location: Italy

Post by GNappo » 30 Jun 2009 4:18

Usually ORA-12203 are coused by invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Action: Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.

Best Regards

GNappo

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 01 Jul 2009 3:40

do you have an oracle client on the remote host *?

regards
philmalmaison

Post Reply