--Parameters for multiple listener protocol addresses for service in tnsnames.ora
FAILOVER (Default - on) - if on - fail over to next listener if the first listener failsLOAD_BALANCE (Default -off) - if on - random sequence--client tracingcat sqlnet.ora
TRACE_LEVEL_CLIENT=admin--exampleoracle@rac1:/tmp> mkdir tns
oracle@rac1:/tmp> cd tns
oracle@rac1:/tmp/tns> sqlplus -L t/t@rac1
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 23 16:30:51 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus
oracle@rac1:/tmp/tns> ls
cli_31630.trc
--Startup via tns (ora-12514)Solution use static database registration instead of dynamic in listener.ora,restart listenerandConnect as :sqlplus sys@rac1 as sysdba
Комментариев нет:
Отправить комментарий