Archive

Archive for May, 2009

How to find out Schema Passwords in a 10gAS Application Server

May 26th, 2009 sam No comments

There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:-

A) Steps (through the ODM tool):-

1)   Log onto the host that hosts the infrastructure tier (e.g. host is – ausable) using x-windows like Hummingbird.

2)    Log on as user “oracle” – the user that did the install.

3)   Source the infrastructure tier environment file (if
you have one created that sets all the env. vars) as below:-

a.   $ cd bin – location of the environment file.

b.   $ . <as_infra> – environment file name.

4)   Open up oidadmin – Oracle Directory Manager tool as:-

a.   $ oidadmin

b.   Log in as orcladmin/<pwd> user.

5)   Follow the navigation path as below:-

Oracle Internet Directory Services -> orcladm@ausable.rfsuny.org:389 ->
Entry Management  -> Cn=OracleContext -> Cn=Products
->Cn=IAS -> Cn=IAS Infrastructure Databases ->
OrclReferenceName=<infra.rfsuny.org>  ->
OrclResourceName=<PORTAL> – The schema name you want the password
for.

6)   On the right hand side window-pane, you should see a
property called “orclpasswordattribute” on the
“Properties” tab.

7)   The Properties Tab would contain the password for the schema as shown in Figure A below:-

Figure A

8)   When logging in through SQL*Plus, the password is case in-sensitive as usual. 

B) Steps (through the command line):-

1)Log onto the host that hosts the infrastructure tier (ausable).

2)Log on as user “oracle” – the user that did the install.

3)  Source the infrastructure tier environment file as below:-

a.   $ cd bin – location of the environment file.

b.   $ . <as_infra> – environment file name.

4)  $ ldapsearch -D cn=orcladmin -w inadm02 -p 389 -h ausable
-b “cn=IAS,cn=Products,cn=OracleContext”  -s sub -v
OrclresourceName=<Schema Name> 

5)  You should see the O/P like this below on the host:-

ldap_init( ausable, 389 )filter pattern: OrclresourceName=PORTAL

returning: ALL

filter is: (OrclresourceName=PORTAL)

OrclResourceName=PORTAL,orclReferenceName=infra.rfsuny.org,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext

orclflexattribute1=true

orclresourcename=PORTALobjectclass=orclResourceDescriptor

objectclass=top orclpasswordattribute=<Schema Password> 

OrclResourceName=PORTAL,orclReferenceName=infra2.rfsuny.org,cn=IAS
Infrastructure
Databases,cn=IAS,cn=Products,cn=OracleContextorclpasswordattribute=<Schema Password>orclflexattribute1=trueorclresourcename=PORTALobjectclass=orclResourceDescriptorobjectclass=top

2 matches 

6) From the above pick the password from the instance you are interested in finding out the password.  

Categories: Oracle Tags:

Linux change ip address

May 18th, 2009 sam No comments

Q. How do I change ip address in Linux?

A. There are different ways to change IP address in Linux
(a) Command Line tools

(b) Modify configuration files

(c) Use GUI tools

Task: Display current IP address and setting for network interface called eth0

Use ifconfig command:
# ifconfig eth0
Output:

eth0      Link encap:Ethernet  HWaddr 00:30:48:5A:BF:46
          <strong>inet addr:<span style="color: rgb(255, 0, 0);">10.5.123.2</span>  Bcast:<span style="color: rgb(153, 102, 51);">10.5.123.63</span>  Mask:<span style="color: rgb(0, 153, 0);">255.255.255.192</span></strong>
          inet6 addr: fe80::230:48ff:fe5a:bf46/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:728204 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1097451 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:62774749 (59.8 MiB)  TX bytes:1584343634 (1.4 GiB)
          Interrupt:177

Task: Change IP address

You can change ip address using ifconfig command itself. To set IP address 192.168.1.5, enter command:
# ifconfig eth0 192.168.1.5 netmask 255.255.255.0 up
# ifconfig eth0

To make permanent changes to IP address you need to edit configuration file according to your Linux distribution.

Categories: Linux Tags:

Ten Simple Ways to Make Your Boss Think You’re Brilliant

May 17th, 2009 sam No comments

Whether it is for a pay raise, a promotion, a great reference, or just
a cubicle with a window, we all want to impress our boss at work. In
tough economic times, we might just be trying to avoid being first in
line for a pink slip. But honestly, do you really want to put in extra
unpaid hours, potentially work weekends, and break your Facebook and
Twitter habits?

Sure, it’s a means to an end and everyone has to
go above and beyond when needed. However, wouldn’t it be nice to have a
little help along the way? Here are ten simple, no-effort ways that will make your boss think you’re both indispensable and brilliant:

  1. Beat the Clock
    Most
    bosses are pretty consistent on the time they get into your office.
    Take note. If yours always arrives at 7.50 – get there at 7.45
    (even if your official start time is 8).

    Bonus to you:
    Arriving earlier than the boss makes you look keen and eager. Plus,
    when you’re skiving on Twitter or Facebook later in the day, you
    can justify it to yourself by those 15 extra minutes in the morning.

  2. Say “Good Morning!”
    However
    hungover, knackered or grumpy you’re feeling first thing in the
    morning, plaster a great big smile on your face and say, “Good
    Morning!” to your boss.

    Bonus to you:
    Two friendly words can go a long way in putting you in your
    boss’s good books first thing in the day. And (if you’re
    following the first tip), your boss will know you’re in the
    office bright and early.

  3. Volunteer Strategically
    If
    you’re in a meeting and someone asks for volunteers, be the first
    to put your hand up. That way, you’ll look keen and engaged. This
    will be a tough one to swallow if your workload is already jammed but
    volunteering for the right, high visibility project can increase the
    perception of you.

    Bonus to you:
    You’ll ­­get the task you want (i.e. the one with least
    effort but highest visibility) and not get lumbered with what the boss
    assigns you.

  4. Be the Printer Guru
    Even
    if it’s nothing at all to do with your job description, learn
    where the spare ink/toner is kept and how to fit it. When there’s
    a paper jam or error, get someone to show you what to do.

    Bonus to you:
    When your boss is running around in a flap before a big meeting,
    you’ll be the hero who fixes his
    very-important-report-won’t-print crisis.

  5. Say “Thanks”
    Been
    given a pay raise, promotion or extra day’s holiday – or
    even just some of your boss’s valuable time and advice? Make sure
    you say “thanks”. If possible, thank him/her at the time,
    and follow up with a short note to express your appreciation.

    Bonus to you:
    It takes ten minutes of your time and perhaps a couple of dollars to
    buy a “Thank You” card for your boss. If you feel strange
    with this one because a man giving a man a card is out of the norm,
    just send an email. In the end, it’s the thought that really counts
    here. Guess who’ll be first on his mind when the next round of
    pay-raises comes along?

  6. Make Coffee
    This will make most of the people in the office like you, not just your boss. However for you boss, occasionally
    take a minute to say “I’m just making myself a coffee, can
    I get you one?” (doing so multiple times per day will have the
    opposite effect as you’re labeled as a brown-noser).

    Bonus to you:
    For virtually zero effort, you give your boss the impression that
    you’re a considerate, friendly employee who cares about him/her
    – bosses often feel unloved.


  7. Use The Right Jargon
    Pay
    extra-close attention to the buzzwords that your boss uses. Drop these
    into the things you say at meetings, and into your emails. This
    isn’t a chance to play buzzword bingo – what you want to
    demonstrate is that you’re on the same wavelength as your boss.

    Bonus to you:
    Sometimes you can get away with something with just the right words.
    You’re not filing your emails for lack of anything better to do
    – you’re “implementing new communication management
    protocols to further the client-company relationship”.

  8. Create Procedures
    Closely
    related to using the right buzzwords is creating the right procedures
    – that is, any which get you out of hot water. If something goes
    pear-shaped at work, explain that it was “due to a procedural
    error” or “a fault in the procedure”. Then, try to
    correct the process.

    Bonus to you:
    Explaining that the same mistake can’t possibly happen again
    “once I’ve changed the procedure” makes your boss
    think you’re on top of everything. Even when you so, so
    aren’t.

  9. Leave An Email Trail
    If
    you’re ever working from home, a cunning way to demonstrate how
    many hours you’re (supposedly) putting in is to make sure that
    your boss is the recipient of, or copied in to, at least one of your
    emails first thing in the morning and last thing at night.

    Bonus to you:
    Your boss will think you’ve been hard at work between that first
    email at 7.30am and that last one at 9.00pm. You actually sent that
    first email in your jammies (and went straight back to bed), then took
    the afternoon off to catch a movie…


  10. Fake Enthusiasm
    Even
    if your job is as dry as dust, fake enthusiasm wherever possible.
    Plaster a big smile on your face and wave your hands around when
    enthusing to customers or colleagues about your company.
Categories: General Tags:

How to Learn a Little Every Day

May 17th, 2009 sam No comments

Something can be said for knowing a little bit about a lot of things.
Being an everyman or everywoman can propel you to a more efficient,
productive and fulfilled personal and professional life. Whether
it’s keeping up on current events, a new hobby or interest or
simply any new idea, taking a small amount of time to learn something
every day is a great way to add to your personal knowledgebase.

Incorporating
bits of learning into your every day experience puts you on a path to
lifelong learning. Lifelong learning keeps you engaged in your
environment, builds your knowledgebase, ensures that you use your mind,
provides a sense of accomplishment and simply makes you feel good. The
knowledge you gain, tools you get and experiences you have with
learning a little bit everyday all work together to achieve real
personal advancement.

Here are a few thoughts on how to incorporate learning a new thing each day into your routine.

Make it part of your routine and give it 20 minutes
Are
you a “getting things done” kind of person? Devote a small
amount of time each day, 20 minutes, to reading some new article or
book chapter or watching a video. On average we are all doing way too
much in our daily experience. However, a great way to feel good about
your day is to start off with an accomplishment by learning something
new, exercising or completing a work task. You might try all three
before you start your “real” day, but let’s stick to
the learning a little bit a day theme.

If you can’t start
your day with a little time for learning something new, try doing it at
lunch time or at the end of the day. Take an article to lunch or add a
video to watch to your iPod. After you have shut down your computer for
the day pull out your “learning” file and read a new
article.

Think of learning a little bit in your daily routine as
simple compound interest on your personal knowledgebase. If you were to
put away money every day in an account that earned simple interest the
balance on the account would accumulate exponentially by the daily
addition of principal. The same concept works for your knowledgebase,
add to it daily and your personal abilities will benefit exponentially.

Think About What Interests You and Surprise Yourself
What
ideas, information or things interest you? Answer that question for a
moment. Once you have your answer – find resources (hopefully free, see
below) on those subjects. Organize your interests whether on paper or
electronically in a way that can deliver bits of new information to you
on a regular basis. For example, keep a folder of articles either
physically or electronically. Pick something out of that folder and dig
into it at least once a day.

By the way, web videos of skate
boarders smashing through plate glass windows for the sheer fun of it,
doesn’t necessarily add to your lifelong learning experience -
unless you add it to the what not to do in life column. So, make sure
you choose some piece of information that fits within your personal
goals or might simply add value to your knowledgebase.

Once you
have your interests settled – surprise yourself. At least every few
days choose something to learn that may not be on the top of your list
as an interest or might not even be on your list at all. These things
tend to be really useful later – if not directly then indirectly. For
example, I would venture that most folks reading this article are not
heavily into Japanese Origami. However, twenty minutes of learning how
to fold a paper swan might come in handy years later as a way to change
what’s on your mind and bring some focus back into a really
stressful work day.

Use free resources
Organized
education can be expensive even though a necessity. However, learning a
little bit everyday can be virtually free if you take the time to find valuable resources. Use the web but also understand its limitations and use your public library.

When
using the web, recognize that there are incredible bits and pieces of
information to learn from all over the web from established media
outlets, universities, governments, and other sources. Once you found
some of these resources that interest you, see if they serve up their
information through Really Simple Syndication – RSS.

RSS
feeds can be a great way to find little bits of new information.
Practically, all e-mail programs support RSS and there are many
web-based and desktop programs that also support it. An RSS reader can
help you organize your “learning folder”, in fact it could
be that folder.

Public libraries are an incredible source of
free learning. Find your local library, get your card and take the time
to find books and other information that fit your interests.

Overall, it doesn’t take long to find a small bit of useful and interesting information that you can retain.

Take notes, spend some time reviewing

Learning
something new also requires you to retain all or some of what
you’ve learned. You need to make the most of those 20 minutes of
everyday. So, take some notes – in a journal, on the article or on a
sticky note.

One of the most effective ways of making sure you
retain something is by getting that piece of learning past your short
term memory. A good way to do just that is by taking some action beyond
reading or watching. Note taking can accomplish that by requiring your
brain to process the information in another way. Gather those notes
because you are going to use them later.

Once in a while, at the
end of a week or month, use your 20 minutes to look back at your notes.
Looking back at your notes will ensure that your knowledgebase was
added to and that you have gotten past short term retention.

Try
these few simple tips for learning a little bit every day and enjoy the
added value you have created in your personal knowledgebase.

Categories: General, Uncategorized Tags:

VERY USEFUL) Beneficial things in daily life.

May 17th, 2009 sam No comments

Ants Problem:

Keep the skin of cucumbers near the place or ant hole.

 

www.FunAndFunOnly.net

 

 

To get pure and clean ice:

Boil water first before freezing.

 

 

 www.FunAndFunOnly.net

 

 

To make the mirror shine:

Clean with spirit

 

www.FunAndFunOnly.net

 

 

To remove chewing gum from clothes:

Keep the cloth in the freezer for an hour.

 

 www.FunAndFunOnly.net

 

To whiten white clothes

Soak white clothes in hot water with a slice of lemon for 10 minutes 10.

 

www.FunAndFunOnly.net

 

To give a shine to hair:

Add one teaspoon of vinegar to hair, then wash hair.

 

 

www.FunAndFunOnly.net

 

 

 

To get maximum juice out of lemons:

Soak lemons in hot water for one hour, and then juice them.

 

 

 

www.FunAndFunOnly.net

 

 

To avoid smell of cabbage while cooking:

Keep a piece of bread on the cabbage in the vessel while cooking.

 

 

www.FunAndFunOnly.net

 

 

 

To rid the smell of fish from your hands:

Wash your hands with a little apple vinegar.

 

 

www.FunAndFunOnly.net

 

 

 

To avoid tears while cutting onions:

Chew gum.

 

www.FunAndFunOnly.net

 

 

 

 

To boil potatoes quickly:

Skin one potato from one side only before boiling.

 

 

www.FunAndFunOnly.net

 

 

 

To boil eggs quickly:

Add salt to the water and boil.

 

 

www.FunAndFunOnly.net

 

To remove ink from clothes:

Put toothpaste on the ink spots generously and let it dry completely, then wash.

www.FunAndFunOnly.net

 

 

 

To skin sweet potatoes quickly:

Soak in cold water immediately after boiling.

 

 

www.FunAndFunOnly.net

 

 

 

 

To get rid of mice or rats:

Sprinkle black pepper in places where you find mice or rats. They will run away.

 

 

www.FunAndFunOnly.net

Categories: General, Uncategorized Tags:

Funny Oracle FAQ’s

May 17th, 2009 sam No comments
Categories: General, Uncategorized Tags: ,

Moving Statistics from One Database to Other Database

May 10th, 2009 sam No comments

I had recently upgraded the Database from 10.1.0.4 to 10.2.0.4, I had saved the statistics in table sys.dictstattab. I want to test the statistics on the Test Database.

There are four basic steps to copy the statistics from one database to another database using DBMS_STATS:

1) Create a table in your database to hold the statistics. 
2) Move the statistics from the data dictionary to the table you created in step 1. 
3) Use the Oracle export/import tools to move the data (statistics) from the holding table in your database to a second database. 
4) Populate the data dictionary of the second database with the statistics from the holding table that were copied from the original database.
Categories: DBA, Oracle Tags: