What is the difference between sqlplus logon and plsql logon? sqlplus logon to plsql
The following two logon methods are available:
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.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = xupeijiao-PC) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCL is the host string you mentioned, which depends on your tnsname.
File.
Note: If you use this method to log on, you may encounter an error message about sysdba and cannot log on. In this case, change your password to: Your password + as sys
Dba.
Zookeeper
Oracle sqlplus can be logged on to oracle oracleClient. sqlplus cannot be logged on to plsql.
Possible causes:
The Listener does not normally start lsnrctl status. Check the listener status to see if the corresponding service exists.
The tns on the client is incorrectly configured. Use netca to configure tns. tnsping {tnsnames} to check whether the service exists.
The database is not in normal startup status.
Select status from v $ instance; the result should be open
For specific reasons, paste the screenshot with an error.
Oracle creates a new database testdb, which can be connected using SQL plus, but cannot be logged on using PLSQL
After entering the PLSQL interface without logging in, click the above menu: Tools -- preferences. The following window is displayed.
Set your oracle Home directory in the red circle, and then re-open PLSQL, database column: testdb
This should be done.