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
FS_NEWCELL(1)						       AFS Command Reference						     FS_NEWCELL(1)

NAME
       fs_newcell - Changes the kernel-resident list of a cell's database servers

SYNOPSIS
       fs newcell -name <cell name> -servers <primary servers>+
	   [-linkedcell <linked cell name>] [-help]

       fs n -n <cell name> -s <primary servers>+
	   [-l <linked cell name>] [-h]

DESCRIPTION
       The fs newcell command removes the Cache Manager's kernel-resident list of database server machines for the cell specified by the -name
       argument and replaces it with the database server machines named by the -servers argument.

       Each time the machine reboots, the Cache Manager constructs the kernel list of cells and database server machines by reading the local
       /etc/openafs/CellServDB file. This command does not change the CellServDB file, so any changes made with it persist only until the next
       reboot, unless the issuer also edits the file. The output of the fs listcells command reflects changes made with this command, because that
       command consults the kernel-resident list rather than the CellServDB file.

       This command can introduce a completely new cell into the kernel-resident list, but cannot make a cell inaccessible (it is not possible to
       remove a cell's entry from the kernel-resident list by providing no values for the -server argument). To make a cell inaccessible, remove
       its entry from the CellServDB file and reboot the machine.

       If the -name argument names a DCE cell, then the -servers argument names DFS Fileset Location (FL) Server machines. The -linkedcell
       argument specifies the name of the AFS cell to link to a DCE cell for the purpose of DFS fileset location.

CAUTIONS
       Some commands, such as the aklog or klog.krb5 commands, work correctly only when the information is accurate for a cell in both the
       CellServDB file and the kernel-resident list.

OPTIONS
       -name <cell name>
	   Specifies the fully-qualified cell name of the AFS or DCE cell.

       -servers <primary servers>+
	   Specifies the fully-qualified hostnames of all AFS database server machines or DFS Fileset Location (FL) Server machines for the cell
	   named by the -name argument. If FL Server machines are specified, the local machine must be running the AFS/DFS Migration Toolkit
	   Protocol Translator.

       -linkedcell <linked cell name>
	   Specifies the name of the AFS cell to link to a DCE cell for the purpose of DFS fileset location.

       -help
	   Prints the online help for this command. All other valid options are ignored.

EXAMPLES
       The following example changes the machine's kernel-resident list of database server machines for the ABC Corporation cell to include the
       machines "db1.abc.com" and "db2.abc.com":

	  % fs newcell -name abc.com -servers db1.abc.com db2.abc.com

       The following example links the DCE cell "dce.abc.com" to the AFS cell "abc.com". The AFS client contacts the Fileset Location (FL) servers
       "db1.dce.abc.com" and "db2.dce.abc.com" for fileset location information as it interprets a DFS pathname.

	  % fs newcell -name dce.abc.com 
	      -servers db1.dce.abc.com db2.dce.abc.com 
	      -linkedcell abc.com

PRIVILEGE REQUIRED
       The issuer must be logged in as the local superuser root.

SEE ALSO
       CellServDB(5), fs_listcells(1)

COPYRIGHT
       IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.

       This documentation is covered by the IBM Public License Version 1.0.  It was converted from HTML to POD by software written by Chas
       Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.

OpenAFS 							    2012-03-26							     FS_NEWCELL(1)
All times are GMT -4. The time now is 01:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy