oracle 配置 sys 远程连接

记录一个oracle sys 用户远程连接失败的问题。

oracle 19c
SID=ORA19C
SERVICE_NAME=ORA19C

在 sqlplus 执行：

SQL> show user
USER is "SYS"
SQL> alter system set remote_login_passwordfile=exclusive scope=spfile;
alter system set remote_login_passwordfile=exclusive scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use


SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> create spfile from pfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> write to SPFILE requested but no SPFILE is in use^C

SQL> startup;
ORACLE instance started.

Total System Global Area 2432695872 bytes
Fixed Size                  9137728 bytes
Variable Size             536870912 bytes
Database Buffers         1879048192 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.

此时，会创建文件：/opt/oracle/product/19c/dbhome_1/dbs/spfileORA19C.ora

在 SHELL 中执行：

cd /opt/oracle/product/19c/dbhome_1/dbs
orapwd file=orapwORA19C

参考连接：
https://blog.csdn.net/haiross/article/details/41696035
https://m.yisu.com/zixun/36783.html