Saturday, 19 December 2015

My Thoughts

99% of people are fearfull of peer pressure and with the simple statement of
"What other people would say", this is the biggest hindrance to every one in the world.
And other 1% who doesn't follow this becomes uniquely different and other 99% people follow them.


When we look others with conflicting nature we feel bad inside,
But when we praise other we feel happy inside.

----------------
Few People play politics of INNOCENCE, by claiming they have nothing to do with your issue and would treat them as culprit of others action.

---------------
 

Tuesday, 15 September 2015

Print jobs stuck in oracle apps due to - lp: Too many active jobs

-----Outfile of the request shows this----
Printing output file.
               Request ID : <requestid>  
         Number of copies : 1    
                  Printer : <printername>

lp: Too many active jobs.
Pasta: Error: Print failed. Command=lp -c -<printername>  </outfilepath/o34252997.out>
Pasta: Error: Check printCommand/ntPrintCommand in pasta.cfg
Pasta: Error: Preprocess or Print command failed!!!
APP-FND-00500: AFPPRN received a return code of failure from routine FDUPRN. Program exited with status 1

Cause: AFPPRN received a return code of failure from the OSD routine FDUPRN. Program exited with status 1.

Action: Review your concurrent request log file for more detailed information.
------------

Solution :
Using root user , check the log file /var/log/cups/access_log
One print queue was having backlog of hundreds of print jobs , disable and enable print queue.
/usr/sbin/cupsenable <printer_name>
Verify it using
#lpstat -a printername
printername accepting requests since Fri 11 Sep 2015 03:13:13 PM PDT

To check the queue
lpstat -o printername
--------------
To manage it using non-root user , verify whether user in groups





#groups  (would show the groups that your user is in)
To see if lpadmin is listed. If not:
sudo adduser <your-user-name> lpadmin

Then, to gain access to the new group without logging out and logging in again:
newgrp lpadmin

==>To check queue use
lpq -P printername
==>To cancel the jobs
If you have a list of duplicate pending jobs, be sure to delete the duplicates to avoid having your print job come out multiple times.To delete a queued job, type the following (n should be the number in the Job column of the lpq output):

cancel <n>
-----
After you have deleted duplicate jobs, try enabling it

/usr/sbin/cupsenable printername

----Extra-------
/usr/bin/enable (Printer Name)
service cups restart
service cups stop
service cups start





Tuesday, 23 June 2015

R12-MWA services starting giving PortNumber: 10356 is not free to start the server

Error starting mwa services
---------
Starting MWA Wrapper script.  Checking if all ports are free to start the servers and dispatcher...
PortNumber: 10356  is not free to start the server. Please specify a different port in the configuration file (or) end the process using this port
PortNumber: 10358  is not free to start the server. Please specify a different port in the configuration file (or) end the process using this port
PortNumber: 10360  is not free to start the server. Please specify a different port in the configuration file (or) end the process using this port
PortNumber: 10878  is not free to start the dispatcher. Please specify a different port in the configuration file (or) end the process using this port
----------


Solution : 
Use higher range of ports for the same.

found lots of FNDLIBR processess being used by the ports and conflicting it with the ports defined in $INST_TOP/admin/install/mwa.cfg

Updated below ports range and started the services and all working fine now.
Define in $INST_TOP/admin/install/mwa.cfg and also change in $CONTEXT_FILE

mwa.TelnetPortNumber=32503,32565,32635
mwa.Dispatcher=evtdev08.danahertm.com:32500
mwa.TelnetServer

References:

Importance of TCP/UDP Parameters in 11gR2 (Doc ID 1307804.1)

Port Conflicts In EBS - Address already in use (Doc ID 1940314.1)


How to find out the processess being used by port.
netstat -nape |grep 10358
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 129.196.132.233:24438       129.196.132.232:1550        ESTABLISHED 3737       911035884  19876/FNDLIBR
tcp        0      0 129.196.132.233:24436       129.196.132.232:1550        ESTABLISHED 3737       911035871  19874/FNDLIBR
tcp        0      0 129.196.132.233:24437       129.196.132.232:1550        ESTABLISHED 3737       911035878  19875/FNDLIBR
tcp        0      0 129.196.132.233:24434       129.196.132.232:1550        ESTABLISHED 3737       911035857  19869/FNDLIBR
tcp        0      0 129.196.132.233:24435       129.196.132.232:1550        ESTABLISHED 3737       911035865  19873/FNDLIBR
tcp        0      0 129.196.132.233:24432       129.196.132.232:1550        ESTABLISHED 3737       911035845  19867/FNDLIBR
tcp        0      0 129.196.132.233:24440       129.196.132.232:1550        ESTABLISHED 3737       911035897  19879/FNDLIBR
tcp        0      0 129.196.132.233:24430       129.196.132.232:1550        ESTABLISHED 3737       911035833  19865/FNDLIBR
tcp        0      0 129.196.132.233:24431       129.196.132.232:1550        ESTABLISHED 3737       911035839  19866/FNDLIBR
tcp        0      0 129.196.132.233:24429       129.196.132.232:1550        ESTABLISHED 3737       911035827  19864/FNDLIBR
udp        0      0 127.0.0.1:11790             0.0.0.0:*                               3737       911035894  19879/FNDLIBR
udp        0      0 127.0.0.1:62999             0.0.0.0:*                               3737       911035842  19867/FNDLIBR
udp        0      0 127.0.0.1:10649             0.0.0.0:*                               3737       911035824  19864/FNDLIBR
udp        0      0 127.0.0.1:54051             0.0.0.0:*                               3737       911035881  19876/FNDLIBR

Thanks
Vijay

Wednesday, 8 April 2015

Enabling Internet access in OEL 6.4 64 bit

Issue : After installing OEL 6.4 , Internet was not working.

Solution :

Goto System-> Preferences -> Network Connections
Under Wired
                  -> System eth0  (Edit)
Make sure below are checked.
 -> Connect   automatically
-> Available ti all users

Under Tab - Wired (you will see the Device MAC address , Nothing in Cloned MAC address)
MTU would be set by default as automatic (bytes).

 Under Tab - 802.1X Security - Nothing is checked.

Under Tab - IPv4 Settings :
Addess : <Machine-IP>   , Netmask: <IP> , Gateway- <IP>
In DNS Servers - <DNSIP>  , Nothing in Search domains.
Check - Require IPv4 addressing for this connection to complete.
Nothing on Routes button details.

Under Tab - IPv6 Settings  , Method - Ignore

After addind DNS Servers, restart the network services from root user.
You can verify the settings in /etc/resolv.conf file
----------
# Generated by NetworkManager
search vijoraapps.com
nameserver <Above DNS IP>
----------
Also you can verify the entry in /etc/sysconfig/network-scripts/ifcfg-eth0
You will see dns entry now, like.
DNS1=<DNSIP>

$service network restart

And test the internet.

You can ping 4.4.4.4 ( to check network connectivity)
or ping 8.8.8.8  

Other commands:
ifconfig
setup
system-config-network

1.#ifconfig
2.#vim/etc/sysconfig/network-scripts/ifcfg-eth0
3.#vim /etc/resolv.conf

Refences :
http://docs.oracle.com/cd/E37670_01/E41138/html/ol_about_netconf.html

Monday, 6 April 2015

R1213 SSO-OID-LDAP Error oame OAMSSA-20027 Could not get user : username, idstore: EBSIdStore == oam_server1.log

Error ==>

<Mar 17, 2015 5:47:20 AM PDT> <Error> <oracle.oam.user.identity.provider> <OAMSSA-20027> <Could not get user : ledefall, idstore: EBSIdStore, with exception: oracle.security.idm.OperationFailureException: javax.naming.NamingException: LDAP response read timed out, timeout used:2000ms.; remaining name 'cn=adusers,cn=users,dc=vijoraapps,dc=com'.>

Solution :

Collected data using
1) Collect data using - >  oiddiag collect_all=true
2) All OID logs from the time of the Timeout errors
(Oracle_Instance/diagnostics/logs/OID/oid1 or instance name)

OID1 instance you have the following default attributes set:
3000 : orclmaxcc=4
3000 : orclserverprocs=1

Reference Doc: http://docs.oracle.com/cd/E28280_01/core.1111/e10108/oid.htm#ASPER99273
Check out the section labeled "23.3.2 LDAP Server Attributes"
http://docs.oracle.com/cd/E28280_01/core.1111/e10108/oid.htm#ASPER99964

You will notice the chart where orclserverprocs and orclmaxcc is mentioned
For orclserverprocs the recommendation is :orclserverprocs Number of CPU cores
and for orclmaxcc, the recommendation is 10

Another suggestion would be the tuning wizard documented here:
http://docs.oracle.com/cd/E28280_01/core.1111/e10108/oid.htm#ASPER106

Also refer:  OID Performance Tuning Checklist (Doc ID 458703.1)

Thanks
Vijay

Tuesday, 3 March 2015

R12 User login Error while assigning Customer to the user - APP-FND-02913



Issue :  You get above pop up once you try to assign CUSTOMER in the user form.

Solution : You can assign the CUSTOMER field as below also from backend, which has resolved the issue, but issue may vary in different environments. This is just for information.

exec fnd_user_pkg.UPDATEUSER(x_user_name=>'USER_NAME',x_owner=>null,X_CUSTOMER_ID=>CUSTOMER_ID_ASINPOPOP);

Can also follow How to End-Date/Delete an Applications User (Doc ID 1064798.1)

SQL Shared Area - BIND MISMATCH