How to find User disconnection root cause at particular time.?


 
Thread Tools Search this Thread
Operating Systems Solaris How to find User disconnection root cause at particular time.?
# 1  
Old 12-13-2013
How to find User disconnection root cause at particular time.?

Hi Guys,

I need to find out User disconnection cause at particualr time 08:50:49 CET . from various site(Location) on one Server.

My Server is :- Solaris 10 64BIt Sparc.

below is only log I found at /var/adm/message
Code:
I er started by mfg on batch. (4281)
Dec 12 08:47:49 server68 login: [ID 376080 auth.crit] change password failure: Authentication token manipulation error
Dec 12 08:50:52 localhost loganalyzer[27624]: Th0850: _u02_db_eB2_196_prod_mfgprod.lg: ALERT: (Incorrect MFG session ending) 08:50:49 Usr 27: Begin transactio
n backout. (2252)
Dec 12 08:52:56 localhost loganalyzer[27624]: Th0852: _u02_db_eB2_196_prod_mfgprod.lg: ALERT: (Incorrect MFG session ending) 08:52:55 Usr 27: Begin transactio
n backout. (2252)
Dec 12 09:20:50 localhost loganalyzer[26777]: Th0920: _u01_mfg_eB2_SP6_qad_qps_logs_255prodQPS_manexport.log: ALERT: (MFG CRIT-MAIL SERVER68 QPS error #5772
) ERROR: MESSAGE_# 5772.
Dec 12 09:20:52 localhost loganalyzer[26777]: Th0920: _u01_mfg_eB2_SP6_qad_qps_logs_255prodQPS_manexport.log: ALERT: (MFG CRIT-SYSTEM) X-NODEREF or X-DOCUMENT
LOAD got an error: FATAL ERROR: file 'MEMPTR', line '1', column '1', message 'Invalid document structure'. (9082)
-bash-3.2$

The Users were able to login to Server but after that the second login page to databse did not appear.


So,

How do I check oad on the Server for particular time? I did use sar -u which showed:-

Code:
       %usr    %sys    %wio   %idle
08:00:00      12       3       0      85
08:05:00      19       6       0      75
08:10:00      15       4       0      81
08:15:00      16       6       0      78
08:20:00      19       6       0      74
08:25:00      16       5       0      79
08:30:00      17       4       0      79
08:35:01      26       7       0      67
08:40:00      24       4       0      72
08:45:00      12       3       0      84
08:50:00       8       2       0      90
08:55:00      18       9       0      74
09:00:00      16       5       0      79

Where can I check the databse logs on Solaris 10?

Please Guide.

Thanks.
# 2  
Old 12-14-2013
You have tried pretty much what there is. Disconnects usually happen because of:
1. hardware errors - you appear have none
2. network errors -
3. code / users that do bad / stupid things or are configured wrong <-- I vote for this.

If it is just one one user, #3 is the likely issue. If it is several users working in the same department, try the problem code scenario. In other words, invoke script in those users .profile in order to log sessions. Then see what they were doing when things went South.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Wrong time zone for non root user

I have a Solaris-11 zone, which is newely build. Since I am in PST time zone, so I set it with this command. It shows me date correctly with correct time zone, but when I switch it to a non root user and run below java command, it is not showing correct time zone. Not sure, how to set it.... (2 Replies)
Discussion started by: solaris_1977
2 Replies

2. Shell Programming and Scripting

what would a script include to find CPU's %system time high and user time high?

Hi , I am trying to :wall: my head while scripting ..I am really new to this stuff , never did it before :( . how to find cpu's system high time and user time high in a script?? thanks , help would be appreciated ! :) (9 Replies)
Discussion started by: sushwey
9 Replies

3. UNIX for Dummies Questions & Answers

Sudo to delegate permission from non-root user to another non-root user

I've been through many threads before i decide to create a separate thread. I can't really find the solution to my (simple) problem. Here's what I'm trying to achieve: As "canar" user I want to run a command, let's say "/opt/ocaml/bin/ocaml" as "duck" user. The only to achieve this is to... (1 Reply)
Discussion started by: canar
1 Replies

4. AIX

find command to list all the 777 files and directories owned by root user

Hi I'm logged in to an AIX box now and we need to do an audit on this box. cbssapr01:# pwd / Which command will show all the files and directories owned by root user with permissions as 777 ? (8 Replies)
Discussion started by: newtoaixos
8 Replies

5. Red Hat

I want to know the disconnection time of my broadband tcp/ip connection.

Hello, I want to know the disconnection time of my broadband tcp/ip connection as it got disconnected while downloading data. I use Vuze bit torrent client and JDownloader . I use broadband internet connection and my os is slack 11. The problem I have been facing for last 2/3 days that my... (1 Reply)
Discussion started by: vectrum
1 Replies

6. UNIX for Dummies Questions & Answers

How to allow access to some commands having root privleges to be run bu non root user

hi i am new to unix and i have abig task. i have to \run particular commands having root privileges from a non root user. i know sudo is one of the way but i need sum other approach kindly help Thanks (5 Replies)
Discussion started by: suryashikha
5 Replies

7. UNIX for Advanced & Expert Users

To find idle time of a user

Hi All I need to find the idle time of a user... but my OS seems to be not supporting finger $ finger -sh: finger: command not found I need to find the idle time and perform some other operations... So is there any other way i can find the idle time of a user... $ uname -a... (2 Replies)
Discussion started by: Whiteboard
2 Replies

8. UNIX for Advanced & Expert Users

How to find the time a filesystem was mounted without using root privileges

Hi, Im running RHEL. How do I find the time a particular filesystem was mounted? Please Let me know Thanks (1 Reply)
Discussion started by: neuralninja
1 Replies

9. Filesystems, Disks and Memory

How to find the time a filesystem was mounted without using root privileges

Hi, Im running RHEL. How do I find the time a particular filesystem was mounted? Please Let me know Thanks (1 Reply)
Discussion started by: neuralninja
1 Replies

10. Shell Programming and Scripting

Shell script to find when user su'ed to root

Does anybody know how to make a shell script that finds all the times that any user su'ed to root and create a cron job sends that file output via e-mail to one user? Thanks!:confused: (1 Reply)
Discussion started by: jrvilino
1 Replies
Login or Register to Ask a Question