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

Brief notes on oracle installation

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

| 1 | configure user environment |

Vi / home/oracle/.bash_profile # adds the following code at the end

Export ORACLE_BASE=/data/oracle # oracle database installation directory

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 # oracle database path

Export ORACLE_SID=orcl # oracle startup database instance name

Export ORACLE_TERM=xterm # xterm window mode installation

Export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH # add system environment variables

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib # add system environment variables

Export LANG=C # to prevent garbled code during installation

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK # sets the Oracle client character set, which must be consistent with the character set set when Oracle is installed, such as ZHS16GBK, otherwise there will be garbled characters in data import and export

2 | netca cannot be started:

Switch to root and run xhost +

3 | failed to start listening:

[oracle@oracle ~] $lsnrctl start since01

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 09-JUN-2014 21:24:23

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting / data/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0-Production

System parameter file is / data/oracle/product/11.2.0/db_1/network/admin/listener.ora

Log messages written to / data/oracle/diag/tnslsnr/oracle/since01/alert/log.xml

Error listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=202.102.110.203) (PORT=1529)

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

Linux Error: 99: Cannot assign requested address

Listener failed to start. See the error message (s) above...

Modify the configuration file: / data/oracle/product/11.2.0/db_1/network/admin/listener.ora, change ip to the local address or, 127.0.0.1

4 | enterprise manager configuration failed due to the following error

Do not check the enterprise configuration when configuring dbca

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

Database

Wechat

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

12
Report