Sqlplus log in and Plsql login differences

Here are two ways to log in, with Sqlplus login need to enter the host Word:

If you are using native Sql*plus to connect to the native database, the host string can be empty.

If you are connecting to an Oracle database remotely from XP, you can use the following methods
1. Start Oracle related server in Windows service;
2, in the XP command line with "Sqlplus/nolog" Login to SYSDBA Connection database ("Conn/as sysdba");
3, with "select name from V$database;" The name is the host string;
Use "SELECT * from Global_name;" View the global domain name.

What is the format of the Oracle Sqlplus connection database host string?

is the name of your database,
Search for Tnsnames.ora file name files under the Oracle installation path, open with text

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = xupeijiao-pc) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

Inside something similar to this format, ORCL is what you call the host string, which is determined by your tnsname

File.

Note: If you use this method to log in, you may not be able to log in with a SYSDBA error, and your password will be changed to: your password +as sys

Dba.



Sqlplus log in and Plsql login differences