Trigger whoever logged in sqlplus through UNIX

Tags

shell scripts

Top Forums Shell Programming and Scripting Trigger whoever logged in sqlplus through UNIX

07-15-2009

Registered User

29, 0

Join Date: Jul 2009

Last Activity: 9 January 2013, 2:20 PM EST

Posts: 29

Thanks Given: 0

Thanked 0 Times in 0 Posts

Trigger whoever logged in sqlplus through UNIX

We had a requirement like we should find the user whoever logged into sqlplus through UNIX automatically.

For that we should write a script and store the result in file.

we will get that user manually by using WHO command.

can anybody help me how to trigger?

I tried many commands beyond WHO i.e. netstat, ifconfig.

siri_886

View Public Profile for siri_886

Find all posts by siri_886

07-15-2009

Registered User

286, 3

Join Date: Jul 2009

Last Activity: 25 July 2019, 8:01 AM EDT

Posts: 286

Thanks Given: 16

Thanked 3 Times in 3 Posts

in solaris, i use "w" it shows what user is executing in the system

ryandegreat25

View Public Profile for ryandegreat25

Find all posts by ryandegreat25

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Sqlplus variable UNIX

hi guys i have a sqlplus : sqlplus -s username/password << EOF @mysql.sql EOF in mysql.sql there is a count of a table, i want to write in a variabile unix. how can i do? Thanks a lot Regards Francesco.

2. Shell Programming and Scripting

Reading value from sqlplus in UNIX

I have a unix shell script that calls two Select Queries using sqlplus as shown below. more extract.sh result=$(sqlplus -s usr/swd@myhost_sid @/tmp/SELECT_QUERY.run) more @/tmp/SELECT_QUERY.run SELECT PROBLEM_TYPE, COUNT (*) FROM BATCH WHERE UPPER (STATUS) = 'NEW' AND PROB_TYPE...

3. Shell Programming and Scripting

Trigger functionality in Unix

Hi, I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening., Below is...

4. Shell Programming and Scripting

Source trigger in Unix shell

Hi All, Is ther any way to write the script with source trigger ? To trigger the script on particular time we have crontab. Similarly in a path, when a file comes particular script has to run. Thanks:)

5. Shell Programming and Scripting

Update trigger for unix file (solaris)

Hello, from log error file of process that i's updating in append mode, i need to capture the new entries for every day. How i can know and save only the new errors? This it's a sample of error log file (oas report server engine) thanks and regards Fran

6. UNIX for Dummies Questions & Answers

SQLPLUS in unix

HI Guys, i just want ask the steps when trying to create a simple SQL select statement in linux. I know how to use the select statement in SQLplus, but im having a difficult time in having a unix script connect direct to SQL plus and then retrieve the selected statement. example....

7. UNIX for Dummies Questions & Answers

connect sqlplus from unix

hi, I have this basic query. I have created a new user on unix. I have given home directory and permission through chmod to create directory stucture. Now need to connect sqlplus. What permissions should we give, so that this works? Any help is appreciated. Thanks, Neha

8. Shell Programming and Scripting

Need example program for sqlplus in Unix

Hi I am new to unix .I need a example program to connect oracle10g DB from shell script.The task is to connect sql from shellscript and to write a query inside to retieve some fiels.The reseult should be stored in a seperate .dat file(by using spool). Thanks Bala.

9. UNIX for Dummies Questions & Answers

How to send a trigger file from Unix to Windows

I need to send a file from a Unix box to a Windows sever to kick off a Crystal Reports job. Any good ideas how to do this? Can it be done with FTP?

Shell Programming and Scripting