【YashanDB知识库】sys登录提示账户被锁，怎么处理？

合集 - YashanDB知识库（2）(100)

1.【YashanDB知识库】如何设置yasql客户端的字符编码2024-12-102.【YashanDB知识库】exp导出csv报错YAS-00218 string conversion failed2024-12-123.【YashanDB知识库】YAS-00218 string conversion failed.2024-12-124.【YashanDB知识库】虚拟机重启后启动YMP报错2024-12-125.【YashanDB知识库】OM仲裁节点故障后手工切换方案和yasom仲裁重新部署后重新纳管数据库集群方案2024-12-126.【YashanDB知识库】oracle与yashanDB的jdbc返回常量列"0.00"的精度和刻度不一致2024-12-137.【YashanDB知识库】UNDO表空间膨胀怎么处理2024-12-138.【YashanDB知识库】如何将mysql含有group by的SQL转换成崖山支持的SQL2024-12-139.【YashanDB知识库】同样建表语句，大整型数字在Oracle插入成功，在YashanDB插入失败2024-12-1310.【YashanDB知识库】要有好的跑批性能，有哪些参数要注意2024-12-1311.【YashanDB知识库】MySQL迁移至崖山char类型数据自动补空格问题2024-12-1612.【YashanDB知识库】kettle同步PG至崖山提示no encryption pg_hba.conf记录2024-12-1613.【YashanDB知识库】kettle同步大表提示java内存溢出2024-12-1614.【YashanDB知识库】查看表空间是否加密2024-12-1615.【YashanDB知识库】误配置SYSTEM级别的STATISTICS_LEVEL参数为ALL导致数据库性能下降2024-12-1716.【YashanDB知识库】用yasldr配置Bulkload模式作单线程迁移300G的业务数据到分布式数据库，迁移任务频繁出错2024-12-1717.【YashanDB知识库】YCP单机部署离线升级-rpc升级方式详细步骤2024-12-1718.【YashanDB知识库】YCP高可用部署离线升级-rpc升级详细步骤2024-12-1719.【YashanDB知识库】如何处理yasql输入交互模式下单行字符总量超过限制4000字节2024-12-1720.【YashanDB知识库】IMP跨网络导入慢问题2024-12-1921.【YashanDB知识库】insert语句有编码不识别字，执行卡住问题2024-12-1922.【YashanDB知识库】服务器重启后Yashandb无法启动2024-12-1923.【YashanDB知识库】如何处理no free block in dictionary cache2024-12-1924.【YashanDB知识库】in大量参数时查询性能慢2024-12-1925.【YashanDB知识库】Oracle pipelined函数在YashanDB中的改写2024-12-2326.【YashanDB知识库】update (子查询) set ORG_ID_STAN -ID 改写2024-12-2327.【YashanDB知识库】XMLAGG方法的兼容2024-12-2328.【YashanDB知识库】YMP迁移过程中报错YAS-02143或YAS-021932024-12-2329.【YashanDB知识库】复合索引下in大量参数查询性能慢2024-12-2330.【YashanDB知识库】jdbc查询st_geometry类型的数据时抛出YAS-00101 cannot allocate 0 bytes for anlHeapMalloc异常2024-12-2331.【YashanDB知识库】JDBC驱动的date类型字段结果集调用getString方法只返回日期，不返回时分秒2024-12-2332.【YashanDB知识库】Mybatis-Plus调用YashanDB怎么设置分页2024-12-2333.【YashanDB知识库】ycm-YashanDB列表有数据库显示故障排除步骤2024-12-2334.【YashanDB知识库】单机部署报错：prohibited operation, please check if the IP and username are correct2024-12-2335.【YashanDB知识库】启动数据库时报错：YAS-02059 control file version 0.2.64 is incompatible with YashanDB version 0.2.652024-12-2436.【YashanDB知识库】如何处理报错"UDT column batch insert" has not been implemented yet2024-12-2437.【YashanDB知识库】如何解决共享集群部署遇到报错：YAS-05721 invalid input parameter, reason: node name invalid.2024-12-2438.【YashanDB知识库】如何排查YMP报错：”OCI版本为空或OCI的架构和本地系统的架构不符“2024-12-2439.【YashanDB知识库】如何限制用户session连接数2024-12-2440.【YashanDB知识库】通过dblink查询Oracle数据时报YAS-07301异常2024-12-2541.【YashanDB知识库】使用leading hint调整SQL执行计划后报错YAS-04522 invalid hint leading2024-12-2542.【YashanDB知识库】通过触发器复制varchar(4000 char)列的数据导致乱码2024-12-2543.【YashanDB知识库】由于druid中间件配置导致的YAS-04003 maximum number of open cursors is 10002024-12-2544.【YashanDB知识库】exp 导出数据库时，报错YAS-004022024-12-2545.【YashanDB知识库】YAS-00004 feature "implict table" has not been implemented yet2024-12-2746.【YashanDB知识库】YAS-04003 maximum number of open cursors is xxx2024-12-2747.【YashanDB知识库】YAS-04209 unexpected word ;2024-12-2748.【YashanDB知识库】yasboot集群状态命令登录失败问题2024-12-2749.【YashanDB知识库】YAS-00004 feature "create user" has not been implemented yet2024-12-2750.【YashanDB知识库】yasql / as sysdba无法登录2024-12-2751.【YashanDB知识库】启动yasom时报错：sqlite connection error2024-12-2752.【YashanDB知识库】使用vmware虚拟机安装的YashanDB，本机无法访问2024-12-2753.【YashanDB知识库】安装过程报错: unable to authenticate, attempted methods [none password], no supported methods remain2024-12-2754.【YashanDB知识库】密码带特殊符号登录报错YAS-02143 invalid username/password, login denied2024-12-2755.【YashanDB知识库】如何使用jdbc向YashanDB批量插入gis数据2024-12-3056.【YashanDB知识库】如何在备机节点上做备份和恢复2024-12-3057.【YashanDB知识库】收集统计信息时报错YAS-00507 date/timestamp value overflow2024-12-3058.【YashanDB知识库】druid连接池查询空间数据报错read time out2024-12-3059.【YashanDB知识库】hive初始化崖山报错YAS-042092024-12-3060.【YashanDB知识库】imp导入数据库时，报错YAS-080232024-12-3161.【YashanDB知识库】listagg拼接结果发生溢出2024-12-3162.【YashanDB知识库】python驱动查询gbk字符集崖山数据库CLOB字段，数据被驱动截断2024-12-31

63.【YashanDB知识库】sys登录提示账户被锁，怎么处理？2024-12-31

64.【YashanDB知识库】YAS-00402 failed to connect socket, errno 111, error message "Connection refused"2024-12-3165.【YashanDB知识库】YAS-02287 audit policy cannot be dropped as it is currently enabled01-0266.【YashanDB知识库】YAS-02507 base incremental backup set does not exist01-0267.【YashanDB知识库】YAS-02547 there is a gap in the restored archived logs on instance 1, reason: start of restored archive 35 is greater than database last archive 2101-0268.【YashanDB知识库】YAS-02605 the current instance is not master role01-0269.【YashanDB知识库】YAS-04379 invalid alteration of datatype01-0270.【YashanDB知识库】YAS-05534 unsupport operation: Create sibling files to diskgroups01-0671.【YashanDB知识库】YDC连接数据库报错yasdb return code is zero01-0672.【YashanDB知识库】YMP迁移达梦时，报错：查询出现异常01-0673.【YashanDB知识库】查询空间数据提示This socket has been closed.01-0674.【YashanDB知识库】数据库用户所拥有的权限查询01-0675.【YashanDB知识库】JDBC查询时抛出YAS-02094 current session has been killed or canceled异常01-0776.【YashanDB知识库】YashanDB JDBC驱动查询时抛出io fail：Read timed out异常01-0777.【YashanDB知识库】YCM上CPU负载超过实际核数是怎么回事01-0778.【YashanDB知识库】使用Reverse索引的解决自增序列做索引，插入性能大幅提升01-0779.【YashanDB知识库】YMP从达梦迁移到崖山，报错：不能识别文件路径，没找到csv文件01-0780.【YashanDB知识库】YMP在迁移过程中，遇到报错：failed to open file /qianyi/ymp/ymp_23.3, errno 2, error message "No such file or directory".01-0981.【YashanDB知识库】解决mybatis的mapper文件sql语句结尾加分号";"报错01-0982.【YashanDB知识库】进行load data的时候报找不到动态库liblz4.so01-0983.【YashanDB知识库】如何解决删除分区后索引失效问题01-0984.【YashanDB知识库】如何输入小写表名的函数参数01-0985.【YashanDB知识库】审计表UNIFIED_AUDIT_TRAIL出现YAS-00220 utf8 sequence is wrong01-1086.【YashanDB知识库】kettle做增量同步，出现报错：Unrecognized VM option 'MaxPermSize-256m'01-1087.【YashanDB知识库】YashanDB run.log中有slow log queue is full信息01-1088.【YashanDB知识库】YCM托管YashanDB报错 /home/yashan/.yasboot/.env is not existed01-1089.【YashanDB知识库】使用yasboot查看YashanDB status为unconnected，但是YashanDB运行正常01-1090.【YashanDB知识库】YMP从mysql迁移到崖山，报错：服务器错误01-1091.【YashanDB知识库】使用DBeaver 插入数据 nvarchar字段插入为空01-1092.【YashanDB知识库】崖山BIT类型对MYSQL兼容问题01-1093.【YashanDB知识库】YDC无法通过conn切换用户01-1094.【YashanDB知识库】YMP校验从yashandb同步到oracle的数据时，字段timestamp(0)出现不一致01-1695.【YashanDB知识库】并发update报错YAS-02208 lock conflict in consistent write01-1696.【YashanDB知识库】导入数据时报错：YAS-00008 type convert error：literal does not match format string01-1697.【YashanDB知识库】druid连接池做断网测试，无法自动重新连接01-1698.【YashanDB知识库】Hive 命令工具insert崖山数据库报错01-1699.【YashanDB知识库】load data一次导入多个文件的数据时报错01-16100.【YashanDB知识库】YAS-02143 invalid username/password, login denied01-16

收起

本文内容来自YashanDB官网，原文内容请见 https://www.yashandb.com/newsinfo/7849013.html?templateId=1718516

【问题分类】功能使用

【关键字】YAS-02193、锁定、登录、被锁、locked

【问题描述】登录提示账户被锁，无法登录数据库。

【问题原因分析】锁定是因为密码错误之后，连接重试太多导致。检查一下密码是否正确或者是否有外部链接使用错误的密码不断尝试连接，导致用户不断被锁定。

【解决/规避方法】

解锁sys用户。

1、通过免密登录到数据库

yasql / as sysdba

这里注意要将数据库安装用户添加到系统YASDBA组，如果已添加，可忽略，没有添加参考下面：

usermod -G YASDBA yashan

2、解锁sys用户

alter user sys account unlock;

#查看用户状态select username,account_status from dba_users;

3、测试环境建议将profile的 密码错误锁定次数设置为unlimited，这样sys用户不会因为密码试错而锁定

alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED;