Monday, 25 August 2014

EBS - OID Integration

EBS - OID Derigster

Assumption EBS R12
OID 11g

Deregister SSO With EBS.

$FND_TOP/bin/txkrun.pl -script=SetSSOReg -deregister=yes

Remove References in EBS.

$FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=yes

#bearMan

Wednesday, 20 August 2014

Jdev JAVA_HOME

JDeveloper Set Java

It is quite easy to change the java used by jdev, all you need to do is find the jdev.conf file and change the line that has SetJavaHome in it.

This should be at the top of the file somewhere.

My config file is located at: /home/f/Oracle/Middleware11117/jdeveloper/jdev/bin

SetJavaHome /usr/lib/jvm/java-1.7.0-openjdk-amd64

#bearMan

Monday, 18 August 2014

OID: Context Initialization Error

ldapsearch


Context Initialization Error

You need to set your ORACLE_HOME to where you installed OID

an easy way on linux to do this is to firstly locate ldapsearch and then set the ORACLE_HOME to the path.

$ locate ldapsearch
/u01/app/oracle/product/fmw/Oracle_IDM1/bin/ldapsearch

$ export ORACLE_HOME=/u01/app/oracle/product/fmw/Oracle_IDM1

Then try run it again

#bearMan

Friday, 15 August 2014

OIM ldapsyncudf

oracle.iam.platform.utils.NoSuchServiceException: java.lang.reflect.InvocationTargetException
at oracle.iam.platform.OIMClient.getServiceDelegate(OIMClient.java:197)
at oracle.iam.platform.OIMClient.getService(OIMClient.java:174)
at oracle.iam.platform.OIMClient.loginSessionCreated(OIMClient.java:209)
at oracle.iam.platform.OIMClient.login(OIMClient.java:137)
at oracle.iam.platform.OIMClient.login(OIMClient.java:129)
at oracle.iam.platformservice.utils.LDAPSyncUDFUtil.main(LDAPSyncUDFUtil.java:146)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at oracle.iam.platform.OIMClient.getServiceDelegate(OIMClient.java:193)
at oracle.iam.platform.OIMClient.getService(OIMClient.java:174)
at oracle.iam.platform.OIMClient.loginSessionCreated(OIMClient.java:209)
at oracle.iam.platform.OIMClient.login(OIMClient.java:136)
... 2 more


In your OIM Sync Config make sure the OIMProviderURL's port is pointing to the port you access OIM on.

For example
OIMProviderURL=t3://localhost:14000

#bearMan

Wednesday, 13 August 2014

OIM - OAM 11.1.1.7 Error

Could not register OIM as a TAP partner. oamWlst MBean not found

This was a relatively easy fix for me, all you need to do is add 
OAM11G_WLS_ADMIN_HOST: <Host>
OAM11G_WLS_ADMIN_PORT: <port>
OAM11G_WLS_ADMIN_USER: weblogic

to your config file:
/u01/oracle/Oracle/Middleware/Oracle_IDM1/idmtools/bin/idmConfigTool.sh  -configOIM input_file=/u01/oracle/Oracle/Middleware/Oracle_IDM1/idmtools/bin/configOIM.properties

Tuesday, 12 August 2014

OIM Design Console

./xlclient.sh
Exception in thread "Main Thread" java.lang.NoClassDefFoundError: javax/ejb/CreateException
        at java.lang.Class.getDeclaredMethods0(Native Method)
        at java.lang.Class.privateGetDeclaredMethods(Class.java:2436)
        at java.lang.Class.getDeclaredMethod(Class.java:1937)
        at java.awt.Component.isCoalesceEventsOverriden(Component.java:5982)
        at java.awt.Component.access$500(Component.java:169)
        at java.awt.Component$3.run(Component.java:5936)
        at java.awt.Component$3.run(Component.java:5934)
        at java.awt.Component.checkCoalescing(Component.java:5933)
        at java.awt.Component.<init>(Component.java:5902)
        at java.awt.Container.<init>(Container.java:249)
        at java.awt.Window.<init>(Window.java:432)
        at java.awt.Frame.<init>(Frame.java:403)
        at java.awt.Frame.<init>(Frame.java:368)
        at javax.swing.JFrame.<init>(JFrame.java:158)
        at com.thortech.xl.gui.base.tcFrame.<init>(tcFrame.java:34)
        at com.thortech.xl.client.base.tcAppWindow.<init>(tcAppWindow.java:104)
        at com.thortech.xl.client.base.tcAppWindow.main(tcAppWindow.java:173)


cd $FMW/wlserver_10.3/server/lib/
export JAVA_HOME=<java_home>
java -jar wljarbuilder.jar

copy wlfullclient.jar to designconsole/ext/

cd $ORACLE_HOME/designconsole/
./xlclient.sh

Now you can log in.

Note: Default admin user = xelsysadm

#bearMan

Monday, 28 July 2014

Linux SSH Port Change

How to Change SSH PORT

vi Into sshd_conf

vi /etc/ssh/sshd_config
Then go to
#Port 22

Un-comment line, and change to desired port.

service sshd restart

#bearMan

Tuesday, 22 July 2014

Linux: Less

Less Is More

Wait what?
I don't agree with that statement generally, but when it comes to linux, well yea "less".

I know many people that like to tail log files, my preferred method.

Less


Less /path/to/log/file

My Observations:

It opens up a vim like terminal application that you can follow the logs and if needed, look into the logs.

Some Commands

ctrl+f = This is to go to the bottom
shift+f = This is to follow
ctrl+c = Cancel
q = Quit

#bearMan

Monday, 14 July 2014

OIM Server Logs

OIM Logs / Location / how I found them

I needed to find the OIM Log location today, and this was a pretty easy task, and I think this can be used for more than just this application. I am sure all applications will show their logs here.

Access to:
Console
ssh

so first things first, go to console, and then go to servers, click on the server you want, and click the tab, logging.


The log file name, is where the log is located.

So now for some SSH.

Go to:
user_projects/<domain>/<server>/logs/

My Use case would be

user_projects/IAMDomain/oim_server1/logs/

#bearMan

Tuesday, 24 June 2014

JDeveloper - SVN Issues

JDeveloper - SVN Issues

When working with SVN Projects in JDeveloper there are some issues, especially if you are not using JDevelopers Versioning tools. When Opening a SVN project it will not open folders within projects.

The way to solve this is by going to Tools -> Preferences -> Versioning.

Before Image:
JDeveloper SVN Issue, Before Correction
JDeveloper SVN Issue, Before Correction

JDeveloper SVN Issue, Before Correction
JDeveloper SVN Issue, Before Correction

Note: How the top two options have been unchecked. 
Both:
  • Use Navigator State Overlay Icons
  • Use Navigator State Overlay Labels
#bearMan

Thursday, 12 June 2014

SVN - The Good The Bad and The Ugly

SVN - History

So Recently I was told by someone that SVN "Looses" History, because the information he committed is not there.

So I wanted to do some Experiments.

What I needed

  • Local SVN
  • Project
  • Files

Initially, I created a local SVN Using Tortoise SVN.
Then I created a small Hello World Project Using ADF, with one page, and as we all know, doing something so simple creates many folders.
First Commit

Browse


First Log

When I add a Task Flow, with a page, the commit looks like this;
Task Flow Commit

If you press ok, at this stage without any changes, you task flow WILL NOT, i repeat WILL Not be committed to SVN. The folder icon will also be changed to look like it has all been committed.

After this, there are two scenarios that may happen after this, if you carry on working from the same project, everything will work as expected.

If you download the project from SVN, you will get errors, most probably ones saying the pages do not exist.

SVN Commit

When doing this make sure, if any new files were added, add them to be committed. 
non-versioned Commit
Commit Log
Make sure the non-versioned Status has been Checked. This can be done by clicking all, just above the file names.

Log

Please Note: The Actions in the Log, in the above picture, there are only adds, and Modifies. In the Below One there is a delete as well as Modify.


One thing to note: is now that I have done all this, no matter what I do on the SVN, those logs will never be changed.

The only things that one can change are the Author and "Message"

This is a very limited example of a SVN Server with Revisions, but I just wanted to show that there are certain things that you cannot do with a SVN, and there are certain things that one needs to do, otherwise your SVN commits will break the application.

#bearMan, f

Monday, 26 May 2014

Web Response

Web Response Time

Harping on the response time of a web application.

Something for us to think about.

A user wants to feel like they are manipulating the system, they want to feel the response, they want to control what is happening. Make sure user actions on a application take under 0.1 Second to register and respond to the server.

When the user does something that they expect the system to process or do something with the information the response time is upped to 0.2-1.0 Second. This lets the user feel like the system is working on the command.

Although the upper limit of the users attention is about 10 seconds, and yes roughly estimated, as each user is different, but after those precious seconds the user has lost concentration with what they were doing and is most likely to move along to the next task at hand.

#bearMan.

Wait what?

Thursday, 22 May 2014

Web Response Time

Response Times.

Unfortunately, most of us use some sort of the web on a daily basis, you being here right now, implies that the statement is true, well at least for you.

The biggest frustration on the web, is the time at which pages take to load. The current project I am on at the moment, had issues of that sort, where the pages were take 10 Seconds+ to load, on a good day. Granted this was on Dev, it was not acceptable, and unfortunately I was very busy and could only focus minimal hours a day on it.



One morning not so long ago, I was called into a meeting, where the executives for the consulting house I work for were in discussion with a few of my colleagues about the speed of the applications we were writing and using. Where we would sit and wait for a while before a page would complete loading. We could nearly have a full discussion on the topic before the page would load.

This was a growing concern with them, and a plan was put into place where the team were supposed to go back and find out some things about the speeds of their respective applications. We had a teasing team put a plan in place to see exactly what was happening, page loads, find some base lines. I was not part of the team, but I did some testing of myself.

I came up with a few baselines, mostly when the network was not under stress. The scary part about all this was that the pages would be taking 10+ Seconds to load. With the fastest being the login page where there was two pictures, relatively small, and the login form. With this page taking about 6 seconds to load, pictures and all.

After about a week of this hype within the team, where there was only a real hype from the team that was actively looking into the problem. There was barely any movement from there, and about a week later this so called problem with fully blown plan just died, no more mention about the beast. Although the whole team knew about this issue, there was little done from a testing perspective there on out.


Unfortunately, we are in a world where we are used to everything fast, from our cars that we drive to the cell phones we have in our hands, even the coffee machine is making us a cup of coffee within a few seconds. We are based in a world where speed is everything. Every seconds counts.

Some scary facts are that, if a page takes longer than 3 seconds to load, a user has a 45% to abandon the page. About 50% of us, expect a page to take under 2 seconds to load. Now thing about that for a second or three. How likely are you to leave a page if it takes a few seconds to load?
Can you just imagine what would happen if Google took longer than 2 seconds to load. Wow, the world would crash.

Now a average user is not willing to wait 10 seconds for a page to load. What would make this any different.


With that at the back of your mind, don't you think performance is something to always keep at the back of your mind while doing something for a customer?  Every Developer should remember these points. 1 Second may just one day be a million dollar mistake.  Think about it one second may cost you a fortune.

#bearMan saving you Time.

Hardware cant solve every issue.

Monday, 12 May 2014

LDIF Modify Group - Add New Members

LDIF Modify Group - Add New Members

dn: cn=iFACTORY,cn=groups,dc=MyCompany,dc=com
changetype: modify
add: uniquemember
uniquemember: cn=user1,cn=users,dc=MyCompany,dc=com
uniquemember: cn=user2,cn=users,dc=MyCompany,dc=com
uniquemember: cn=user3,cn=users,dc=MyCompany,dc=com

#bearMan, saving Myself Time

Thursday, 1 May 2014

Setting Up a Virtual Machine for Linux x64

Setting Up a Virtual Machine for Linux x64

I am going to demonstrate to you how to prep your Oracle Virtual Box.

You can download VirtualBox From: http://www.virtualbox.org

Create a new Virtual Machine


Allocate the amount of RAM Machine Will Have


Choose Create new Virtual HDD Now
Select HDD Type: I would use VDI, but it is up to you

Select Dynamically Allocated: (This basically means the Virtual Drive will expand, as needed, until full size)

Choose Size and Location


Once you have done that, select your Virtual Machine and Press
Ctrl + S

Once there go into System -> Processor and allocate number of CPU's I would recommend using more than one!
If you want you can also add the machine to your network:

Now that you have done this, you have a basic working Virtual Machine.

I would recommend adding more Video Memory but this is not a Must.


#bearMan

Tuesday, 29 April 2014

OIM - OAM Integration Error

Config file does not have System ID Container 

I am following:
http://docs.oracle.com/cd/E28280_01/doc.1111/e15740/oim.htm#AIING4000

oracle.idm.automation.exception.ExecutionFailedException: Config file does not have System ID Container Name
        at oracle.idm.automation.impl.oam.handlers.OAM11gIntegrationHandler.prepareLDAPUserDN(OAM11gIntegrationHandler.java:421)
        at oracle.idm.automation.impl.oam.handlers.OAM11gIntegrationHandler.configOAM11gIdStore(OAM11gIntegrationHandler.java:234)
        at oracle.idm.automation.impl.oam.handlers.OAM11gIntegrationHandler.execute(OAM11gIntegrationHandler.java:839)
        at oracle.idm.automation.AutomationTool.configOAM(AutomationTool.java:708)
        at oracle.idm.automation.AutomationTool.parseCmdLine(AutomationTool.java:232)
        at oracle.idm.automation.AutomationTool.main(AutomationTool.java:146)
Apr 29, 2014 6:52:41 PM oracle.idm.automation.impl.oam.handlers.OAM11gIntegrationHandler configOAM11gIdStore

I recently got this error while I was running
./idmConfigTool.sh –configOAM input_file=configOAM.properties

The way I solved this was by adding IDSTORE_SYSTEMIDBASE into my properties file

#bearMan

Thursday, 27 March 2014

Some Quotes to think About.

Quotes to think About within the IT industry.

Hi there are not allot of quotes, but I think these ones are quite powerful, and I will add them as I find nice ones.

"Assumptions are the mother of all mistakes"

"Just Make it happen"

"Most people suffer from the delusion of privacy"

#bearMan
"Just do it" "Just doing it"

Wednesday, 19 March 2014

Cannot execute LdapConfigPostSetup

Cannot execute LdapConfigPostSetup


My Error

 ./LDAPConfigPostSetup.sh
Usage: LDAPConfigPostSetup <location of ldapconfig.props file> [-changeLogNumber <number>]

What I was Doing

./LDAPConfigPostSetup.sh

What I Tried

./LDAPConfigPostSetup.sh /u01/app/oracle/product/fmw/Oracle_IAM1/server/ldap_config_util/ldapconfig.props

The Solution

./LDAPConfigPostSetup.sh /u01/app/oracle/product/fmw/Oracle_IAM1/server/ldap_config_util

Monday, 17 March 2014

Spritz

Fast Reading

Recently I was introduced to a new startup called Spritz

I don't want to write to much on them, because I think they have a really awesome Idea.

http://www.spritzinc.com/blog/#

They take your reading ability and most probably Double the speed if not increase it by more.

It is really awesome and I think everyone should know about it.

#bearMan

Friday, 14 March 2014

Windows Kill

Windows Command to kill Application

Short but Sweet:

taskkill -F -IM csgo*

This will kill any application that starts with csgo.

-F Force Kill

-IM Task Name

csgo can be replaced with google* notepad*

Short Cuts can be to run this from Win+R or "Run"

#bearMan

Wednesday, 12 March 2014

KickStarter

Where $1 Billion Dollars went.

Enjoy the link

https://www.kickstarter.com/1billion?ref=hero
Some cool stats From my Home Country.
South Africa
5,973 Backers
$1,193,925 Pledged

http://blog.milesgrimshaw.com/2014/03/10/1-billion/

I Would recommend going to the above link. Really cool.

#bearMan?

Monday, 10 March 2014

Entrepreneurs

Entrepreneurs Out There

In the past 10 Minutes I have read two different organizations that are backing young Entrepreneurs. These two that I read were either in the IT space or the Going Green Space.
Of which one of the great things I read was about the elevator Pitch. Basically to convince someone about your idea in the time of you are within an elevator.

So in lets say about 30 Seconds to 60 Seconds, inspire someone to buy into your idea.

What a good idea.
"If you can't explain it simply, you don't understand it well enough." Albert Einstein
So if you cannot explain something to someone and get them enthusiastic about your idea, do you really know what you are talking about, or do you really know what you want to achieve.

"If you can't explain it simply, you don't understand it well enough." Albert Einstein
Albert Einstein
Getting someone to think about your idea as amazing and wanting to hear more in a matter of seconds can be a challenge. One of the things you need to be, it good with words.

Something said simply does not mean what you are saying is simple by any means or terms. Although fancy words do help, if the person you are trying to sell this to does not understand where does complexity get you.

“Logic will get you from A to B. Imagination will take you everywhere.” Albert Einstein
The one thing you really need to get you somewhere in life is imagination. Without this, you really will get nowhere in life.

What does it take to change the world, one apple or an electron, the smallest things sometimes make the biggest difference and change the world.

http://www.greenchallenge.info/index.php/competition/entry-criteria
http://www.greenchallenge.info/
http://www.virgin.com/richard-branson/are-you-ready-for-a-challenge

if you want 5 tips go here
http://www.virgin.com/entrepreneur/5-lessons-we-can-learn-from-the-world%E2%80%99s-young-entrepreneur-of-the-year

#bearMan, wishing you good luck

Friday, 28 February 2014

Linux: List all Users

Linux: List all Users

cat /etc/passwd |grep "/home" |cut -d: -f1

If the user is not in the /home directory, this will not show.

If you want to get all Users:
cat /etc/passwd |grep "/" |cut -d: -f1
Reference
linuxquestions.org

#bearMan

Wednesday, 26 February 2014

The Pomodoro Technique

Pomodoro Technique

The Pomodoro technique is a efficiency technique used to make your work faster and better.

Working in 20-25 minute Cycles. While in these cycles you should learn to block all external disturbances out. These may include facebook, cellphones and people. The hardest one, you may encounter is the people, since you cannot control those and you cannot control what they do, it is really difficult to get people. One solution to that, is to not work at work, or tell people what you are doing, and when they come to your desk show them your timers.

This does not only include doing the work, but also recap and reviewing your work.

Where to get started:

#bearMan

Wednesday, 19 February 2014

Positivity

Positivity

So today I just woke up in a really upsetting mood. I was not feeling the day ahead of me and I had to drag myself out of bed. The day did not start off so well, but by the end of the day, it had surprised me and turned out to be a day to remember.

One thing that stuck with me was that, no matter how down and out you are, there is always something out there to look forward to, or be happy about.

I Hear something recently that really surprised me, Happiness makes you 30% more productive whilst working. Amazing now isn't it.

Here are some articles on the subject:
econstor.eu
warwick
google results

and here is a picture to make you smile.




Today is a good day, and the only one that has control over it, is you.

#bearMan, having a good day.

Friday, 14 February 2014

WebGate Agent - OHS Error

WebGate Agent - OHS Error

You can get the log in, the ohs log
$ORACLE_INSTANCE/diagnostics/logs/OHS/ohs1/ohs1.log

[2014-02-14T09:11:11.3508+02:00] [OHS] [WARNING:32] [OHS-9999] [core.c] [host_id: idm-dev.xxx] [host_addr: 10.0.9.61] [pid: 4255] [tid: 139799733962560] [user: root] [VirtualHost: main]  long lost child came home! (pid 13479)

I was trying to access the site from the IP address

Solution access it through the host_id.
http://idm-dev.xxx

If you need to add "idm-dev.xxx" to your host file.

#bearMan

A very good video to watch, (M&M)

Why work doesn't happen at work

I was trying to write something about this video, but I just came to the conclusion that if you want, you should watch the video.



#bearMan

Friday, 7 February 2014

Take on The Office

The Office

Companies spend so much money and time building an office space, but people don't go their to get work done, they go to the office to make their employees happy, to show they are doing something (To make their managers happy). People that go to the office, spend their time, trying to get time to work. They are not spending their time in the office working, but rather spending a few moments on the tasks at hand. Problems at hand are not really solved in the office but solved in a space of the individuals choosing, wither it be in the car, on a plane, or at home by the TV or in the Kitchen.

Once you step outside the office you get the time to solve these real issues. The day has been broken down into somewhat of an obstacle, where you are gathering moments in the day trying to get through some tasks. Inside the office, someone cannot really work efficiently, as soon as momentum is gained, something happens to stop it, halt.

The office in an environment of distraction and collaboration, a space most people cannot get work done. Offices and this environment may purposely fit for the general working, office clerk, but once you get into the industry I am in, where we need to really think about a problem or issue at hand. The creative juices up inside cannot start flowing until one really sits down and just has more than an hour or two to themselves. When in the office, how often do you have the hours to your self where you can really get that creativity poring out the crevices.

#bearMan working @home, in the office

Monday, 3 February 2014

Google Analytics Alternative

Ok so I know many people, including myself, love Google Analytic's but what happens if for some reason, you need to hold a local server, or you are hosting an internal website that does not have internet access and thus you cannot user Google Analytic's.

There is a really good solution that I have used at a client. The server we were tracking did not have internet access. So we set up a VM that hosted this server.

Piwik is an awesome alternative for Google Analytic's, it may not offer as much variety as Google Analytic's but allows for local hosting and can be used for multiple sites. Piwik is for functional values just as good as Google Analytic's.

The Dashboard that they show as the demo, is the screen shot below. I really like the looks of it. What you can also do is create your own dashboard this allows for user customization.



There is also a way to get the widgets from links and then what you can do is you can incorporate the widgets into your website.

A Nice replacement for Google Analytics.

#bearMan

Friday, 31 January 2014

Want to waste some time?

So today I was browsing the interwebs and I found a few awesome links, that I think everyone should take a look at.

They are not so much read based websites, but rather something to give you visual stimulation.

I think everyone should spend some time looking at them. They are really awesome, and if you are into web development I think you should also take some time and look at the code.


I really like fish, thus one of the sites that really got my attention was  an Aquarium it has a really awesome feeling to it, where you can control things like how many fish there are, I must have spent a good 5 – 10 Minutes watching the fish go by. Something I thought you may find interesting about Fish and watching fish.
Watching fish is thought to stimulate serotonin neurotransmitters in the brain leading to increasing production of endorphins. Endorphins are our body's natural ‘feel good' hormones and produce a feeling of happiness. These hormones also reduce anxiety, having a calming effect on the body and a range of other health benefits such as lowering blood pressure, and reducing hyperactivity.

Hope you enjoy.

#bearMan

Wednesday, 29 January 2014

Learning - I think every Linux user should know these three commands

Background

I was doing some downloading on a remote linux machine that I did not have a GUI for, I was only able to access the system through SSH. The problem with this was that I did not want to risk the download stopping if my connection to the server was lost. So my first problem, was learning screen.
After that I ran into another issue, how was I going to copy this file from the remote server to my local machine.

The Process

My First problem was how do I get a "extra" screen or terminal. The Solution was quite literally screen.
There are a number of really good tutorials out there, that can help one get to become a master with this application. I don't really want to become a master, but I wanted to know how to use this.
So firstly I installed it using yum.
yum install screen
wow ok, that was deceptively simple.
How do I use this,
screen -?
Cool
we want to create a new screen/ R seems to be ok.
screen -R
ok well, looks like nothing has changed. Lets test.
Opens another SSH Session and run
screen -list
Ok cool, there was a result and looks good.

Awesome
So lets go, download that file. (Making sure I was in the correct SSH Session, I closed the session that I used to check.) wget my file, the command is pretty simple wget -O '<From>' <to>
Not to sure if this was the best way to do this, but was the way I used and seemed to work.

Downloaded the file, completed, wanted to make sure the md5 was the same, md5sum the file. Once that was completed I got an output of the md5 and the file name.

Next problem, I need to get that file from the server. SCP to the rescue! Quick google search provided me with a solution, scp the file from server to my machine.

No problems, scp <user>@<computer>:<file> <toFile>.

Done!

To Long, Short Version

Basically the commands I think everyone should know are how to scp from one machine to another, md5 a file and screen.

scp

scp <user>@<computer>:<file> <toFile>

md5

md5sum <file>

screen

screen -R, either creates or resumes a screen session.
while in screen
ctrl + a
ctrl + d
"Closes" screen and resumes with normal terminal.

#bearMan saving mySelf.

Friday, 24 January 2014

Windows: Terminal

Customizing your Windows Command Prompt


Hate it when you go into terminal and you have this?

Or worse of f


How to make your cmd a little more “customized” and get your Friends to go wow.

All you need to do is type

Prompt  $A
Or My Favorite

Prompt $G

$H is also nice

Something easy to do J

Command
Affect
$A
& (Ampersand)
$B
| (pipe)
$C
( (Left parenthesis)
$D
Current date
$E
Escape code (ASCII code 27)
$F
) (Right parenthesis)
$G
> (greater-than sign)
$H
Backspace (erases previous character)
$L
< (less-than sign)
$N
Current drive
$P
Current drive and path
$Q
#NAME?
$S
  (space)
$T
Current Time
$V
Windows version number
$_
Carriage return and linefeed
$$
$ (dollar sign)


#bearMan

Wednesday, 22 January 2014

Oracle XEr2 Enable HR Schema

Oracle XEr2 Enable HR Schema

So now that we have the XE installed lets enable your HR Schema.

Log into the sqlplus and execute this:

Alter user hr identified by hr account unlock;

Then you can log into the Schema

#bearMan

Friday, 17 January 2014

Oracle XEr2 Check Database

Oracle XE SQLPLUS

Now that we have out Oracle XEr2 Database Installed Lets use our Main “DBA” tool, sqlplus.

What you can do is run Command Prompt or Terminal

Type:
Sqlplus / as sysdba

You should log in. If you don’t

You will need to go into the File the contains SQLPLUS.
Mine was:
C:\oraclexe\app\oracle\product\11.2.0\server\bin

Cd C:\oraclexe\app\oracle\product\11.2.0\server\bin

Once there you can run that command.


Run
Selext * from dual;

If you get this command it means your database is running.

Have fun selecting J

#bearMan

Wednesday, 15 January 2014

Windows: Setting Up Oracle XEr2 Windows 8.1

Step by step Guide to install Oracle XE on Windows 8.


I Will be assuming you have the installer and have Extracted it.

Note this is a fairly Standard Install,

Step 1:
Run the install, it will extract, decompress the install Files and then prepare for the install




Step 2:
Welcome Page, Click Next

Step 3:
Accept License Agreement


Browse where you want to install Oracle XE.
If you want you can change the install Path.

Step 4:
Enter SYSDBA password


I usually Make this “sys” as I don’t use the Database for anything other than Dev.

Click Next

Step 5:
Summary and Click Install.


The Biggest things to take note of are the ports:
Port for 'Oracle Database Listener': 1521
Port for 'Oracle Services for Microsoft Transaction Server': 2030
Port for 'Oracle HTTP Listener': 8080

The two Most Important are Port 1521 and 8080.

Step 6:
Installing Process:

Note there may be errors if they are:

Or


You can ignore them. They will not affect any part of the database.        

Well Done, the database will be configuring itself. (This may take a while)



Enjoy your new install of Oracle XE

#bearMan