Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

DLP console displays 404 error

Created: 18 Aug 2013 • Updated: 18 Aug 2013 | 51 comments
Sachin Sawant's picture

Hi,

I have installed DLP 11.0 in single tear mode with oracle 11g.

I am facing issue in access to DLP. it show error http status 404.

Operating System platform is Windows Server 2008 R2.

 

I have follow the below steps but not working please help.

First restart all the orcale services and then follow the below steps to stop/start the services in sequential order.

 
As a Second step please Restart the Enforce server services in the following order:
 
Stop the Manager Vontu Services:
1. Vontu Monitor Controller (if applicable)
2. Vontu Incident Persister
3. Vontu Manager
4. Vontu Notifier
5. Vontu Update (if necessary)
 
then start the Manager Vontu Services:
1. Vontu Notifier
2. Vontu Manager
3. Vontu Incident Persister
4. Vontu Monitor Controller (if applicable)
5. Vontu Update (if necessary)
Operating Systems:

Comments 51 CommentsJump to latest comment

Sachin Sawant's picture

Hi Pete_4u2002,

I have checked the tomcat logs but, I don't understanding this log please help me.

Please find attachment of log.

AttachmentSize
localhost.2013-08-19.log_.zip 8.99 KB
pete_4u2002's picture

looks like connectivity issue

caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.vontu.manager.init.WaitDBInit]: Constructor threw exception; nested exception is java.lang.Exception: Database is not accepting connections, or bad Model.properties file.

can you check using command (SQLplus) that you can connect to database.

 

Sachin Sawant's picture

Hi Pete_4u2002,

As per your solution, I have use this command and connect to database successfully.

Please suggest any other solution.

Please find the screen shot of the same. 

 

 

SQL Connect.jpg
pete_4u2002's picture

are you trying to access the console on the DLP installed machine?

Sachin Sawant's picture

Yes, I have try to access the console but same errors are comeing.

 

I had connect to the databas after connecting databas, I have run (describe dba_tablespaces;)command it showing Error.

SQL> describe dba_tablespaces;
ERROR:
ORA-04043: object dba_tablespaces does not exist
pete_4u2002's picture

did you follow the steps as per the installation guide for oracle as well as DLP?

did you have DLP scehma imported?

Sachin Sawant's picture

Hi,

I had installed oracle and DLP successfully dated 26/6/2013 and its working fine.

Today I have try to open my console but it’s not open it’s showing error.

 

Kent Chou's picture

did you try to use the protect account to login on sqlplus command?

Sachin Sawant's picture

Hi kent chou,

 

You can check my second reply?

Kent Chou's picture

Hi Sachin Sawant,

 

i saw some error message on your log, 

like this (19 Aug 2013 09:36:14,622- Error listenerStart)

First, you must be check the listener setting , 

second, did you change the useraccount(protect) password ?

 

R@mj0's picture

Hi Sachin Sawant,

Maybe you need to try to delete the LISTENER and create again.

 

 

Sachin Sawant's picture

Hi kent chou,

 

Thanx for reply, but i m not changing any password.

 

Hi mbuenaobra,

r u shower after creating new LISTENER its working fine.

pete_4u2002's picture

to check listener , ping to verify and it should show connected

$tnsping oracleSID

Kent Chou's picture

You can fouce this issue on your oracle Listener, check the service listener was started?

if no, i suggestion rebuild the listener and try to connect it.

Sachin Sawant's picture

Hi Pete and kent,

 

Thanx for reply I will check tomorrow and reply you.  

Sachin Sawant's picture

Hi Pete,

as per your reply, i had checked it showing error please help wht i do.

C:\Users\Administrator>sqlplus /nolog
 
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 21 10:37:58 2013
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
SQL> Connect sys/protect@protect as sysdba
Connected.
SQL> $tnsping oracleSID
 
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 21-AUG-2
013 10:38:38
 
Copyright (c) 1997, 2010, Oracle.  All rights reserved.
 
Used parameter files:
E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
 
TNS-03505: Failed to resolve name
 
SQL>
 
Sachin Sawant's picture

can you help wht is next action :(

pete_4u2002's picture

ping to oracle sid should show result, if it's not showing, i suggest to work with technical support team.

Sachin Sawant's picture

Hi pete,

 

 thanx for help I will call lock with support.

Sachin Sawant's picture

Hi Mduenobra,

 

As per your article,

I had run following command its come error.

I have case lock with symantec. but if any help pls reply me 

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>
 
nathanmike's picture

@sachin,

generaly error 404 means that the resource in your request (generaly a web page) does not exist.
the first 4 means there is an error in your URL (wrong page or misstype) and the last one means
the resource cannot be found.

what does error log from your web server show ?
are you connecting over http or https?

it sounds like oracle instance is running completely and listener
cannot handle SQL request?

how did you install the whole solution (system, web service, oracle ...)?
did you check listener.ora against hosts file ? DNS ?

Nathan Mike

LPIC-1 and CLA-11

Symantec Registered Partner

nathan.mike@edotcom.be

www.edotcom.be

&

Sachin Sawant's picture

Hi Nathanmike,

I have instilled oracle....
I had try to connecting Https://

it show error http status 404.

nathanmike's picture

@sachin,

if you are running windows 2008, are you using IIS web service ? Apache ? Tomcat ?
if so, can you reproduce the problem and check the error and request logs
from your webserver and paste it ?

was it working before? If so, what has been changed?
can you telnet to your webserver over port 443 and make
some get request?

telnet your.webserver 443

Nathan Mike

LPIC-1 and CLA-11

Symantec Registered Partner

nathan.mike@edotcom.be

www.edotcom.be

&

S_A_M's picture

Hi Sachin ,

Check tnsnames.ora for the correct connection string.

X:\oracle\product\11.2.0.3\db_1\NETWORK\ADMIN
 
Run the following from command prompt and not through sqlplus
 
tnsping protect 
 
lsnrctl status
 
Also, upload the oracle alert_protect logs 
 
NOTE : Single tier installation on production envirnment is not supported by Technical Support you may get a best effort support though.
Sachin Sawant's picture

Hi Sourav M,

please seen the output for command tnsping protect and lsnrctl status.

C:\Users\Administrator>tnsping protect

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-AUG-2
013 16:44:25

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 172.16.2.43)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = protect)))
OK (10 msec)

C:\Users\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-AUG-2013 16:45
:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DLP.immunity.in)(PORT=15
21)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 22-AUG-2013 09:24:06
Uptime 0 days 7 hr. 21 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
Listener Log File e:\app\administrator\diag\tnslsnr\DLP\listener\alert\l
og.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DLP.immunity.in)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
The listener supports no services
The command completed successfully

C:\Users\Administrator>

Sachin Sawant's picture

Hi nathanmike,

my DB running on Windows 2008 R2 and using Tomcat web service

i can telnet on port no. 443

S_A_M's picture

Hello Sachin,

The instance registers with the listener, there is nothing wrong here. Listener is running. Instance is not. When instance starts, it will register itself with the listener and the listener will know about the services supported by that instance.

Try one of the two options :

Option 1 :

Step : 1 (Stop DLP Services)

DLP_STOP.bat

@echo on

net stop "Vontu Update"

net stop "Vontu Monitor Controller"

net stop "Vontu Incident Persister"

net stop "Vontu Manager"

net stop "Vontu Notifier"

@echo off

pause

exit

 

Step : 2

Restart Database Server.

 

Step : 3 (Start DLP Services)

DLP_START.bat

@echo on

net start "Vontu Notifier"

net start "Vontu Manager"

net start "Vontu Incident Persister"

net start "Vontu Monitor Controller"

net start "Vontu Update"

@echo off

pause

exit

 

Option 2 :

Step : 1 ( Stop DLP Services using the script mentioned above )

 

Step : 2

Stop Oracle services :

 

OracleServicePROTECT

OracleOraDb11g_home1TNSListener ( The name may vary as per the environment )

 

Step : 3 : Start Oracle Services, First the "OracleServicePROTECT" and then the listener.

 

Step : 3 ( Start DLP Services using the script mentioned above )

Sachin Sawant's picture

Thanx S_A_M i will run this script and revert back to you....

S_A_M's picture

Sachin,

You do not need to restart the DLP services if you follow option 1 to restart the server. As this is an one tier architecture (database and enforce on the same machine).

 

Sachin Sawant's picture

Hi S_A_M,

My DB and Enforce on the same machine and I restart the server many time but problem is not solved.

R@mj0's picture

hi,

can you try to use netstat |more

and lets see if the port is established for communication bet. DB and Enforce

S_A_M's picture

Sachin , 

Try this: 

Login to sql plus with sysdba

and run the command:

>> shutdown immediate 

and then 

>> startup 

and see if there is any errors .. Please update with any errors you may see..

Sachin Sawant's picture

Hi S_A_M,

seen the error.

SQL> connect sys/protect@protect as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

S_A_M's picture

Here you go .. This is the root cause of this issue .. The database is not open.. How about the "startup" command

Sachin Sawant's picture

Hi,

See the error.

SQL> connect sys/protect@protect as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL>

nathanmike's picture

@sachin,

As long as tour resource (database) is not up and running,
you will never be able to access it from your webserver.

you must consider to review completely from scratch the whole
installation if your DLP environment.

I suggest you to open a case instead if posting few information
about your issue and ask for support with someone that have
expertise in this solution. You will save a lot of time and at the end
solve your problem.

Nathan Mike

LPIC-1 and CLA-11

Symantec Registered Partner

nathan.mike@edotcom.be

www.edotcom.be

&

R@mj0's picture
hi,

can you try this?


select open_mode from v$database;
Sachin Sawant's picture

Hi Nathan Mike,

I already call lock with Symantec but they still collect log... nothing more :)

S_A_M's picture

There is something wrong with the listener.ora (Seems like the "KEY" parameter is incorrect or just tally it with the following ) :

SID_LIST_LISTENER =

  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oracle\product\11.2.0.3\db_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\oracle\product\11.2.0.3\db_1\bin\oraclr11.dll")
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = win-2k8r2ee.test)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = PROTECT))
    )
  )
 
ADR_BASE_LISTENER = C:\oracle
 
SECURE_REGISTER_LISTENER = (IPC)
Sachin Sawant's picture

Hi Mbuenaobra,

pls find the error.

SQL> select open_mode from v$database;
ERROR:
ORA-03114: not connected to ORACLE

But after reboot my server and check again your command its showing following output.

C:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 23 14:22:38 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> connect sys/protect@protect as sysdba
Connected.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL>

S_A_M's picture

Sachin any update on my last comment ???

 

R@mj0's picture

is this solve the problem?

Sachin Sawant's picture

Hi S_A_M,

seen my listener.ora pleas help anything wrong in this file.

# listener.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DLP.immunity.in)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = E:\app\Administrator

S_A_M's picture

1. Stop listener service 

 

2. Change the :

 

 (KEY = EXTPROC1521))

to 

(KEY = PROTECT))

 

3. Restart "oracle service protect"

 

4. Start listener service.

 

Restart the DLP services

Sachin Sawant's picture

Hi S_A_M,

can I delete the listener and create again.

S_A_M's picture

You do not need too .. Its better not to play much with listener ..

If the above doesnot work then you may recreate it.

R@mj0's picture

hi.please check the follwing

-tnsnames.ora

-tnsping status

-check local net service name

-check the prod of OracleMTS services in registry.

-check the environment variables if define.

 

 

R@mj0's picture

Hi,

also got this issue last two days ago. this was an

oracle issue. that the oracle cannot be mount. 

 

can you try this: Please run “lsnrctl status” to check the status of TNS Listener

 

Run “SQLPlus /nolog”

Login to Oracle database as “sys” user

Run “select status from v$instance ;” to check the status of instance

Run “select open_mode from v$database ;” to check the status of Oracle database.