404 not found even sqlplus client connect to finelly with oracle server

  1. rahulvishwakarma

    rahulvishwakarma Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    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 andcan run the sql queries only em is down. I also did this :-
    Code (SQL):
    [oracle@serverora11gr2 Desktop]$ lsnrctl stop

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

    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]$ su
    Password:
    [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
    [root@serverora11gr2 Desktop]#
     
    after that :-
    Code (SQL):
    [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.

    [root@serverora11gr2 Desktop]#
     
    how to up OEM?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,691
    Likes Received:
    376
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You do realize that Oracle products are not supported on CentOS? You may get them to work but if you have issues Oracle support won't be of any help.

    I also notice that you are making these attempts as 'root', which won't work as the Oracle environment is NOT set for the 'root' account. You MUST be logged in as 'oracle' to attempt starting OEM. All of this is explained in the release notes for OEM. You should read those before going any further.