7

dimp V8：[WARNING]login fail, check your username and password, and check the se...

 1 year ago
source link: https://www.cnblogs.com/n00dle/p/17616954.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

dimp V8：[WARNING]login fail, check your username and password, and check the server status

　　在进行某个项目的性能测试时，我们选择了达梦8作为使用的数据库。前期我们在功能测试环境的达梦数据库服务上创建了用于压力测试的业务数据。后续，我们需要将这些数据导出并导入到一台专门用于性能测试的高性能服务器上（该服务器部署了相同版本的达梦8）。然而，在执行数据库文件导入操作时遇到了问题。以下是出现的错误及解决步骤：

1. 错误信息： 

[dmdba@iZ2ze3jv19mbskobub4323Z bin]$ ./dimp userid=V8xx_XXX_0725/‘“WzbJZcs_h4jHa#3K”’@127.0.0.1:5236 file="/home/dmdba/V8xx_XXX_0725.dmp" fromuser=V8xx_XXX_0725 touser=V8xx_XXX_0725 log=V8xx_XXX_0725_imp.log
dimp V8

[WARNING]login fail, check your username and password, and check the server status, please

[WARNING]import fail

2. 解决步骤： 反复检查数据库用户名和密码，确认均无异常。怀疑问题可能与数据库密码复杂度过高或包含特殊字符有关。为了解决这个问题，我们登入数据库并修改了数据库密码，具体步骤如下：

[dmdba@iZ2ze3jv19mbskobub4323Z bin]$ ./disql
disql V8
username:SYSDBA
password:

Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 2.188(ms)
SQL> ALTER USER V8xx_XXX_0725 IDENTIFIED BY "V8XX_123456789";
executed successfully
used time: 4.918(ms). Execute id is 59500.
SQL> quit

3. 导入成功： 经过修改数据库密码之后，再次执行导入操作，成功导入了数据库文件。

[dmdba@iZ2ze3jv19mbskobub4323Z bin]$ ./dimp userid=V8xx_XXX_0725/[email protected]:5236 file="/home/dmdba/V8xx_XXX_0725.dmp" fromuser=V8xx_XXX_0725 touser=V8xx_XXX_0725 log=V8xx_XXX_0725_imp.log
dimp V8

local code: PG_UTF8, dump file code: PG_GBK


[WARNING]the init param of LENGTH_IN_CHAR between server and file not fit

[WARNING]there maybe something error!!!
whether continue(y/n, 1/0):y

start importing schema[V8xx_XXX_0725]...

start importing the NECESSARY GLOBAL objects of the schema...

import instance's SEQUENCE objects...

import instance's SEQUENCE objects...

通过以上步骤，我们成功解决了数据库导入的问题，并顺利将数据库迁移到了专门用于性能测试的高性能服务器上。现在，我们可以继续进行后续的性能测试工作，以评估项目在高负载情况下的表现。


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK