Help for Oracle Installation?

Hi guys,

can anyone help me with the installation for oracle 8i on a solaris box?

I have look through the offical doc from oracle regarding the installation, somehow, i find it to be tiredsome. Lot of steps, i dun really understand.

Somehow, i pick up this doc from this site:
http://www.bolthole.com/solaris/oracle.html

It simplier the installation for the oracle8i.

Now the problem, i am facing is , after the installation of the oracle,into the opt/oracle/oraHome1

I can view all the files inside. After, i install the oracle8i management and integration. All the files are located inside opt/oracle/oracleHome1

I log into my solaris intel as ( oracle ) user, i key in this command, but nothing come out, what really happen? Pls advise ????

$sqlplus
$ksh:sqlplus not found


Thanks in advance, if i not mistaken, you have to log in as oracle user, it will show $ instead of #. # is the root account.

I have try other commands like dbassisst , nothing happen.

Pls help!!!

Have you tried running sqlplus from it's source directory :

$ORACLE_HOME/bin?

If this works, it could just be the paths set up for the oracle account.

Nick

Hi ngdh,

the path for my oracle installation is at /opt/oracle/oraHome1?

1) Am i doing the right installation?
2)Is it a must to run the sqlplus from the oracle_home/bin?

I thought the proper way, as long, log in as a oracle user, key in the commands, it will automatically run the program?

Pls advise, if there's anyone have more feedback on it. Kindly appreciated. Thanks

Hi Daniel,

I'm working on HP-UX so you may have to adapt this information for Solaris.

If the $PATH variable is set to include the directory for sqlplus, then you don't have to run it from it's own location.

I merely suggested this to find out whether the installation had worked properly.

Try entering
which sqlplus

I suspect the response will be
no sqlplus in {list of directories}

Then enter
find / -name sqlplus
and note down the directory.

You will then need to change the .profile file for the Oracle account and add that directory to the $PATH variable.

If the find command does not list the location you may have a had a problem installing Oracle. I would suggest a re-install.

Regards

Nick

Hi Nick,

thanks for your advice. Like to check with you, are you working in the IT field? Doing DBA jobs ? Or Unix Admin ? or something else?

I will check it out, and let you know, if i encounter any more problems.

Hmm tough question.

Basically both Unix admin and DBA although I don't deal with Unix backups or networking except for tnsnames.ora.

Handle PL/SQL, MF COBOL and DB2.

Kinda end up doing anything the client wants from COBOL to ORACLE to SAS.

It's pretty low level though as the db is small and it's not 24/7.

Snuff 'bout me.

Cheers
Nick

You're an SCSA and not sure about what the startup shell is for your Oracle owner UNIX account? You wouldn't know anything about "which sqlplus" or "echo $PATH" or following instructions about using OFA so you would know where your Oracle executables are located? Gee, the install guide is very straightforward, so I don't understand why you don't know how to install Oracle better than the people who wrote the install guide. That's how you said things are for you in another thread.

there u see... if u have CHEATED in your exams, then u end up like this wannabe OCP DBA. I suggest everyone to take a lesson in this guy, and kindly do not CHEAT in the certification exams as this kills..........the quality and image of the certification.

Hey come on guys, i just asking out of good will. Seems to me that some guys are out to say bad remarks.

Yes, i am a SCSA, the shell for my Oracle account is KSH, i have even use the find / -name sqlplus to find , but it turn out it could'nt be found.

The installation guides is difficult, who say is straight forward. You have to check the settings for your unix server, create account for oracle installation, install managment packs, post installation, configuring for the unix accounts and files like lib and others. Frankly speaking, i neve install a oracle DB on unix before, only on windows. That's why, i sending a reply in this forum to ask for help. In the end, ppl will pass silly remarks on me.

Worst, an advisor somemore and Junior member from nowhere. I really dun know what to say.

Right, when ppl saw my title, they think, how could a guy taken up so many certifications. Cheaters. Okie, since that the case, tell me your occupations ?
We will try to vie any troubleshooting on system or database or network. And we will know, who is cheaters.
This may sound silly, but that the only way to shutup ppl mouth.

I trying to be nice and ask for help. For one reason, i know the moderator will stop this post, if things getting out of hand. He usually do that. Even, if i am right.

I can go into a debate, and i know that you will lose out. But for what, i am just enquire something that's all.

PPL take note of the next reply or post, for those ppl who pass those remarks. And, you will know, who's wrong.

Thanks!!!



Anyway, ngh, thanks for sharing some of the installation tips. Have a good day ahead.

If in doubt go back to the platform specific installation guide and follow it to the letter. This will include the setup of the correct profile. If you follow these instructions properly you will end up with a fully functional system. If you try to look for a shortcut you may well end up where you are now, with a system that doesn't work properly.

Cheers

well normally when you run something and it says not found it´s because it is not located in your $PATH and that´s why someone pointed to run it from $ORACLE_HOME/bin

May be you can paste your .profile and/or .kshrc

Hi Daniel,

Interesting, did the OUI complete OK?

I pretty sure that sqlplus is not an optional component.

Are you doing this in a work context or practice lab.

If the later is the case, I did a similar installation for SuSe 7.3. I installed 8.1.6 EE and didn't have to change any defaults. My only issue was the glib patch level.

Are you sure the environment variables for ORACLE_HOME and LD_LIBRARY_PATH are set according to your documentation and the PATH variable contains a path to the SQL*PLUS bin directory.


Regards

Nick

The best thing to get quick help for install is search for platfarm specific 'quick install guide' on oracle's metalink. Its really a quick guide!

What is your email address? I will send you a step-by-step guide on how to install 8i on Solaris 8.

Guys, i am really please to know that you all are most willigly to help me out in the installation.

I have spent countless night staying up to install it.

However, i failed. I try to run the sqlplus in the OraHome1, but it say can't execute.

I use find / -name sqlplus , nothing appear.

I follow the steps in the doc. But it's not successful. Even, my frenz who is a guru in unix, he did the samething, he also failed.

Dun tell me, there's something wrong with my CD?

I really dun know what to do. Really appreciate, if anyone can help me out.

Stecal,

My email address is : [email protected]

Let me know if you have send it.

Once again, guys, really thanks you all for giving me all the advices.

Have a good day ahead.

To ngh

Hi Nick,

can i have your email address, so tat i can seek more advices from you on the installation?

Rest of the guys, feedback are most welcome. Appreicate, showing your interest in helping me.

Cheers!!

well if you cannot find it from root I guess it's not installed properly i.e relinking was not successful

however have you had a look in your $ORACLE_HOME/bin and see what's there?

have you checked the installation logs in oraInventory?

have you tried other binaries such as lsnrctl?

have you configured properly you .profile?

are you sure your installtion finished successful?

Daniel

You're welcome to my email [email protected] but keep posting your questions here as it helps other people trying the same thing.

Before you do anything, checkout Pando's list especially oraInventory. Sounds like the guy's already been through it.

Also post exactly which version and whether you were doing a silent or GUI install.

Regards

Nick

Guys, this is what i do, pls help to check it out and advise. Thanks!!!

Log in as a root account into my Sun Solaris.


To configure the unix kernel:
1) # cd /etc
2) # vi system

I will input these values into the /etc/system

3)set shmsys:shminfor_shmmax=4294967295
set shmsys:shminfor_shmmin=1
set shmsys:shminfor_shmmni=100
set shmsys:shminfor_shmseg=10
set shmsys:shminfor_semmni=100
set shmsys:shminfor_semmsl=100
set shmsys:shminfor_semmns=200
set shmsys:shminfor_semopm=100
set shmsys:shminfor_semvmx=32767

:wq ( save & quit )

4) reboot the server

Unix group and account creation

5) # groupadd dba
6) # groupadd oinstall
7) # useradd -G oinstall -g dba -m -d /opt/oracle -s /bin/ksh oracle

Should i change the login shell to : /usr/bin/sh ? or something else or it does'nt really matter?

Log into the system using oracle account:
key in the following commands:

8)$ umask
9)$ 0022
10)$ umask 022
11) $ 0022
Anything wrong here?


12) $ cd /opt/oracle
13) $ ls -la oracle

List down all the directories, locating the .profile file

14) $ vi .profile

Enter the following values:


15) $ DISPLAY=workstation_name:0.0
$ export DISPLAY

$ORACLE_HOME/bin,/usr/bin,/etc,/usr/ccs/bin,/usr/openwin/bin

:wq

Did i miss out anything inside the profile? Maybe,something is wrong from here?

Need to update the environment for current session:


16) $ ../.profile

Anything wrong here? I key in this command, and there's nothing happen.

Next will be the installation...

Guys, from the start till the current one, am i doing the right things, did i miss out anything or i have to add certain lines?

If confirm correct, next reply, i will continue with the installation of the Oracle.

Pls help me to check it out. Really thanks you all for viewing this message and answering to my query.

Cheers!!!

Quote:

---

Originally posted by danielwong

$ umask
$ORACLE_HOME/bin,/usr/bin,/etc,/usr/ccs/bin,/usr/openwin/bin

---

umask goes to .profile



export ORACLE_HOME=/usr/users/oracle8i/app/oracle/product/8.1.7
export ORACLE_SID=gestsapr
export PATH=.:$ORACLE_HOME/bin:/usr/ccs/bin:/usr/sbin:/sbin:/bin:/usr/bin:/opt/bin:/usr/bin/X11:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_BASE=/usr/users/oracle8i/app/oracle
export NLS_LANG=American_America.WE8ISO8859P1
#export TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN=$HOME/TNSADMIN
export SQLPATH=$HOME/lsc_scripts

your export seems wrong... or you pasted wrong? you use : not ,

Hi pando,


But, how am i going to umask go to profile?

I thought umask, should do it before i set those values inside the .profile?

You mean after i ( vi .profile ) inside there, i just insert
umask 022

Kind of strange....

So, inside the .profile, i should insert those values, which you have listed?

1) vi .profile

export ORACLE_HOME=/usr/users/oracle8i/app/oracle/product/8.1.7
export ORACLE_SID=gestsapr
export PATH=.:$ORACLE_HOME/bin:/usr/ccs/bin:/usr/sbin:/sbin:/bin:/usr/bin:/opt/bin:/usr/bin/X11:$HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_BASE=/usr/users/oracle8i/app/oracle
export NLS_LANG=American_America.WE8ISO8859P1
#export TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN=$HOME/TNSADMIN
export SQLPATH=$HOME/lsc_scripts

:wq


Am i right? Pls advise.

How abt afte inserting those values:

$ ../.profile

Do, i need to key in this command, this is what the doc say.

I sent you an install guide and a sample .cshrc file for your oracle user.

Hi Daniel,

Just in case stecal's document doesn't cover them I've got a couple of points for you.

Firstly the .profile gets run when the user logs in and supercedes settings in the system profile.

The umask command displays/sets the default R/W/X permissions for any files you might create. If you run it on the command line it only persists for the duration of your session so you need to add it to .profile so that it will be set every time you logon.

Second the PATH variable in your .profile is preceded by a . (period). This shouldn't cause any issues with OUI but is generally frowned upon as it means that when you issue a command, the first directory that is searched is the one that you happen to be in at the time. This may be fine but may mean you pick up the wrong version of a command.

Finally "$ ../.profile". This isn't quite right. I think what you want is "$. ./.profile" noting the space between the first and second period. Stick with me and I'll try and explain.

The first . says Don't spawn a sub-shell just run the next command in the current shell. The is done 'cos if a sub-shell was spawned, any variables set would not be useable when the script completes.

The ./ is known as a relative path.

So what you end up with is a command that runs .profile and sets your variables, umask etc. in the current shell.

Having said all that, I personally prefer to log out and back in again to pick up the new .profile.

All the best

Nick

All corrections gratefully received (God knows I need them!)

hmm of course you can add umask in .profile, you can add commands in .profile and umask is a command

by the way the installation guide explains all about the variables I put... are you sure you have read it properly?!?!?

as a SCSA you seems dont have a single clue about the most basic UNIX user file, .profile

You dont even know how to export variables properly!

I hope you know at least how to do echo $PATH

good luck paper cert

Down Killer, down. We've already beaten this horse to death. All the pile-ups or gang beatings should take place on the first page of a multi-page thread. By page three, the original poster has undergone enough behavior modification therapy and has seen the error of his/her ways.

Quote:

---

Originally posted by Sweetie
as a SCSA you seems dont have a single clue about the most basic UNIX user file, .profile

You dont even know how to export variables properly!

I hope you know at least how to do echo $PATH

good luck paper cert

---

cant agree more than this

100% agree

even the graduates we hired these couple of weeks know how to export variable and configure basic .profile in unix

Sorry Stecal but I have to add something.

If the guy was simply asking for brain dumps or ILT copies I'd agree with you all.

Whatever his reason for collecting certs He's just trying to get on.

I know it took me several attempts to install 8.1.6 on Suse 7.3. Painful experience!

Hopefully we all try to give him a break.

Hi ngdh,

thanks for the information. Those memebers in this forum is damn strange and odd. First, they ask me to follow the documents for installation and i follow, this export values are what i get from the documents and i input in the ./profile. And, now they say, i dun know how to do. If that the case, how am i going to know the ./profile is it a file or dir. Or i use vi editor to go inside and edit it. Either i say the right or wrong stuffs,i always get bash out, when ppl saw my certs. Anyway, i know what i doing and what's my ability. If those ppl are really that good, they should contribute more advices to the others instead bashing up ppl with silly and uncommentable remarks.

Grown up man....wonder how old are they, and what they are they thinking....

Stecal, thanks for your files....

Ngdh,I will send you a email personally and ask advice from you. This thread is getting lengthly, and some ppl are plain annoying, keep bashing ppl out. I mean some of them and not all the members from this forum.

I swear, i never ask questions in this forums. I only reply to those ppl who need help, maybe in terms of studying, certifications or facing system or network,
database( MS SQL ) problem. This is the worst forums, i ever been to. Sucks big time.

Remember, those ppl who bash me up...instead of helping, they are giving bad remarks...and unrealistic...

Dun ever, let me saw your posting in this forums. I will certainly bash you up for wat you all say in this thread.

From that time, dun ask for my pardon. I make sure, you all will lose your digitly for whatever things you ask.

Anway, for those ppl helping me and giving me advices, from my heart , i really appreciated for your time and effort.

I should leave this thread once and for all.