Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

An example of sqlplus login error processing in aix system database

2025-02-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/02 Report--

During the process of setting up the oracle12c slave, the sqlplus login error was found as follows:

[xdhsdb@oracle:/oracle] $sqlplus

Exec (): 0509-036Cannot load program sqlplus because of the following errors:

0509-130 Symbol resolution failed for / oracle/app/oracle/product/12.2.0/dbhome_1/lib/libons.so because:

0509-136Symbol CreateIoCompletionPort (number 93) is not exported from

Dependent module / unix.

0509-136 Symbol GetQueuedCompletionStatus (number 94) is not exported from

Dependent module / unix.

0509-136 Symbol ReadFile (number 95) is not exported from

Dependent module / unix.

0509-136 Symbol WriteFile (number 96) is not exported from

Dependent module / unix.

0509-026 System error: Error 0

0509-192 Examine .loader section symbols with the

'dump-Tv' command.

Because the author previously unzipped the tar package to install oracle, there is no problem. There are all system-related problems on the Internet.

After checking the iocp parameters, there is no change.

[xdhsdb@oracle:/oracle] $lsdev | grep iocp

Iocp0 Defined I/O Completion Ports

Solve the problem after rebooting the modified parameters

[xdhsdb@root:/] # chdev-l iocp0-P-an autoconfig='available'

Iocp0 changed

Summary:

Because the rootvg of the slave is copied through cloning, although the parameter of the clone is modified, it is found that this parameter will be reset to the default state after cloning.

Other system parameters also need to be modified and restarted

Chdev-l sys0-a maxuproc=16384

Chdev-l sys0-a maxbuf=500

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report