<div>
Try to see if you are able to ping the IP of Oracle database server machine.
</div>


Try to see if you are able to ping the IP of Oracle database server machine.

<div>
assuming windows here ... <br />
<br />
you might have script on your computer like this <br />
<br />
sqlplus.cmd<br />
<br />

<pre><code id="code-20-40774896-1">toad %1 %2 %3 %4 </code></pre>
<br />
what happens if you type sqlplus without any parameters ?<br />
can you see the header of sqlplus ?<br />
<br />
and then enter user@alias<br />
and password <br />
<br />
and then what happens ?
</div>


assuming windows here ...

you might have script on your computer like this

sqlplus.cmd



toad %1 %2 %3 %4 


what happens if you type sqlplus without any parameters ?
can you see the header of sqlplus ?

and then enter user@alias
and password

and then what happens ?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Oracle 9:<br />
When i type sqlplus in command line and enter username and password, i can able to login in.<br />
<br />
When i type sqlplus username@instance , it ask for password , when i type password it throws error .<br />
<br />
Error: ORA-12154 ``TNS:could not resolve service name&quot;<br />
<br />
Please help me understand why it occurs , i googled but dont understand what they trying to convey.<br />
<br />
Thanks
</div>
</div>


Hi,

Oracle 9:
When i type sqlplus in command line and enter username and password, i can able to login in.

When i type sqlplus username@instance , it ask for password , when i type password it throws error .

Error: ORA-12154 ``TNS:could not resolve service name"

Please help me understand why it occurs , i googled but dont understand what they trying to convey.

Thanks

Sqlplus doubt

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.