Jun 18, 2013 · host name: SELECT sys_context('USERENV', 'HOST') FROM DUAL; sys_context works great for many, many things: http://psoug.org/reference/sys_context.html. If you have access to the command line you can use listener status to get some more information.

Apr 6, 2004 · set your SQLPATH environment variable. that is where sqlplus looks for scripts. If I do a sqlplus /nolog, login.sql asks for a value for gname since I am not yet connected to any database. Is there a workaround?

May 13, 2014 · The most simple is to use tnsnames.ora file to connect to the database. For that edit it and add a new entry: This file normally resides in the $ORACLE HOME\NETWORK\ADMIN directory. myDb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = c)(Port =a)) ) (CONNECT_DATA = (SERVICE_NAME =b) ) )

Specify a SQL connect URL string using the following format: // host [:port][/ service_name] For example: //shobeen:1521/sales_us. Alternatively, specify the SQL connect information as an Oracle Net keyword-value pair. For example: “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=shobeen) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=sales_us)))”

May 6, 2008 · I am trying to connect to SQL Plus. What should I specify in host string. tnsnames.ora has following contents: apcl.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDR)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = apcl))) If use apcl.world as host string it gives me following error: TNS Could not resolve service ...

The most common approach is to put the databases you're connecting to into your tnsnames.ora; usually, your client installation contains an example tnsnames.ora file that you can modify. The easiest approach is probably to use EZConnect. An EZConnect string is built like <username>/<password>@<hostname>:<port>/SID

May 27, 2010 · I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora) I have this in my tnsnames.ora. POD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PODS.GATE.COM)(PORT = 1521)) (CONNECT_DATA = (SID = ODS)

Apr 3, 2020 · Please ensure you make appropriate changes to GLOBAL_DBNAME, SID_NAME, ORACLE_HOME & SERVICE_NAME in both of the above files. Also if you wish to make this database available over your network, get the HOST parameter configured as your machine IP instead of localhost.

Feb 15, 2012 · I want to connect to an oracle database located on another host using sqlplus. This page suggested adding an item on my tnsnames to connect to that database. (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= hostname.network)(Port= 1521)) (CONNECT_DATA = (SID = remote_SID)) and then use that in sqlplus.

A host string is the name you assign for TNS connectivity in tnsnames.ora. These entries typically identify the machine and port number and SID ( or service name) of the database you are trying to connect to. If the client and database are on same machine, you don't need a host string.