Tuesday 3 December 2013

Using Different Credentials to Access Shared Folders in Windows7


I connect to a shared folder, entering the userid/password when requested.  I would like to change userid to a different userid and reconnect to the same folder,but when I do the same I found ,it was restricted me to connect by prompting the error message " Login Failure: Unknown User Name or Bad Password",which I have attached just below.



This is a convenience feature that Microsoft has implemented since early versions of Windows. However there may be times when you do not want to log off or restart the computer so that you can use another login to access the shared folder. Although Microsoft did not include a simple button to flush the credentials cache so that you can try a different password, here is how you can do it via a simple command line

To login into the shared folder , you need to enter the valid username and password and most important you have to disconnect all the login into the folder from the same system.

To do so, please follow the below steps.

1. Click START button and choose RUN.
2. Type net use * /delete /yes and hit the Enter key. You will see that it says You have these remote connections, continuing will cancel the connections. The command completed successfully. You will have to wait for a while, probably 30-60 seconds for the credentials cached to be cleared. Try accessing the shared folder again after 30-60 seconds and you will be asked to enter network password.


3. If there is any other credentials login in the system, it will disconnected from the shared folder.

That's it!!!!
Now giving the username and password on which you want to login into the shared folder , surely it will work.

Thanks & Have a great day!!!

For more information please read  from the below link.





Monday 21 October 2013

Patching Conepts


Patch is normally used to fix a problem , to upgrade to a higher version and to update (to add/enhance) the features in the existing product or software.

A patch can be applied in 2 ways: 1) Adpatch( Auto Patch Utility) 2) Opatch

All the Application related Patch can be applied via the Adpatch Utility(or also called Auto patch utility) and all the database related patch can be applied via the Optach utility.

The directory of the adpatch be : $AD_TOP/bin
The directory of the opatch be: $ORACLE_HOME/OPATCH

Before we are applying patches you need to understand some of the basic terminology which are very very important for patching concepts.

Maintenance Mode:

When we are choosing the maintenance mode while applying the patch, means we are protecting the other users to access the application i.e EBS Application. It's acts like an cold patch.
So the use of maintenance mode is to make sure non of the users have the access to application and only accessible to the patching activities. by doing so, it enhance the performance of the system by minimizing downtime.

Appl_Top
Also named as the Application Top. This is the top level where all the application and product files are resided. It is also called configuration file for proper functioning on Oracle Application.

adpatch option=hotpatch
The above following commands is used for, if some one applying the patch without  putting the EBS application maintenance mode.i.e (Hot Patch)

Cold Patch-  The EBS Application is down.( Maintenance Mode)
Hot Patch-  The Application is up.

Steps to apply the Patch via adpatch Utility

Step1. Before you are going to apply the patch check whether the patch is already present or not.
           select * from AD_BUGS where bug_number=’<patch number>’

Step2:  Download the patch by login into the oracle metalink.
            www.metalink.oracle.com
          then Select the Patches option and after that select the search type.Query for patching by writing the patch number which you want to download the patch.

Step3:  After download the patch now it's the time to move the zip folder to a directory from where we want to unzip it and apply the patch.

This can be done in two way: 1. Using winscp and 2) direct by typing the command MV in the unix box(in unix OS)

The command line to move the zip file from desktop to the execute directory.

mv <patch.zip> <destination patch directory>

example:   mv 1312323_lip.zip /home/oretail/debashis

Step4.  Now unzip the patch by entering the below command in the uni box.

          unzip 1312323_lip.zip

This will unzip the patch in current directory & will make the required patch directories & sub directories.

Step5. Enable the Maintenance Mode

Here you need to set the environments file located at the Appl_Top. After that you need to run the administration utility by typing adadmin  on unix console. Please answer the same which are present in the bracket related to the default questions regarding the ADADMIN utility.

After some steps of question and answers you will provide the below options and ask for the choices.

1.Generate applications file menu.
2.Maintain applications file menu.
3.Compile/Reload Applications Database Entities Menu.
4.Maintain Applications Database Entities Menu.
5.Change Maintenance Mode.
6.Exit ad Administration.

Choose 5 from the list of choices and press enter.

Step6: After change the Maintenance Mode, you need to enable the  Maintenance Mode
            1. Enable Maintenance Mode
            2. Disable Maintenance Mode
            3. Return to Main Menu
Choose 1 to Enable the Maintenance Mode

Step7. Run the auto patch from the patch directory by entering the log file into the console
           $adpatch1234.log and press enter

When you press the enter key in th unix box it wil start the processing of some questions answer and try to finisha the adpatch task. It also recommended you to run the log file if there is any error found while the processing

The name of logfile which you need to check if there is any error found while doing the adpatch in the unix box is: adpatch.log which is present in the $APPL_TOP/admin/<SID>/ directory.

If it gets successful  it will show you a message called autopatch is complete. and that's it about patching of the autopatch (in the application ).

In my nest post I will tell you how to apply patch in the database i.e optach.


How to apply the patch with out making the application turned into maintenance mode or down.

      
  Step1: Please follow upto Step 4 from the above procedure .

Step2:  After unzip the folder we need not to enable the Maintenance mode.
            The below command make you apply the adpatch : i.e   adpatch option=hotpatch

After it , it wil ask you the default questions and you need to provide the answers for the same .

like of

Your default directory is '/u01/oracle/FINPROD/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

Filename [adpatch.log] :

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :

Applications System Name [FINPROD] : FINPROD *


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *


Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
PPL_TOP Name [pians003] : pians003 *


Is this the correct database [Yes] ?


Enter the password for your 'SYSTEM' ORACLE schema:


Enter the ORACLE password of Application Object Library [APPS] :



And you are done. If u have corrected all the steps then the message you will get patching is completed otherwise will get the error message.



For more details please visit the Atul's Blog

How to apply adpatch in application with enabling the maintenance mode.





Friday 18 October 2013

What is the difference between Application Server, Web Server and Database Server

Web Server:

Web Server are technology  designed to create and host (or deploy) the website,serving up more on the content so then application. his server will have installed web servers such as IIS, apache, etc.

Application Server

Server on which your created applications which are utilizing your database, web service, etc. This application server will host business layer (wrapped with web services), scheduled jobs, windows services, etc.
An application server is technology where developers can create, test, and execute application components. Application servers are typically J2EE-based, running EJBs or other Java components. Application servers are designed to create true applications with complex business logic, and have scalability features such as load balancing, fail-over, and process distribution. In other words, it's primarily a development environment.

Database Server


Database server will have your one or more database hosted such as Oracle, Sql Server, MySql, etc.
The data, queries, report generatores, etc are all stored on the server, while the client machines use a front end to access those services.

The linkage between these three are .
The Application server acts   like a middle layer between Web Server and Database Server.

The Application Layer contains all the business logic data which are passed from the presentation layer i.e  (web server ) to the data base layer and all the communication b/w web server and the database server can possible viz application server only.

Web Server ----->      Application Server ----->     Database Server
(Presentation Layer)     (Business Logic Data)          (contains the database data )

Tuesday 24 September 2013

Working on the grep and awk in putty


grep-    grep is used in putty for pattern matching.

The grep command is used to search text or searches the given file for lines containing a match to the given strings or words. By default, grep displays the matching lines.



$ cat example.txt
UNIX operating system
UNIX and Linux operating system
Linux operation system

Now we want to search all lines in file example.txt which contains word UNIX but same time doesn't contain world Linux.
 
$ grep UNIX example.txt
UNIX operating system
UNIX and Linux operating system

Now to exclude all lines which contains Linux we will apply another grep command in this output with option -v to exclude matching word as shown in below grep command :


$ grep UNIX example.txt  | grep -v Linux
UNIX operating system





Read more: http://javarevisited.blogspot.com/2011/06/10-examples-of-grep-command-in-unix-and.html#ixzz2fnzlK6By


AWK is used for processing the rows and columns in a file. Awk has built in string function and associative arrays. It supports most of the operators, conditional blocks and loops available in C language.


How it works

oretail@abcd-xyz004|OID: ls -l

field1          field2  field3   field4             field5    filed6    field7        field8  filed9
-rw-rw-r--    1    oretail   orappadm         4        May      17           2012  1.abc
drwxrwxr-x   3    oretail   orappadm        256     Jun         29          2012  14159691
-rw-rw-r--    1    oretail   orappadm         4        May      17          2012  2.abc
-rw-rw-r--    1    oretail   orappadm         8       May       17          2012  3.abc

And among the 9 fields if we want to extract the field only then use the below command in unix box.

oretail@abcd-xyz|OID: awk '{print $1}' input_file
awk: 0602-533 Cannot find or open file input_file.
 The source line number is 1.



Same for column 2 ----8.

Now what I am doing in my project

After create the user changes in the Appoworx tool. I need to verify whether the count is same as per the sheet.

for that I need to connect to piand001 and login with  my credentials and password.

$ sudo su - appworx again ask for the password please provide the same. and all my user changes information present in the  u2/appworx/out

then ls -l | tail - (no of user changes done for the day )

 Now use the below command to sortout the logfiles.

$ grep -i user_name `ls -l o.RETAIL_USER_MAINT.*|grep "Sep 23"|awk '{print $9}'`|awk '{print $2}'

Meaning:  In ls -l field number 9 is file name.So it fill  get file name and grep for user_name in all the files
 of the date and the resulting output will be
o.RETAIL_USER_MAINT.6105052.00.log:export user_name="abendrok"
 in this field number 2 is user_name="abendrok"  it will print that. Space is used as separator.


Thanks & Have Fun...


Monday 23 September 2013

Install Oracle Developer Suite 10g on Windows7 (64-bit)

If you want to put up your hand in the Oracle Forms, then you need to install the database and oracle developer suite in the system.

It's depend on you what versions of database and developer suite will install on the system.

Here are the steps how you can install the Oracle Developer Suite 10g on Windows(64-bit) and solution of the some of the error while you might face during the installation.

Step1.  You need to download the whole package from the OTN.
Step2:   Right Click on the Setup file and choose the compatibility to make it Windows XP SP2.
Step3: Edit the Virtual Size (You may get an error intial part of the installation if you didn't set it correctly.)
Step4: Run the setup.exe

Setting of Virtual Memory.

Depending upon your actual memory avialable with you computer,set up virtual memory.  You can go upto the double the size of the actual memory while setting up the virtual memory in your system.

 Right click on My Computer > Properties > Advance System Settings (left panel) > Select Advance Tab > Under Performance area click on Settings> Go to Advance Tab > In Virtual Memory select Change button






Now in 2nd Step: After setup the virtual memory in your system you need to restart your system to see the actual effect.

3rd Step: Open the disk1 folder of the developer suite and locate "setup.exe" as shown in the below picture.
 

4th Step:  Right Click on the setup.exe and change the compatibilty to windows XP service pack 2 or 3.

























Step5: Go on click as you Install other software and when it ask for enter the disk2  browse and choose the disk 2.

And you will be done .

Now some possible error might you face while Installing the software.

Above one ( Setting of Virtual Memory One among them and it's the primary error you will face )


Please refer the below blogspot for poosiblity of generating the errors  and their respective errors.

http://shahiddba.blogspot.in/2012/05/install-oracle-developer-suite-10g-on.html