1、SQL*PLUS连接时,需要输入的主机字符串是?
在 oracle/product/10.2.0/db_1/NETWORK/ADMIN 有个文件叫 TNSNAMES.ORA
里面有连接名,就是主机字符串,这里的test就是啦
test = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = HELLO) ) ),全局数据库名,默认为orcl,输入 orcl as sysdba
2、解锁账户
a、检查监听状态:lsnrctl status
b、启动监听: lsnrctl start
c、连接数据库:sqlplus /nolog
以超级管理员连接 conn / as sysdba
解锁账户 alter user system account unlock;(system账户)