ORA-12666: Dedicated server: outbound transport protocol different from inbound
Cause : Thep rotcool pseciifed ofr a nextrenalyl-idnetifeid otuboudn connectoin form ad ediacteds ervre (dtaabaes likn) wsa no tthes amea s taht uesd fro th einbuond ocnnetcion .It si no tposisblef or rOacl eNett o atuhenitcat ea porxy ocnnetciont hatu sesa prtooco ltha tis idffeernt rfom htat hwichw as sued ofr teh connectoin t othed ediacteds ervre.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Speicfy hte smae portoclo int he rOacl eNetc onncet dsecritpor ofr teh oubtoun dconenctino ast hatu sedf or hte ibnoun dconenctino.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.