SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Connection Error
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Connection Error
Author Message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Connection Error Reply with quote
When I configure the alert function, suggesting I set up the alert center connection to the database, it always prompts
"The Alert Center is unable to connect to the database with the specified parameters."
However, in "scheduler.log" shows:
08/13/2009 05:02:21 ?? 2 null null Alert Center Scheduler User DB Audit connected from 192.168.1.202
08/13/2009 05:02:53 ?? 2 null null Alert Center Scheduler User system connected from 127.0.0.1
08/13/2009 05:02:53 ?? 2 null null Alert Center Scheduler Test #6309891 results: Database connection succeeded.
08/13/2009 05:02:53 ?? 2 null null Alert Center Scheduler User system disconnected
Fri Aug 14, 2009 3:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
At least 2 connections are required - one for the repository database server and 1 or more for audited database servers. If you deal with a single database server, which is being audited and at the same time is used as a repository, both connections point to the same server. The log indicates only one successful connection. Please attach a screenshot or describe what you are entering for the connection parameters. You can mask user names and passwords, this is not important, I'm more concerned about the selected connection driver/method and the connection string format.
Fri Aug 14, 2009 8:23 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
Screenshots can not upload, can you give me a email address?
Tue Aug 18, 2009 3:32 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
Audited database SID: DBAUDIT, at 192.168.1.202,
OS: linux;

listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DBAUDIT)
(ORACLE_HOME = / oracle/product/10.1.0)
(SID_NAME = DBAUDIT)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.202) (PORT = 1521))
)
)
)

DB Audit expert, alert center is located at 192.168.1.52,
OS: windows xp

tnsnames.ora:
DBAUDIT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.202) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBAUDIT)
)
)

Sqlplus and use DB Audit expert successfully connect the database.
However, the database set up alert, the prompt "New Database Connection Required", enter the parameters as follows:

Connection interface:
Direct connection
Enter JDBC driver class:
oracle.jdbc.driver.OracleDriver (default, can not be changed)
Enter JDBC driver file path:
./drivers/ora/ojdbc14_g.jar (default, can not be changed)
Enter database server URL ...:
jdbc:oracle:thin:@192.168.1.202:1521:DBAUDIT
Login user:
system


Always prompted as follows:

The Alert Center is unable to connect to the database with the specified parameters. Please correct the connection parameters and try again.
Tue Aug 18, 2009 4:41 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
jdbc:oracle:thin:@192.168.1.202:1521:DBAUDIT
This looks ok. The interface settings also look ok


I suggest 2 things - check if you have SQLNET.ORA, TNSNET.ORA or similar .ORA files in the Alert Center directory and subdirectories. If you find such files, open them in the Notepad, specific connection related errors should be reported in these files. They may help to identify the root cause of the problem and correct it.

If none of the above helps, please setup an ODBC connection for your Oracle database. When the Deployment Wizard or Alert Center Wizard in DB Audit Management Console prompt you for the repository connection, click ODBC option and then use [...] button to select the ODBC profile name.


Please let us know if this helps.
Tue Aug 18, 2009 9:01 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
"listener.log" in the database server (192.168.1.202) as follows:

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 19-AUG-2009 11:50:26

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

System parameter file is /oracle/product/10.1.0/network/admin/listener.ora
Log messages written to /oracle/product/10.1.0/network/log/listener.log
Trace information written to /oracle/product/10.1.0/network/trace/listener.trc
Trace level is currently 0

Started with pid=1274
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
19-AUG-2009 11:53:36 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=computech)(USER=sange))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
19-AUG-2009 11:57:09 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\Program Files\DB Audit 4\DB_AUDIT.EXE)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=1302)) * establish * DBAUDIT * 0
19-AUG-2009 11:57:52 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=sqlplus)(HOST=computech)(USER=sange))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=32829)) * establish * DBAUDIT * 0
19-AUG-2009 11:58:04 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=sqlplus)(HOST=computech)(USER=sange))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=32833)) * establish * DBAUDIT * 0
19-AUG-2009 11:58:12 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=sqlplus)(HOST=computech)(USER=sange))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=32834)) * establish * DBAUDIT * 0
19-AUG-2009 11:59:23 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\Program Files\DB Audit 4\DB_AUDIT.EXE)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=1457)) * establish * DBAUDIT * 0
19-AUG-2009 12:00:00 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\PROGRAM FILES\DB AUDIT 4\db_audit.exe)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=1496)) * establish * DBAUDIT * 0
19-AUG-2009 12:00:17 * (CONNECT_DATA=(SID=DBAUDIT)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=1512)) * establish * DBAUDIT * 0
19-AUG-2009 12:03:48 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\PROGRAM FILES\DB AUDIT 4\db_audit.exe)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=1715)) * establish * DBAUDIT * 0
19-AUG-2009 12:04:04 * (CONNECT_DATA=(SID=DBAUDIT)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=1732)) * establish * DBAUDIT * 0


****** The following is a record of the database connection when entering the DB Audit expert: ******
19-AUG-2009 12:39:04 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\Program Files\DB Audit 4\DB_AUDIT.EXE)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=3972)) * establish * DBAUDIT * 0


****** The following records should be a connection test, in the "New Database Connection Required ":******
19-AUG-2009 12:39:29 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\PROGRAM FILES\DB AUDIT 4\db_audit.exe)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=3993)) * establish * DBAUDIT * 0
19-AUG-2009 12:39:43 * (CONNECT_DATA=(SID=DBAUDIT)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=4007)) * establish * DBAUDIT * 0


****** The following records should be using ODBC to connect: ******
19-AUG-2009 12:41:50 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\PROGRAM FILES\DB AUDIT 4\db_audit.exe)(HOST=SANGE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=4118)) * establish * DBAUDIT * 0
19-AUG-2009 12:41:59 * (CONNECT_DATA=(SERVICE_NAME=DBAUDIT)(CID=(PROGRAM=C:\PROGRA~1\Java\j2re1.4.2_19\bin\java.exe)(HOST=SANGE)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.52)(PORT=4127)) * establish * DBAUDIT * 0

Use ODBC to connect to the same error;


Is it the Chinese environmental impact of the DB Audit?

Also, please tell me the detailed steps for the deployment of DB Audit.
Wed Aug 19, 2009 1:38 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Your LISTENER.ORA file indicates successful connections from both DB Audit Management Console and from the Alert Center. The Chinese environmental should be ok too. It must be then something else that is causing the issue, the process breaks in some other place, but from DB Audit Management Console point of view it fails while setting up new connection, which leads to misleading error message.

Here is what I suggest to try. Please configure manually 2 database connections in the Alert Center. Start the Alert Center scheduler GUI by using master.bat file, if it is not already running. Click Tools/Database Profiles menu. Select Oracle item and click the New button. Name the new profile exactly as it is named in the DB Audit GUI. For the connection parameters enter jdbc:oracle:thin:@192.168.1.202:1521:DBAUDIT user SYSTEM and password for that user. Click Test to test it and if ok, close the dialog. Click the New button again and repeat the same steps, but this time name the new connection profile as "Repository Server" without double quotes. After that DB Audit Management Console should be able to find the connections and do not prompt for them again. Hope this will solve the issue and will not create side effects.
Wed Aug 19, 2009 5:32 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
In accordance with your suggest, the previous error is no longer prompted, I can choose to archiving scope and server whose audit trails will be saved in the repository, but in the "center" label, when prompted to "Creating required files and jobs ..." took place Error:

Unable to schedule audit log archiving job for "DBAUDIT"
Alert Center error: Unable to add audit log archiving job for database DBAUDIT. The database connection is not configured yet.

If you skip to the "alert" tab, configure any alert, the following error occurred:

Alert Center error: Unable to add alert monitor .........
The central repository database connection is not configured yet.

In the Alert center, create a new Alert, whether in the Repository Server or directly in the Audited Database Server, have taken place in "class java.lang.OutOfMemoryError" error.

Modify the parameters of jvm in master.bat also does not work.
Thu Aug 20, 2009 4:42 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Ok, the 1 step manual setup for db connection didn't resolve the issue completely. Here are several additional steps you should do to workaround the connection issue.

1. Start Alert Center scheduler in the graphical mode as you did it before.
2. Click File->New->Job Queue menu. Enter name DBAUDIT and click OK
3. Click File->New->Folder menu. Enter name $DATABASE$ DBAUDIT, for the description enter the following exactly as it appears below

Code:
[ Do not modify this folder ] 

DB TYPE: Oracle


4. Click OK.

Now try to use the Repository Deployment tool again. It should not complain about the connection anymore
Thu Aug 20, 2009 7:48 pm View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
As you said, it is no longer an error to add alerts and reports with Repository Deployment tool.

However, if the use of Alert Center Remote Console to set up alerts and reports, and always took place "class java.lang.OutOfMemoryError" error.

If so, some alerts in the Repository Deployment tool could not be set, such as:
Data Changes in Certain Tables;
Access to Certain Tables After Regular Business Hours
And so on ...

How to solve this problem.

Thank you for so patiently.
Fri Aug 21, 2009 5:40 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Where do you see "class java.lang.OutOfMemoryError" error? In the Alert Center log files or on the graphical Alert Center Remote Console? If you see this in some log file, in which one? and what appears above that error line?

Which version of JRE/JDK are you using to run the Alert Center? On the client?
Fri Aug 21, 2009 3:08 pm View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
jdk/jre version 1.4.2_19, Alert Center Server and Client in the same host.

The error was not appear in the log files. In the Alert Center Remote Console, add or modify Alert or Report, pop-up message box displays the error.
Mon Aug 24, 2009 11:20 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
All right. So you get this error in the graphical console.

But when do you get it? When you use the New Alert Wizard? When you run that alert or something else?
Tue Aug 25, 2009 7:58 am View user's profile Send private message
sange



Joined: 14 Aug 2009
Posts: 15
Country: China

Post Reply with quote
When using the New Alert Wizard
Tue Aug 25, 2009 9:59 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Let's try to gather more details. Please enable tracing option in the Alert Center scheduler. To enable this option, click Tools/Options menu in the Alert Center GUI, click Log tab and tick Trace Enabled checkbox, click OK to close Options dialog. In the Alert Center Remote Console reproduce the error (use New Alert Wizard). After that open debug.log file from the Alert Center installation directory and let us know last 10 lines from that file.
Wed Aug 26, 2009 7:19 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.