[oracle@tyger admin]$ cat sqlnet.ora NAME.DIRECTORY_PATH=(tnsnames,ezconnect) SQLNET.AUTHENTICATION_SERVICES=(NTS) [oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:48:15 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SYS@ORCL>show parameter remote NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ remote_archive_enable string true remote_dependencies_mode string TIMESTAMP remote_listener string remote_login_passwordfile string EXCLUSIVE remote_os_authent boolean FALSE remote_os_roles boolean FALSE SYS@ORCL>alter system set remote_login_passwordfile=none scope=spfile; System altered. ---静态参数,重启数据库生效 SYS@ORCL>shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SYS@ORCL>startup ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [oracle@tyger admin]$ vim sqlnet.ora NAME.DIRECTORY_PATH=(tnsnames,ezconnect) #SQLNET.AUTHENTICATION_SERVICES=(NTS) [oracle@tyger admin]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 10:57:25 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SYS@ORCL>startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 96470608 bytes Database Buffers 184549376 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SYS@ORCL>show parameter remote NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ remote_archive_enable string true remote_dependencies_mode string TIMESTAMP remote_listener string remote_login_passwordfile string NONE remote_os_authent boolean FALSE remote_os_roles boolean FALSE SYS@ORCL>alter system set remote_login_passwordfile=exclusive scope=spfile; System altered. SYS@ORCL>shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SYS@ORCL>startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 96470608 bytes Database Buffers 184549376 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SYS@ORCL>show parameter remote NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ remote_archive_enable string true remote_dependencies_mode string TIMESTAMP remote_listener string remote_login_passwordfile string EXCLUSIVE remote_os_authent boolean FALSE remote_os_roles boolean FALSE SYS@ORCL>exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [oracle@tyger admin]$ sqlplus sys/oracle@ORCL as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 28 11:04:16 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SYS@ORCL> |