1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'General' started by rahulvishwakarma, Jul 29, 2019.

  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?