I taught myself oracle, the host name is the default installation system before the host name, then install the database directly, basic normal running, I wants to change the default host name, after change as a result, database to monitor cannot be started
Host name localhost. Localdomain changed to abcpc
1 modify the/etc/sysconfig/network
2 use the hostname command to modify late let it take effect immediately restart
The inside of the 3 revised listener. Ora host value
The inside of the 4 revised tnsnames. Ora host value
System is the redhat 6
Oracle11g 11.2 installation,
Found no problem, open the database after listening always cannot be started, and it feels like to miss the file is not modified, could you tell me what is the file
Thank you for your patience to read
True kindness genuflect is begged
Beginners small white
CodePudding user response:
Listen to start to what's wrong? Can provide to you, or you look at the oracle user. Under the following environment variable configuration of the host name if there is any updateCodePudding user response:
Look at the cat listener. Ora content?Ping the host name?
CodePudding user response:
Start listening to normal (I correct myself, I am listening to start is not an error, but view state error, embarrassed)
[oracle @ abcpc admin] $LSNRCTL start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14 - SEP - 2020 08:45:21
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting/u01/app/oracle/product/11.2.0/dbhome_1/bin/TNSLSNR: both please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
The System parameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener. Ora
Log messages written to/u01/app/oracle/diag TNSLSNR abcpc/listener/alert Log. The XML
Listening on: (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=))
Connecting to (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=))
The STATUS of the LISTENER
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
The Start Date of 14 - SEP - 2020 08:45:21
Uptime 0 days 0 hr. 0 min. 10 SEC
The Trace Level off
Security ON: the Local OS Authentication
SNMP OFF
The Listener Parameter File/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/Listener. Ora
The Listener Log File/u01/app/oracle/diag/TNSLSNR/abcpc/Listener/alert Log. XML
Listening Endpoints Summary...
(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=))
Services the Summary...
Service "tsetdb.com" has 1 instance (s).
Instance "tsetdb", the status READY, from 1 handler (s) for this service...
Service "tsetdbXDB.com" has 1 instance (s).
Instance "tsetdb", the status READY, from 1 handler (s) for this service...
The command completed successfully
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
To check the monitoring state error
[oracle @ abcpc admin] $LSNRCTL status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14 - SEP - 2020 08:45:46
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=))
TNS - 12541: TNS: no listener
TNS - 12560: TNS: protocol adapter error
TNS - 00511: No listener
Linux Error: 111: Connection refused
Update all the following
[oracle @ abcpc ~] $the following
#. The following
# Get the aliases and functions provides
If [- f ~/bashrc]; Then
. ~/.bashrc
Fi
# the User specific environment and startup designed
PATH=$PATH: $HOME/bin
The export PATH
The export is=tsetdb
Export ORACLE_BASE=/u01/app/oracle
Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
The export PATH=$ORACLE_HOME/bin: $PATH
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Monitor file
[oracle @ abcpc admin] $cat listener. Ora
# listener. Ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/Network/admin/listener. Ora
# Generated by Oracle configuration tools.
The LISTENER=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=)
)
ADR_BASE_LISTENER=/u01/app/oracle
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
[oracle @ abcpc admin] $cat/etc/hosts
127.0.0.1 abcpc
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
[oracle @ abcpc admin] $cat tnsnames. Ora
# tnsnames. Ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/Network/admin/tnsnames. Ora
# Generated by Oracle configuration tools.
TSETDB=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=tsetdb.com)
)
)
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
[oracle @ abcpc admin] $cat tnsnames. Ora
# tnsnames. Ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/Network/admin/tnsnames. Ora
# Generated by Oracle configuration tools.
TSETDB=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=abcpc) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=tsetdb.com)
)
)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull