Keywords: if the host string in oracle is connected to the local database using the local SQL * Plus, ldquo; host string rdquo; can be empty. For remote connection
Keywords: if the host string in oracle is connected to the local database using the local SQL * Plus, ldquo; host string rdquo; can be empty. For remote connection
Keywords: host string in Oracle
If the local SQL * Plus is used to connect to the local database, the "host string" can be blank.
To remotely connect to the xp oracle database, use the following method:
1. Start oracle-related servers in windows;
2. log on to the xp command line using "sqlplus/nolog" and use sysdba to connect to the database ("conn/as sysdba ");
3. Use the "select name from v $ database;" name as the host string;
Use "select * from global_name;" to view the global domain name.
What is the format of the string used to connect oracle sqlplus to the Database Host?
Is your database name,
Search for the tnsnames. ora file name in the oracle installation path and open it in text.
ORA9I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = xx. xx) (PORT = XXXX ))
)
(CONNECT_DATA = (SID = ORA9I) (SERVER = DEDICATED ))
)
ORA9I is the host string you mentioned, that is, ORA9I = this location.