1、默认实例登录,sqlplus username/password 如:sqlplus tas_yn/tas_yn
2、选择实例登录,sqlplus username/password@net_service_name 如:sqlplus tas_yn/tas_yn@orcl10g
3、dba用户登录,sqlplus username/password as sysdba 如:sqlplus sys/oracle as sysdba
4、连接远程数据库实例,sqlplus username/password@host:port/sid 如:sqlplus tas_yn/tas_yn@192.168.0.101:1521/orcl10g
2、选择实例登录,sqlplus username/password@net_service_name 如:sqlplus tas_yn/tas_yn@orcl10g
3、dba用户登录,sqlplus username/password as sysdba 如:sqlplus sys/oracle as sysdba
4、连接远程数据库实例,sqlplus username/password@host:port/sid 如:sqlplus tas_yn/tas_yn@192.168.0.101:1521/orcl10g