Sponsored Content
Top Forums UNIX for Advanced & Expert Users Question related to UNIX and Oracle DB Post 302865723 by solaris_1977 on Saturday 19th of October 2013 01:13:11 PM
Old 10-19-2013
Question related to UNIX and Oracle DB

I have one application server, which is Solaris non global zone (dsapid02-dt3d02 - 10.63.76.96) and a database server, which is Linux (db1-serv26 - 10.63.36.117 & 10.63.36.118).
Whenever database admin is starting listener, it starts filling listener log file. Within minutes, it will make file in gigabytes.
Scenerio - There were 5 databases running on db1-serv26. One of the database, T3IA was using port 1558. A month back all those 5 databases were migrated to another server and all file-systems on db1-serv26 were removed after that, so no listener was listening on 1558 and other ports used by T3 QA databases on db1-serv26.
Now there is a new requirement of creation of new database on db1-serv26, which should use port 1558. The moment database administrator configure 1558 port, a number of processes from IP 10.63.76.96 (dsapid02-dt3d02) from different ports (59881, 59882, 59883, 59884, 59885, 59886, etc) started trying to connect to T3IA database on db1-serv26 on port 1558. As 1558 is now being used by newely created database, and not by T3IA, the connections were not successful, and hence started generating following errors in large number
Code:
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
18-OCT-2013 22:32:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=T3IA.tms.toyota.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.63.76.96)(PORT=39372)) * establish * T3IA.tms.toyota.com * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
18-OCT-2013 22:32:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=T3IA.tms.toyota.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.63.76.96)(PORT=39385)) * establish * T3IA.tms.toyota.com * 12514

On Solaris box (dsapid02-dt3d02) -->
Code:
root@dsapid02-dt3d02:/# netstat -an | grep 1558| grep ESTA | wc -l
      24
root@dsapid02-dt3d02:/# netstat -an | grep 1558| grep CLOSE_WAIT | wc -l
     816
root@dsapid02-dt3d02:/# netstat -an | grep 1558| grep CLOSE_WAIT | head
10.63.76.96.44310    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.45893    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.62334    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.49056    10.63.36.117.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.63381    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.38431    10.63.36.117.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.54637    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.53052    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.48458    10.63.36.118.1558     6912      0 131768      0 CLOSE_WAIT
10.63.76.96.56239    10.63.36.117.1558     6912      0 131768      0 CLOSE_WAIT
root@dsapid02-dt3d02:/#

Can somebody help me to find this issue, where I need to hit ?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

A Question related to the net

well, I was suggested to remove the contents of the cache as i get out of the browser netscape from the .netscape folder. is that really necessary? if so what are the rest to be done? can anybody please tell me?:rolleyes: (8 Replies)
Discussion started by: sskb
8 Replies

2. UNIX for Dummies Questions & Answers

Question related to Emailing from UNIX

Hi All, I would like to write a script which sends an email to clients. mailx -s "TEST" $EMAIL_RECIPIENTS < FILE ...will send an email to EMAIL_RECIPIENTS with TEST as the subject and FILE as the body. Now I have a another CONTROL_FILE which is constant all the times (FILE in the above... (1 Reply)
Discussion started by: jingi1234
1 Replies

3. UNIX for Dummies Questions & Answers

oracle related

Plz. help me for returning set of values from oracle to unix array? (1 Reply)
Discussion started by: harsh_kats
1 Replies

4. UNIX for Advanced & Expert Users

One Question related to alias

Hello, I have created following alias in csh lab 'rlogin -l user23 complab23' but problem is complab23 does not allow automatic login by checking .rhosts file. So after typing lab on command line I have to type complicate password and if wrong password is typed thrice then account gets... (4 Replies)
Discussion started by: neerajrathi2
4 Replies

5. UNIX for Advanced & Expert Users

DOS messaging question - related to UNIX process problem

Hi, This is a strange request. I know there is some sort of crude DOS tool that allows you to communicate to another PC either using its IP adress or PC name. But I can't remember where aor what its called, any ideas? Reason for asking here, Someone has telnet'd on a UNIX server I have... (0 Replies)
Discussion started by: nhatch
0 Replies

6. Solaris

RBAC related question.....

I am referring Bill Calkins(SCSA exam prep) for RBAC..actually i wanted to make a normal user to get the privilege to run a command through authorization, not through profile files... This is the exact steps given by Bill calkins.. 1.roleadd -m -d /export/home/adminusr -c... (11 Replies)
Discussion started by: saagar
11 Replies

7. Shell Programming and Scripting

having df command related question

Hi All, When i have run the below command its showing 90% which is critical for production. for this i need the answer of some below question please help me for that. 1) i want to delete some unwanted files. how can i know the unwanted files ?Is it there any way of knowing this?? 2)and... (2 Replies)
Discussion started by: aish11
2 Replies

8. Shell Programming and Scripting

awk related question

awk "/^<Mar 31, 2012 : /,0" /app/blah.log can someone please help me figure out why the above command isn't pulling anything out from the log? basically, i want it to pull out all records, from the very first line that starts with the date "Mar 31, 2012" and that also has a time immediately... (4 Replies)
Discussion started by: SkySmart
4 Replies

9. Shell Programming and Scripting

need downloading related help...but its not related to unix

Hi All, I am trying to dowmload the zip file "zkManageCustomers.zip " but i dont have access. Can anyone help me to download this file See the below link- http://www.ibm.com/developerworks/opensource/library/wa-aj-open/index.html?ca=drs- Please help me as early as... (1 Reply)
Discussion started by: aish11
1 Replies

10. UNIX for Dummies Questions & Answers

Question related to 'ps'

If I run a script called 'abc.sh' and then execute the following : ps -ef | grep 'abc.sh' I always get two rows of output, one for the executing script, and the other for the grep command that I have triggered after the pipe. Questions: Why does the second row turn up in the results. My... (10 Replies)
Discussion started by: jawsnnn
10 Replies
MONGO(1)							  Mongo Database							  MONGO(1)

NAME
mongo - the Mongo command-line tool SYNOPSIS
mongo [OPTIONS] [DB_ADDRESS] [FILE+] DESCRIPTION
mongo is a JavaScript shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively, JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey. Database output is dis- played in JSON format. If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting. EXAMPLES
mongo start the shell, connecting to the server at localhost:27017 and using the test database mongo foo start the shell using the foo database at localhost:27017 mongo 192.169.0.5/foo start the shell using the foo database at 192.169.0.5:27017 mongo 192.169.0.5:9999/foo start the shell using the foo database at 192.169.0.5:9999 mongo script1.js script2.js script3.js run three scripts and exit OPTIONS
--shell run the shell after executing files --help show usage information --host HOST server to connect to (default HOST=localhost) --port PORT port to connect to (default PORT=27017) --nodb do not connect to mongod --eval SCRIPT evaluate JavaScript -u USERNAME specify user to log in as -pPASSWORD specify password of user (notice there is no space) COPYRIGHT
Copyright 2007-2009 10gen SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org. AUTHOR
Kristina Chodorow 10gen June 2009 MONGO(1)
All times are GMT -4. The time now is 11:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy