Oracle Database Discussions

AFAIK 10gr2 is not yet certified for that version, so the installer raises an error while checking the o/s version. You can get around that by either editing /etc/issue (to fake the o/s version for the duration of install), or passing the -ignoreSysPrereqs option to runInstaller command. The former might be the better option as you probably don't want to skip kernel parameter checks etc.

I tried both options ie. by changing the /etc/issue file and by providing
-ignoreSysPrereq with the runInstaller command but all in vain, it did not work,
plz another solution...

> -ignoreSysPrereq with the runInstaller command but start runInstaller using this

./runinstaller -ignoreSysPrereqs

what error you have?

thanx the command was successful but there were folloing errors and setup did not start:

Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-01-07_04-18-20AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occured...

Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-01-07_04-18-20AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)

and there is list of such "at java.lang......" messages

and installer does not run
plz help me out

You should have the necessary X libraries in place in order for the installer to function. Did you select xorg etc. during installation?

yea I have installed xorg packages
here is the error message that is given:

Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-01-07_04-37-54AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2008-01-07_04-37-54AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.<init>(OiifmGraphicInterfaceManager.java:222)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiic.OiicInstaller.getInterfaceManager(OiicInstaller.java:436)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:926)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
Exception in thread "main" java.lang.NoClassDefFoundError
at oracle.sysman.oii.oiif.oiifm.OiifmGraphicInterfaceManager.<init>(OiifmGraphicInterfaceManager.java:222)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.createInterfaceManager(OiicSessionInterfaceManager.java:193)
at oracle.sysman.oii.oiic.OiicSessionInterfaceManager.getInterfaceManager(OiicSessionInterfaceManager.java:202)
at oracle.sysman.oii.oiif.oiifm.OiifmAlert.<clinit>(OiifmAlert.java:151)
at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:984)
at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)

now tell me what to do...plz

Well the error message is just saying that file libXp.so.6 cannot be found. Can you locate that file?

Please go through the following metalink document:
Requirements For Installing Oracle 10gR2 On RHEL/OEL 5 (x86) : Note:419646.1

Thanks
Arnab

libXp.so.6: cannot open shared object file: No such file or directory

Check whether libXp package is installed on your system (probably not) using following command:

rpm -q libXp

If it is not the install it.

thanx, it worked out, I installed the package libXp and did not get that error but there is another error which is:

Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified

Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
:0.0
:0.0
OUI-10025:Unable to start an interactive install session because of the following error:Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable. The DISPLAY environment variable should be set to <hostname or IP address>:<screen>, where the <screen> is usually '0.0'.
OUI-10026:Depending on the Unix Shell, you can use one of the following commands as examples to set the DISPLAY environment variable:
- For csh: % setenv DISPLAY 192.168.1.128:0.0
- For sh, ksh and bash: $ DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the following command to see what shell is being used:
echo $SHELL
Use the following command to view the current DISPLAY environment variable setting:
echo $DISPLAY
- Make sure that client users are authorized to connect to the X Server.
OUI-10027:To enable client users to access the X Server, open an xterm, dtterm or xconsole as the user that started the session and type the following command:
% xhost +
To test that the DISPLAY environment variable is set correctly, run a X11 based program that comes with the native operating system such as 'xclock':
% <full path to xclock... see below>
If you are not able to run xclock successfully, please refer to your PC-X Server or OS vendor for further assistance.
Typical path for 'xclock': '/usr/X11R6/bin/xclock'

kindly guide me what to do in this regard

Hi,

Please give the following command from root:
#xhost +
and then try to run the runInstaller from a new terminal.
The DISPLAY environment variable of the user should be set as:
DISPLAY=:0.0

Thanks

The Oracle Certify Matrix says it is certified.

Red Hat Enterprise AS/ES 5,4,3/Oracle VM. This issue is because the 10gR2 was issued before the rhel/oel 5 was issued, so the Enterprise Linux doesn't appear as a certified platform from the Oracle Universal Installer listed prerequisites point of view. A workaround has to be performed so this install can be done.

The -ignoreSysPrereqs is a valid one, but you have to absolutely make sure you meet all prerequisites, otherwise, a common symptom that this has skipped more prerequisites than just the OS version is the missing libraries, as I can see from this thread.



~ Madrid

This means you have ignored more prerequisites than just the OS version. I suggest you to refer to this step-by-step 10gR2 on EL5 Install guide --> Install DB10gR2 on RHEL5.


~ Madrid

thanx, I have installed the oracle 10gr2 on LinuxServer5, by giving the -ignoreSysPrereqs.
now plz guide me how to use the products, I mean I dont find GUI tools like Enterprise Manager or Sql which we use in windows. but I tried to give a command like

./sqlplus

and I got the following message:

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

plz guide me

Thanks for the update, I admit that I haven't checked the matrix for a while. Last time I did an rh(eIa)l5 install (~6 months ago) it wasn't yet cetrified.

As for your other comments, I really can't see why you addressed them to me; it's all in my first reply;) But if it helps the OP then I guess it's all good..

To the OP: Now that you've got the installation working, it might be a good time to RTFM

Hello
hope you wont mind this time
okay, now I am done with the installation but I am little confused about using different prdoucts like Enterprise Manager, I wana use it, but I dont know the way. I mean there are lot of executable files in the bin directory which one is for Enterprise Manager. I used ./dbca command and dbca started running, I tried to connect to SQL by giving the command
./sqlplus /nolog
it gave me the SQL> prompt but it does not connect me when I tried to connect by giving the command
SQL> connect / as sysdba
it gave me the following error

Error:
ORA-12546: TNS:permission denied

I dont know what is the reason, plz explain and help me rectify it, but I am also surprised that at the time of installation the installer did not ask me for any passwords for sys or sysdba or sysoper as it was told in cookbook Im using.
kindly tell me how to connect ot SQL and how to use Enterprise Manager

I really think you should spend some time reading the docs at this point. The answers are all there.

For example, the instructions to start enterprise manager database control can be found here.

There's also a section on using database configuration assistant.

edit: corrected a typo

Message was edited by:
antti.koskinen

thanx for the link, but when I ran the command:
emctl start dbconsole

I got the following message:

TZ set to US/Eastern
Cannot execute /u01/app/oracle/product/10.2.0/db_1/bin/emctl.pl since its userid does not match yours.

kindly help me out

This message seems pretty clear. You don't have set enviroment (at least ORACLE_HOME).

You have to run the command as the 'oracle' user ('oracle' being the username you used in the installation).

I switched the user to oracle but I got the following error:
TZ set to US/Eastern
EM Configuration issue. /u01/app/oracle/product/10.2.0/db_1/localhost_orc5 not found.

I think this error is bcoz when I ran the DBCA and created a database with SID=orc5, it did not complet sucessfully and I had the following errro when running the DBCA
"ORA-12546: TNS:permission denied"
igonre Abort

when I pressed the ignore button it went on creating database, but it kept on showing the same dialog box with same error of ORA-12546, I kept on ignoring and completed the 100%. but at the end I got the following message:
"Enterprise manager configuration failed due to the following error-
Invalid username/password."

now kindly tell me what to do, as I was failed to run the DBCA sucessfully and then Enterprise Manager also.

to login to your database you must run the following commands from the oracle user or set these in the user profile:

$export ORACLE_HOME=<Installation path of ORACLE software>
$export ORACLE_SID=<ORACLE instance name>
$export PATH=$ORACLE_HOME/bin:$PATH

then run :
$sqlplus "/ as sysdba"

DBCA issue:
you have to run the dbca again to create the database.

thanks
Arnab

Message was edited by:
Arnab

I think it would be best for you to take some time to read through the Administration manual. After that removing and creating instances with dbca should be a snap.

I know that it might feel irritating that people keep pointing you to documentation when you really just want an answer to that one Simple Question, but getting the basics down really is the only way to get competent with any technology in the long run.

Enterprise Manager, the one you used to know in 9i, is no longer installed with the database disk, you must intall the administrative client if you want to have OEM. On the other hand sqlplus cannot be accessed just by means of a ./ you should first verify your environment variables are properly set:

ORACLE_HOME=pathWhereYourOracleInstallationIs
ORACLE_SID=yourDefaultOracleSIDName
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export ORACLE_HOME
export ORACLE_SID
export PATH
export LD_LIBRARY_PATH


~ Madrid

I have set all the environment variables as you told and I ran the dbca to create the database but at the last step of the creation I got the same message of:

ORA-12546: TNS:permission denied

so I aborted the creation. kindly help me fixing this problem.

and one more thing when I ran the dbca as oracle user, I get the error at the last step of creation stating that "cannot create the folder..."

does it have to do with oracle account, tell me what permission does the oracle user lack or anything else and how to give those permissions.

thanx, I have set all the environment variables as you told and I ran the dbca to create the database but at the last step of the creation I got the same message of:

ORA-12546: TNS:permission denied

so I aborted the creation. kindly help me fixing this problem.

and one more thing when I ran the dbca as oracle user, I get the error at the last step of creation stating that "cannot create the folder..."

does it have to do with oracle account, tell me what permission does the oracle user lack or anything else and how to give those permissions.

I think that the following error
ORA-12546: TNS:permission denied
was due to the length of the passwords I was giving of 6 charachters, but when I gave 9 characters lengthy password, I did not get this error

moreover, I got the dbca started running by giving the permission to the folder that I created for storing the database files by giving the command

chown oracle.oinstall /u01/app/oracle/oradata

it did not give me the error of "cannott create folder"

and it started successfully and there were 3 steps listed like

copying database files
creating and starting oracle instance
completeing database creation

the progress bar kept on moving until it reached to 85% at the last step ie.
completing database creation

and now it has been more than 1 hour that progress bar is still on 85% and I am little worried about my success.

do you guys know anything related to this kind of delay in installation.
your comments will be helpful...

Dear expert,
everything was going fine until the dbca reached upto 85% of database creation and it stopped there and now it has been more than 20 hours that it is still on 85% and the progress par is stating that:

Clone database creation in progress

plz tell me what's the issue, does it happen everytime when the database is going to be created first time or its something else. plz help me out.

Open another session and check the last lines from the installation log file (installActionssomething)

here is the cloneDBCreation.log file's output
---------------------------------------------------------------------------------------------------------------------------------------
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
USERS
152 oracle@localhost (q001) 1
154 oracle@localhost (q000) 1
157 oracle@localhost (QMNC) 7
160 sqlplus@localhost (TNS V1-V3) 1 SYS
161 oracle@localhost (MMNL) 3
162 oracle@localhost (MMON) 3
163 oracle@localhost (RECO) 1
164 oracle@localhost (SMON) 1
165 oracle@localhost (CKPT) 1
166 oracle@localhost (LGWR) 1
167 oracle@localhost (DBW0) 1
168 oracle@localhost (MMAN) 1
169 oracle@localhost (PSP0) 1
170 oracle@localhost (PMON) 1
AL16UTF16
-------------------------------------------------------------------------------------------------------------------------------------
now tell me what's going wrong with the dbca...

Could you include the last lines from the 'parent' dbca log file as well - the one in 'cfgtoollogs' directory (which I falsely referred to as 'installActions' in my previous post).

there is no such file with the name parent in cfgtoollogs/dbca/oracle5, in any of these dir. in files like cloneDBCreation, postDBCreation.log there are lines saying that:

ORA-01109: database not open
Database closed.
Database dismounted.

and as in the dbca its the last step of
completing database creation

so I think its something about Database opening and closing, am I right ? if its something else plz guide me.

It could be something as simple as the installer process hanging because it doesn't have permissions to update /etc/oratab at the end of installation, or then it could be something completely different. But let's try to eliminate the guesswork..

Can you access the database w/ sql*plus from another session?

yea, I accessed the >SQL by giving the following command
./sqlplus /nolog
and then I gave the following command
connect / as sysdba
it gave the following message
connected to an idle instance

and then I gave the following command
startup
it came up with the follwoing message:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora'

now what to do !
but I think that unless and until a database is created by dbca, we cant connect to that database through SQL, am I right ? thats why its connecting me to an idle insantce and after that it does not startup the database as there is no database, right ?

Set ORACLE_SID before starting sql*plus.

thanx, it worked out, I changed the ORACLE_SID to oracle5 which is the name for my current installation which is being installed and not yet installed, but it worked.but what could be the issue with dbca as its not going beyond 85% and when I click the button Stop, then I get the warning box saying that:
Do you really want to stop the progress of operation "Clone databse creation".
I press the No button and installation continues but not a head of 85%, and yesterday I went to home keeping the installation continuing and came today but it was same 85% and nothing more. so what does your experience say...

I once encountered it.My database installation hanged at the last point.
i found one package was missing.
I installed it and it worked.
But your OS s different so check what things you need to install it.
First type
$ rpm -qa
Check them with the installation matrices.

can you plz tell me about some links which detail the list of rpms for oracle 10gr2 on Linux server 5

I made it complete up to 100% by unchecking the option at 4th step of database creation:

Configure the Database with Enterprise Manager

as I was checking this option in previous installations and reaching at 85% it did not move further, I think the issue was with the Configuration of Databases with Enterprise Manager Database Control, as the dbca was unable to configure it.
that's why when I was giving the command
./emctl start
it was not starting the EM and giving me the error:
EM Configuration issue. /u01/app/oracle/product/10.2.0/db_1/localhost_oracle1 not found.

so can you plz tell me how to configure and run Enterprise Manager Database Control...plz anything, I wana use EM

can anybody plz tell what is the reason for the following messages when I run the dbca in terminal and terminal window shows this, although dbca keeps on running and creates database without the option of configuring EM for the database(read the previous post for details);

sh: /tmp/cpuinfo.txt: Permission denied
sh: /tmp/swapinfo.txt: Permission denied
sh: /tmp/LinuxVendor_output.txt: Permission denied
sh: /tmp/LinuxVendor_output.txt: Permission denied
sh: /tmp/LinuxVendor_output.txt: Permission denied
sh: /tmp/LinuxVendor_output.txt: Permission denied
sh: /tmp/LinuxVendor_output.txt: Permission denied
sh: /tmp/LinuxVendor_output.txt: Permission denied
sh: /tmp/tmpFileKernelParms.txt: Permission denied

is it the reason for EM not being configured ? or what ?

For a complete package list required to install Oracle 10g on EL5, check this link --> HowTo Install DB10gR2 on RHEL5

For a troubleshooting guide for the EM I suggest you this reference --> Enterprise Manager DB Control Console

Please make sure you are using the same oracle user used to perform the installation, and check directory permissions.


~ Madrid

thanx, I installed all the required pakages but still I dont know why its getting stuck on configuration, like when I gave the follwoing command for configuration:
./emca -config dbcontrol db
it gave me the following

STARTED EMCA at Jan 14, 2008 8:02:13 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: testing1

I entered the SID, testing1, but after that terminal does not respond or goes blank. what could be the reason. what I know is that, there is some problem with configuration, there is something that hinders the configuration. I think I'll have to reinstall the oracle and do everything from scratch, what do u say ?

thanx God, its done, I installed the oracle from scratch but this time checked all prerequisites and the installation was complete and then I ran the dbca to create the database, it also completed 100% even with the option of Enterprise Manager. everything fine now but, as I was expecting that there will be a graphical or web based interface of Enterprise Manager Databae Control, as is also shown in the tutorial refered by you, but it did not show any GUI rather it gave me the follwoing successful message when I gave the command:
emctl start dbconsole

Starting Oracle Enterprise Manager 10g Database Control ............... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/localhost_oracle2/sysman/log.

am I asking wrong question or what, how can I find the GUI or webbased EM, plz guide.

no way, I'm sorry, I made little hurry to post the thread, actually I did not notice the url generated at the prompt which was(which I should have added with the last post):
http://localhost:5500/em/console/aboutApplication

its done now.
the EM interface is showing everything okay but the following

Listener:
status Down
Details TNS-12541: TNS:no listener

Agent Connection to Instance:
Status Failed
Details ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

something to do with listener ? plz guide...

no way, I'm sorry, I made little hurry to post the thread, actually I did not notice the url generated at the prompt which was(which I should have added with the last post):
http://localhost:5500/em/console/aboutApplication

its done now.

Did you ever get a resolution to your problem of not getting beyond 85% regarding the listener issue.

I am having the exact same problem. It would be very helpful if you could post your resolution.

Thanks!

yea sure, actually I got stuck on 85% of DBCA, bcoz I was missing some packages.
go on the 3rd page of this post and read post by Madrid whic includes lines like:

For a complete package list required to install Oracle 10g on EL5, check this link --> HowTo Install DB10gR2 on RHEL5

go to the link and complete the prereqs before installing Oracle 10gr2. tell me if it helps.

How did you switch the user to Oracle? I'm a UNIX newb too...