Ora-12170: Tns:connect Timeout Occurred
Feb 15, 2018 I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question.Provide details and share your research! Asking for help, clarification, or responding to other answers. I tried to connect though SqlPlus but the same error(ORA-12170: TNS:Connect timeout occurred). I tried to ping the using host name i am getting in my hosting server(win2008R2) approximate round trip times in milli-seconds: mininum=0,maximum=0,average=0.
in Oci8.php line 84
at HandleExceptions->handleError('2', 'oci_connect(): ORA-12170: TNS:Connect timeout occurred', '/home/vagrant/Code/restApiRSHS/vendor/yajra/laravel-pdo-via-oci8/src/yajra/Pdo/Oci8.php', '84', array('dsn' => 'orcl', 'username' => 'homestead', 'password' => 'secret', 'options' => array('2', '2', '0', 'charset' => 'AL32UTF8'), 'charset' => 'AL32UTF8'))
at oci_connect('homestead', 'secret', 'orcl', 'AL32UTF8') in Oci8.php line 84
at Oci8->__construct('orcl', 'homestead', 'secret', array('2', '2', '0', 'charset' => 'AL32UTF8')) in OracleConnector.php line 189
at OracleConnector->createConnection('orcl', array('driver' => 'oracle', 'tns' => 'orcl', 'host' => 'localhost', 'port' => '1521', 'database' => 'homestead', 'username' => 'homestead', 'password' => 'secret', 'charset' => 'AL32UTF8', 'prefix' => '), array('2', '2', '0')) in OracleConnector.php line 36
at OracleConnector->connect(array('driver' => 'oracle', 'tns' => 'orcl', 'host' => 'localhost', 'port' => '1521', 'database' => 'homestead', 'username' => 'homestead', 'password' => 'secret', 'charset' => 'AL32UTF8', 'prefix' => ')) in Oci8ServiceProvider.php line 40
at Oci8ServiceProvider->yajraOci8{closure}(array('driver' => 'oracle', 'tns' => 'orcl', 'host' => 'localhost', 'port' => '1521', 'database' => 'homestead', 'username' => 'homestead', 'password' => 'secret', 'charset' => 'AL32UTF8', 'prefix' => '), 'oracle')
Ora-12170: Tns:connect Timeout Occurred In Toad
my host isn't localhost,my username isn't homestead,my password isn't secret