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

Problem: emctl start dbconsole cannot be started

1. The Lsnrctl listener starts normally

2. The following error occurred when emca-config dbcontrol db-repos recreate rebuilt the database:

But it has also been set with export ORACLE_UNQNAME=orcl

3. View log error 111,

[tom@004 log] $pwd

/ u01/app/tom/product/11.2.0/dbhome_1/localhost_orcl/sysman/log

[tom@004 log] $more emdctl.trc

.

2014-06-28 01 Thread-3266332416 WARN http: nmehl_connect_internal: connect failed to (localhost:1158): deny connection (error = 111)

4. Including environment variables, / etc/hosts, / etc/sysconfig/network settings are also correct

5. [tom@004 log] $emctl status dbconsole

OC4J Configuration issue. / u01/app/tom/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_0.0.0.4_orcl not found.

Notice the red part, my hostname is 004, and when I look at emctl startup, some parameters are parsed to .0.0.04

Finally, the problem was solved by changing the hostname to zhou.

Problem: the following error occurred when connecting to the database with Oracle SQL Developer:

Listener does not currently know of sid

1. View the database instance name:

[tom@zhou ~] $echo $ORACLE_SID

Orcl

2. View relevant configuration files

[tom@zhou admin] $pwd

/ u01/app/tom/product/11.2.0/dbhome_1/network/admin

[tom@zhou admin] $ls

Listener.ora samples shrept.lst sqlnet.ora tnsnames.ora

[tom@zhou admin] $more tnsnames.ora

# tnsnames.ora Network Configuration File: / u01/app/tom/product/11.2.0/dbhome_1/

Network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

[tom@zhou admin] $more listener.ora

# listener.ora Network Configuration File: / u01/app/tom/product/11.2.0/dbhome_1/

Network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

)

)

ADR_BASE_LISTENER = / u01/app/tom

The red part should be localohst, and the default may be localhost.domain.

1. Environmental variables:

[tom@zhou ~] $cat .bash _ profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

Export ORACLE_SID=orcl

Export ORACLE_HOME=/u01/app/tom/product/11.2.0/dbhome_1

Export PATH=$ORACLE_HOME/bin:$PATH

Export ORACLE_HOSTNAME=localhost

[tom@zhou ~] $hostname

Zhou

2. Hosts file:

[tom@zhou ~] $

[tom@zhou ~] $cat / etc/hosts

127.0.0.1localhost.localdomainlocalhost.localdomainlocalhost4localhost4.localdomain4localhostzhou

:: 1localhost.localdomainlocalhost.localdomainlocalhost6localhost6.localdomain6 localhostzhou

3. Host name:

[tom@zhou ~] $hostname

Zhou

[tom@zhou ~] $cat / etc/sysconfig/network

NETWORKING=yes

HOSTNAME=zhou

To set the hostname, it is best to use root users to modify it using the setup tool. If you modify the hostname here, the system will change the configuration files in several places.

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.