Home » RDBMS Server » Enterprise Manager » 404 not found even sqlplus client connect to finelly with oracle server (oracle 11gr2 in centos 6.4)
404 not found even sqlplus client connect to finelly with oracle server [message #676955] Thu, 01 August 2019 07:33 Go to next message
rahulvishwakarma
Messages: 11
Registered: April 2014
Junior Member
hi to all, I've centos 6.4 as client and server both in VM. After installation of oracle 11gr2 it's fine but after some days when I restarted OEM there was an error 404 not found. But even i can login from client sqlplus and can run the sql queries only em is down. I also did this :-
[root@serverora11gr2 Desktop]# lsnrctl stop

LSNRCTL FOR Linux: Version 11.2.0.4.0 - Production ON 29-JUL-2019 14:30:08

Copyright (c) 1991, 2013, Oracle.  ALL rights reserved.

Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[root@serverora11gr2 Desktop]# lsnrctl START

LSNRCTL FOR Linux: Version 11.2.0.4.0 - Production ON 29-JUL-2019 14:30:18

Copyright (c) 1991, 2013, Oracle.  ALL rights reserved.

Starting /opt/oracle/app/oracle/product/11.2/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR FOR Linux: Version 11.2.0.4.0 - Production
System parameter file IS /opt/oracle/app/oracle/product/11.2/dbhome_1/network/admin/listener.ora
Log messages written TO /opt/oracle/app/oracle/diag/tnslsnr/serverora11gr2/listener/alert/log.xml
Listening ON: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening ON: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serverora11gr2)(PORT=1521)))

Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS OF the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR FOR Linux: Version 11.2.0.4.0 - Production
START DATE                29-JUL-2019 14:30:18
Uptime                    0 days 0 hr. 0 MIN. 0 sec
Trace Level               off
Security                  ON: LOCAL OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/app/oracle/product/11.2/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/app/oracle/diag/tnslsnr/serverora11gr2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serverora11gr2)(PORT=1521)))
The listener supports no services
The command completed successfully

after that :-

[root@serverora11gr2 Desktop]# emca -config dbcontrol db -repos CREATE

STARTED EMCA at Jul 29, 2019 2:31:56 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  ALL rights reserved.

Enter the following information:
DATABASE SID: orcl
Jul 29, 2019 2:32:03 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Jul 29, 2019 2:32:03 PM oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
SEVERE:
DATABASE instance IS unavailable. Fix the ORA error thrown AND run EM Configuration Assistant again.

SOME OF the possible reasons may be :

1) DATABASE may NOT be up.
2) DATABASE IS started setting environment variable ORACLE_HOME WITH TRAILING '/'. Reset ORACLE_HOME AND bounce the DATABASE.

FOR eg. DATABASE IS started setting environment variable ORACLE_HOME=/scratch/db/ . Reset ORACLE_HOME=/scratch/db  AND bounce the DATABASE.
after checking for emctl status :-

[root@serverora11gr2 Desktop]# emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
https://serverora11gr2.db.net:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. 
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/app/oracle/product/11.2/dbhome_1/serverora11gr2.db.net_orcl/sysman/log 

[Updated on: Thu, 01 August 2019 07:40]

Report message to a moderator

Re: 404 not found even sqlplus client connect to finelly with oracle server [message #676956 is a reply to message #676955] Thu, 01 August 2019 11:12 Go to previous messageGo to next message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
You seem to have two Oracle Homes installed, 11.2.0.3 an d 11.2.0.4 which is not a problem as long as you know which one you want to connect to and set your ORACLE_HOME and PATH variables accordingly.
Also, you are running those commands as root. You can't do that, it won;t work.
Re: 404 not found even sqlplus client connect to finelly with oracle server [message #676964 is a reply to message #676956] Fri, 02 August 2019 03:35 Go to previous messageGo to next message
rahulvishwakarma
Messages: 11
Registered: April 2014
Junior Member
no i've only 11.2.0.4, another question is :Quote:
The listener supports no services
mine ~/.bash_profile file settings is :-

   TMPDIR=/tmp; export TMPDIR
    ORACLE_HOSTNAME=`hostname`; export ORACLE_HOSTNAME
    ORACLE_SID=orcl; export ORACLE_SID
    ORACLE_UNQNAME=orcl export ORACLE_UNQNAME
    ORACLE_BASE=/opt/oracle/app/oracle; export ORACLE_BASE
    ORACLE_TERM=xterm; export ORACLE_TERM
    ORACLE_HOME=/opt/oracle/app/oracle/product/11.2/dbhome_1; export ORACLE_HOME
    PATH=/usr/bin:$PATH:$ORACLE_HOME/bin; export PATH

    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
    CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

also i ran following command as user oracle :-
[oracle@serverora11gr2 Desktop]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-AUG-2019 01:22:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-01190: The user is not authorized to execute the requested listener command
[oracle@serverora11gr2 Desktop]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-AUG-2019 01:22:10

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

TNS-01106: Listener using listener name listener has already been started
[oracle@serverora11gr2 Desktop]$ emca -config dbcontrol db -repos CREATE

STARTED EMCA at Aug 2, 2019 1:22:29 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: y
Listener ORACLE_HOME [ /opt/oracle/app/oracle/product/11.2/dbhome_1 ]: 
Password for SYS user:  elloToon#123
Password for DBSNMP user:  elloToon#123
Password for SYSMAN user:  elloToon#123
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional): 
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /opt/oracle/app/oracle/product/11.2/dbhome_1

Local hostname ................ serverora11gr2.db.net
Listener ORACLE_HOME ................ /opt/oracle/app/oracle/product/11.2/dbhome_1
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 2, 2019 1:23:45 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/app/oracle/cfgtoollogs/emca/orcl/emca_2019_08_02_01_22_29.log.
Aug 2, 2019 1:23:45 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.

how to recover The "listener supports no services"
and how to up OEM

[Updated on: Fri, 02 August 2019 03:36]

Report message to a moderator

Re: 404 not found even sqlplus client connect to finelly with oracle server [message #676966 is a reply to message #676964] Fri, 02 August 2019 04:46 Go to previous messageGo to next message
John Watson
Messages: 8426
Registered: January 2010
Location: Global Village
Senior Member
Quote:
no i've only 11.2.0.4
Better check and confirm this statement, because you previous post did show this:
Quote:
EM Configuration Assistant, Version 11.2.0.3.0 Production
And you must read messages, such as this:
Quote:
TNS-01190: The user is not authorized to execute the requested listener command
This tells me that the listener may be running under a different account. I noticed earlier that you were trying to do things as root, which you cannot do. You need to stop the tnslsnr process, I would use kill -9 on it, then you should be able to start it correctly.

Re: 404 not found even sqlplus client connect to finelly with oracle server [message #676986 is a reply to message #676966] Sun, 04 August 2019 04:26 Go to previous message
rahulvishwakarma
Messages: 11
Registered: April 2014
Junior Member
mine emctl --version is :-

[oracle@serverora11gr2 Desktop]# emctl --version
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
Previous Topic: OEM Notifications only
Next Topic: EM Daemon is not running.
Goto Forum:
  


Current Time: Sat Nov 28 10:57:43 CST 2020