【YashanDB知识库】yasql / as sysdba无法登录

合集 - 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-27

50.【YashanDB知识库】yasql / as sysdba无法登录2024-12-27

51.【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-3163.【YashanDB知识库】sys登录提示账户被锁，怎么处理？2024-12-3164.【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/7817892.html?templateId=1718516

【问题分类】功能使用

【关键字】操作系统认证、免密登录

【问题描述】

将yashan用户加入YASDBA用户组，且确定了yasdb_net.ini中ENABLE_LOCAL_OSAUTH=ON，免密登录仍然失败。但是可以通过用户密码登录数据库。

【问题原因分析】

报错是说找不到文件，确认YASDB_HOME和YASDB_DATA等环境变量是否配置正确。

最后确认是环境变量中YASDB_DATA的路径配置认为修改错了，该环境中正常的路径为

YASDB_HOME=/data/yashan/yasdb_home

YASDB_DATA=/data/yashan/yasdb_data/db-1-1

由于人为手动变更过文件目录，将其配置成

YASDB_HOME=/data/yashan/yasdb_home

YASDB_DATA=/data/yashan/yasdb_data ——错误

【解决/规避方法】将环境变量中的YASDB_DATA配置为正确的目录，即可以正常通过yasql / as sysdba登录。

【影响范围】当前所有版本

【修复版本】-