| 404 not found even sqlplus client connect to finelly with oracle server [message #676955] |
Thu, 01 August 2019 07:33  |
 |
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.
[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 #676964 is a reply to message #676956] |
Fri, 02 August 2019 03:35  |
|
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 |
John Watson
Messages: 8960
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
