• 【案例】ORA-12154: TNS:could not resolve the connect identifier specified


    故障排查:

    $ sqlplus srv_ze/"xx@19"@orcl

    SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 16 09:57:35 2020

    Copyright (c) 1982, 2013, Oracle. All rights reserved.

    ERROR:
    ORA-12154: TNS:could not resolve the connect identifier specified


    Enter user-name:
    ERROR:
    ORA-01017: invalid username/password; logon denied

    Linux平台登录方式: 'srv_ze/"xx@19"'@orcl --1个双引号扩密码,1个单引号扩 用户名+密码,即: '用户名/"密码"'@服务名

    Oracle密码策略

    SQL> set linesize 333
    SQL> col profile for a20
    SQL> col resource_name for a25
    SQL> col resource for a15
    SQL> col limit for a20
    SQL> select * from dba_profiles where profile='DEFAULT'  and resource_type='PASSWORD';

    PROFILE RESOURCE_NAME RESOURCE LIMIT
    -------------------- ------------------------- -------- --------------------
    DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
    DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
    DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
    DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
    DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
    DEFAULT PASSWORD_LOCK_TIME PASSWORD UNLIMITED
    DEFAULT PASSWORD_GRACE_TIME PASSWORD UNLIMITED

    DEFAULT     FAILED_LOGIN_ATTEMPTS       密码出错次数(超过次数后账号将锁定)
    DEFAULT     PASSWORD_LIFE_TIME              密码有效期(天)
    DEFAULT     PASSWORD_REUSE_TIME         密码不能重新用的天数
    DEFAULT     PASSWORD_REUSE_MAX                密码重用之前修改的最少次数
    DEFAULT     PASSWORD_VERIFY_FUNCTION        密码复杂度
    DEFAULT     PASSWORD_LOCK_TIME        PASSWORD 1  超过了1天后,帐号自动解锁
    DEFAULT     PASSWORD_GRACE_TIME       PASSWORD 7 密码到期提前7天提配

  • 相关阅读:
    Dockerfile指令
    oracle--ORA-38760
    守护进程--Supervisor
    oracle--sqlplus格式化输出
    oracle--10.2.0.3升级到11.2.0.4
    oracle--ORA-27125
    oracle--10安装问题
    oracle--CKPT
    oracle--LGWR
    Oracle--SMON
  • 原文地址:https://www.cnblogs.com/elontian/p/13323064.html
Copyright © 2020-2023  润新知