well..do a clean reinstallation...then point ur LD_LIBRARY_PATH to $ORACLE_HOME/lib32 ..then launch DBCA again? see if that helps?
Printable View
well..do a clean reinstallation...then point ur LD_LIBRARY_PATH to $ORACLE_HOME/lib32 ..then launch DBCA again? see if that helps?
export LD_ASSUME_KERNEL=2.4.19Code:# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
######################################################################################
### ORACLE ENV VARIABLES
######################################################################################
# export LD_ASSUME_KERNEL=2.4.19 # required for Oracle 9iR2, Note 252217.1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
export ORACLE_SID=SIMP
export NLS_LANG=SPANISH_SPAIN.WE8ISO8859P1
export NLS_DATE_FORMAT="YYYYMMDD HH24:MI:SS"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export BIN_SCRIPTS=$HOME/bin
export PS1="[`whoami`@`hostname`".'$PWD ]'
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_BASE/OPatch:$BIN_SCRIPTS
export PATH
export EDITOR=/bin/vi
export SQLPATH=$HOME/bin/sql
unset USERNAME
http://metalink.oracle.com/metalink/...&p_id=252217.1
Hello Jeff,
I have been looking at the Metalink article you pointed out to me: TID 135249.1. I tried typing some of the suggested commands put ran into other issues, such as:
-----
1) cat hosts
(no such file or directory)
2) hostname
(Linux2005)
3) nslookup
(note nslookup is deprecated and may be removed from future releases consider using the 'dig' or 'host' programs instead. Run nslookup with the '-sil ent' option to prevent this message from appearing.)
-----
How can I go about addressing and resolving the PB with the Java Exceptions in the error log file + IP host Pop-up message during the installation ?
PT
PS: I will attemps to reinstall the Oracle 9i database + change the library + relink all.
Hello,
When I type the UNIX dig command, I get an output similar to this:
-----
Query Time: 356 msec
Server: 192.9.200.80#53 (192.9.200.80)
MSG Size:
RCVD: 436
DIG 9.2.2
printcmd
QUESTION SECTION
....
ANSWER SECION
....
ADDITIONAL SECTION
....
-----
How is this information relevant to my PB ?
PT
ptreves,
Vous pourriez le trouver plus serviable pour le trouver près de vous qui a fait plusieurs Oracle réussi installe et les a vous marche par l'installation d'Oracle.
Si vous avez lu l'avant que vous installez le guide pour l'Oracle 9i, et a préparé votre environnement correctement vous n'obtiendriez pas ces erreurs.
Si vous essayez de courir bien que ce procédé manuellement vous ferez la rencontre probable problèmes pareils que vous avez rencontré déjÃ*.
I hope that this helps.
Hello Gandolf,
The point is that I did go through and read the ORacle 9i installation guide and the technial notes relative to the installation. My point is that I get different error messages inspight of this. I am aware that Linux Red Hat Enterprise 3 (WS) is not certified with Oracle, but we want to try to install Oracle 9i any way.
At this point, I know I am getting networking issues relative to the IP address during installation, but some of the UNIX commands such as nslookup and such are not supported in Red Hat. How can I go about resolving this issue ?
Any other ideas ?
PY
u're best bet besides metalink is probably the linux forums:
-linuxquestions.org
-linux.com/howto
..etc where someone has tried to to the same..i.e install on RH 3 WS
remember seeing something on the same lines on linuxquestions.org !!
:cool:
http://metalink.oracle.com/metalink/...&p_id=219228.1
http://metalink.oracle.com/metalink/..._id=193061.996
and post your bash_profile
and it's cat /etc/hosts not cat hosts... learn some basic linux first or install on windows
Have you checked to make sure that the Java run time library is in the class path and is the right version? AFAIK, the install should work fine as long as your environment is setup correctly.Quote:
Originally posted by ptreves
Hello Gandolf,
The point is that I did go through and read the ORacle 9i installation guide and the technial notes relative to the installation. My point is that I get different error messages inspight of this. I am aware that Linux Red Hat Enterprise 3 (WS) is not certified with Oracle, but we want to try to install Oracle 9i any way.
At this point, I know I am getting networking issues relative to the IP address during installation, but some of the UNIX commands such as nslookup and such are not supported in Red Hat. How can I go about resolving this issue ?
Any other ideas ?
PY
Show me the exact output of (note: my hostname is jake):
Code:[oracle@jake oracle]$ export DISPLAY=jake:0.0
[oracle@jake oracle]$ which dbca
/u01/app/oracle/product/920/bin/dbca
[oracle@jake oracle]$ grep JRE `which dbca`
JRE_FILE=rt.jar
JRE_DIR=/u01/app/oracle/product/920/JRE
JRE_CLASSPATH=$JRE_DIR/lib/$JRE_FILE
I18_CLASSPATH=$JRE_DIR/lib/$I18_FILE
CLASSPATH=$JRE_CLASSPATH:$I18_CLASSPATH:$DBCA_CLASSPATH:$ASSISTANTS_COMMON_CLASSPATH:$EWT_CLASSPATH:$SHARE_CLASSPATH:$HELP_CLASSPATH:$ICE_BROWSER_CLASSPATH:$KODIAK_CLASSPATH:$SWING_CLASSPATH:$XMLPARSER_CLASSPATH:$GSS_CLASSPATH:$JDBC_CLASSPATH:$VISI_CLASSPATH:$NETCFG_CLASSPATH:$SRVM_CLASSPATH:$EM_CLASSPATH
$JRE_DIR/bin/jre -native -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
$JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
[oracle@jake oracle]$ which java
/usr/local/bin/java
[oracle@jake oracle]$ java -version
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2-b28)
Java HotSpot(TM) Client VM (build 1.4.2-b28, mixed mode)
[oracle@jake oracle]$ dbca &
[1] 7668
Hello,
Basically, I made sure that the Red Hat package:
jdk-1.3.1.09.i586.RPM was installed on my Red Hat Linux Server on a folder CD_ROM_RDPMS.
Let me mention that during the installation, at the Configuration Assistants under the OUI, I did have problems with the following assistants:
-----
1) Agent Configuration Assistant
(Parameter orahome=/home/oracle...
nodeinfo = NO_VALUE)
(Cancelled)
2) Starting HTTP Server
(Error Resolving hostname: localhost)
-----
Are these problems related to the issue I have with the DBCA ?
Is there a Metalink about these installation problems ?
PT
Quote:
Originally posted by ptreves
1) Agent Configuration Assistant
(Parameter orahome=/home/oracle...
nodeinfo = NO_VALUE)
(Cancelled)
show me:
Code:[oracle@jake oracle]$ grep ^hosts /etc/nsswitch.conf
hosts: files dns
[oracle@jake oracle]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 jake localhost.localdomain localhost
192.168.140.100 wall2 dev26 www virt_web
192.168.254.2 wap
192.168.254.1 router
Don't worry about this right now...Quote:
2) Starting HTTP Server
(Error Resolving hostname: localhost)
also show me:
Code:ls -l $ORACLE_HOME/bin/oracle
Hello Jeff,
Here is the result of the command you had asked earlier:
1) ls -lg oracle
-rwsr-s--x 1 oinstall 47881634 Aug 23 09:25 oracle 1
Hope this helps.
PT
I have a feeling you don't know how to follow directions.Quote:
Originally posted by ptreves
Hello Jeff,
Here is the result of the command you had asked earlier:
1) ls -lg oracle
-rwsr-s--x 1 oinstall 47881634 Aug 23 09:25 oracle 1
Hope this helps.
PT
just curious:
is there a version of ULTRAVNC for Internet?
To make life much easier for PTREVES, let him/her install an ULTRAVNC(or other such kind of software), and let Jeff do the work remotely.
:D
Just kiding anyway.:D :D
Sure, no problem. With him I'd get $350 an hour...Quote:
Originally posted by reydp
just curious:
is there a version of ULTRAVNC for Internet?
To make life much easier for PTREVES, let him/her install an ULTRAVNC(or other such kind of software), and let Jeff do the work remotely.
:D
Just kiding anyway.:D :D
Thread split. See http://www.dbasupport.com/forums/sho...threadid=44381 for continuation of linux thread.
Hello Jeff / everyone,
Considering all the issues I am facing at this point, I have decided to upgrade my Red Hat Linux Enterprise 3 server to ES (Enterprise Edition) and reinstall Oracle9i. This is the version certified with Oracle.
I will follow the installation procedure to the letter and take all your comments and feedback to to heart.
I should attempt another reinstallation tomorrow or so.
Wish me luck !!!
PT
PS: All the networking issues with the listener.ora/tnsnames.ora and the host command should still come-up with the upgraded Linux server, since it is still the same box ??
Hello everyone,
Before, I upgrade to ES, I tried playing around and creating a manual DB such as follows, and I got strange error messages :
-----
create controlfile set database 'DEFAULT'
resetlogs noarchivelog
maxlogfiles 16
maxlogmembers 2
maxdatafiles 16
maxinstances 1
maxloghistory 1630
logfile
group 1 '/u01/app/oracle/product/9.2.0.4/oradata/test/redo01.log' size 100k,
group 2 '/u01/app/oracle/product/9.2.0.4/oradata/test/redo02.log' size 100k,
group 3 '/u01/app/oracle/product/9.2.0.4/oradata/test/redo03.log' size 100k
datafile
'/u01/app/oracle/product/9.2.0.4/oradata/test/system01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/undotbs01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/cwmlite01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/drsys01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/example01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/indx01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/odm01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/tools01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/users01.dbf',
'/u01/app/oracle/product/9.2.0.4/oradata/test/xdb01.dbf'
character set WE8MSWIN1252
;
---
ALTER DATABASE OPEN RESETLOGS;
------
------
The first attempt, I got these error:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/u01/app/oracle/product/9.2.0.4/oradata/test/system01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional Information: 3
The second time, I got these erros : (what is a dbs1@dbf file ?)
===== (no datafiles specified)
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '?/dbs/[email protected]'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
PT
PS: I was thinking that I could create a test DB manually and maybe do an DB import afterwards.
You're trying to create a control file, which is wrong. See http://download-west.oracle.com/docs...htm#SQLRF01204 for details.
why you dont RTFM, it's all there about how to create a database, step by step
That would take too much time. He'd rather twiddle around with Linux for 5 days instead of looking at the docs for 1 hr and figure out what's wrong.Quote:
Originally posted by pando
why you dont RTFM, it's all there about how to create a database, step by step
Is this much you are earning Jeff?:)Quote:
Originally posted by marist89
Sure, no problem. With him I'd get $350 an hour...
Can I work as Junior DBA for you and earn that much for 2 days work?
:o :p :o :p
But then you would have to work with Jeff for two days. Is that really worth it? :DQuote:
Originally posted by reydp
Is this much you are earning Jeff?:)
Can I work as Junior DBA for you and earn that much for 2 days work?
:o :p :o :p
At least he wouldn't be in Pittsburgh!http://www.click-smilies.de/sammlung...smiley-034.gif
Somehow Corrupticut is better?http://www.dbasupport.com/forums/ :D
Hello Jeff, everyone,
I have taken note of the numerous replies that you have posted on this thread and have returns to my Linux Server to run some of the commands you have suggested. Here are the results:
1) su - oracle
echo $DISPLAY --> :0.0
which dbca --> /u01/app/oracle/product/9.2.0.4/bin/dbca
grep JRE 'which dbca' --> grep: which dbca: No such file or directory
which java
/usr/bin/which: no java in (/u01/app/oracle/product/9.2.0.4/bin: /usr/kerberos/bin/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/oracle/bin)
cd /usr/local/bin --> coraenv, dbhome, oraenv
java -version
-bash: java: command not found
dbca &
[1] 10302
java.lang.NullPointerException.....
-----
Looking at this output, I get the feelking that either no java JRE is installed on my server or it is not configured ??
I also think there might be a type with the following command grep JRE 'which dbca'. Is this the right command ?
I also tried the following:
grep ^hosts /etc/nsswitch.conf
hosts: files dns
more /etc/hosts
#Do not remove the following lines, or #various programs that require network #functionality will fail.
127.0.0.1 localhost.localdomain localhost
ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 48202927 Aug 23 10:26 /u01/app/oracle/product/9.2.0.4/bin/oracle
=====
Hope this helps ??
PT
Hello again,
Here is my .bash_profile file:
-----
#.bash_profile
#Get the aliases and functions
if { -f ~/.bashrc }; then
. ~/.bashrc
fi
#User specific environment and startup programs
PATH=$PATH:$HOME/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"
export USERNAME BASH_ENV PATH
export LD_ASSUME_KERNEL=2.4.1
export ORACLE_BASE=/opt/oracle
export ORACLE_home=/opt/oracle/product/9.2.0
export ORACLE_SID=ORCL
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERIXA.WE8ISO8859P1
export ORA_NLS33=/ocommon/nls/admin/data
LD_LIBRARY_PATH=/lib:/lib:/usr/lib
LD_LIBRARY_PATH=:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:/bin
export DISPLAY=:0.0
export PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/X11R6/bin:/root/bin:/bin
-----
Hope this helps ?
PT
Hello again,
echo $LD_LIBRARY_PATH
/u01/app/oracle/product/9.2.0.4/lib
hostname
Linux2005
host -l Linux2005
;;Connection to 192.9.200.80#53(192.9.200.80) for Linux2005 failed: connection refused.
host -v Linux2005
Trying "Linux2005"
Host Linux2005 not found: 3(NXDOMAIN)
Received 102 bytes from 192.9.200.80#53 in 187 ms
-----
PT
PT
Hello all,
Here is my .bash_profile file under the oracle user:
su - oracle
more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin; export PATH
#
# Oracle 9i
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/9.2.0.4; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/bin:$PATH; export PATH
ORACLE-OWNER=oracle; export ORACLE_OWNER
ORACLE_SID=ORCL; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib; export CLASSPATH
LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME-kernel
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
unset USERNAME
=====
Hope this helps ?
I set the JRE in the CLASSPATH variable ...
PT
Hello,
QUOTE:
well..do a clean reinstallation...then point ur LD_LIBRARY_PATH to $ORACLE_HOME/lib32 ..then launch DBCA again? see if that helps?
-----
Well, looking at my most recent install, I don't have a lib32 sub-folder under $ORACLE_HOME ? (only lib)
PT
Hello folks,
Here is what I get for:
grep JRE which dbca
----
grep: which: No such file or directory
dbca:JRE_FILE=rt.jar
dbca:JRE_DIR=/u01/app/oracle/product/9.2.0.4/JRE
dbca:JRE_classpath=$JRE_DIR/lib/$JRE_FILE
dbca:I18_CLASSPATH=$JRE_DIR/lib/$I18_FILE
dbca:CLASSPATH=$JRE_CLASSPATH:$I18_CLASSPATH:$DBCA_CLASSPATH:$ASSISTANTS_COMMON_CLASSPATH:4EWT_CLASS PATH:$SHARE_CLASSPATH:$HELP_CLASSPATH:$ICE_BROWSER_CLASSPATH:$KODIAK_CLASSPATH:$SWING_CLASSPATH:$XML PARSER_CLASSPATH:$GSS_CLASSPATH:$JDBC_CLASSPATH:$VISI_CLASSPATH:$NETCFG_CLASSPATH:$SRVM_CLASSPATH:$E M_CLASSPATH
dbca:$JRE_DIR/bin/jre -native -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
dbca:$JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS
-----
PT
PS: Typing which java---> no java ...???
You should not try to install Oracle 9i on Linux/Unix without making sure that the JRE is installed correctly. Once this is done and verified, then you can install Oracle.
Here is a site that should have the proper JRE version, assuming that you are running linux on a x86 box.
ftp://metalab.unc.edu/pub/linux/deve...1.1.8/i386/v3/
Then you need to work through the before you install guide and make sure that you have done everything.
http://download-west.oracle.com/docs....htm#sthref101
Then and only then install Oracle. If you did all of the above, you would have a working database by now.
Although you could be missing a patch for Red Hat, so check that too.
I think ptreves is a mole from the SQL Server crowd. How can a single person have so much trouble installing Oracle? Have you seen anyone else anywhere else have this much trouble? I haven't.
how do you know he isn't a mole from the DB2 crowd? I think that he is trying to get someone to utter the magic phrase that will make everything work, so that he doesn't have to learn how to correctly install Oracle.Quote:
Originally posted by stecal
I think ptreves is a mole from the SQL Server crowd. How can a single person have so much trouble installing Oracle? Have you seen anyone else anywhere else have this much trouble? I haven't.
Ptreves, if you still can't get it try a Windows install, it should be easier. you can also take an Oracle Admin class at your local community college.
ORACLE-OWNER=oracle; export ORACLE_OWNER
LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME-kernel
not exporting them properly
and its
export LD_ASSUME_KERNEL=2.4.19 not 2.4.1
Hello everyone,
Rest assured I am not a mole.
I am slowly getting a handle on the problems behing my installation issues. Going through the documentation that was pointed out to me, it is stated:
1) chmod u+x j2sdk-1_3_1_09-linux-i586.rpm.bin
./j2sdk-1_3_1_09-linux-i586.rpm.bin
rpm -ivh jdk-1.3.1_09.i586.rpm
I made sure that the jdk-1.3.1_09.i586.rpm was installed on my Linux Server. Even installed, running 'which java', I get no java....
1) How should I go about installing the files you have mentionned to me ? (extension tar.bz2 ??)
PT
PS: On top of the java PB, I still have a problem with the internet host table. I think that my Linux Server (called Linux2005) is not included in the /etc/hosts file ??
you know you dont actually NEED to install a separate JRE to get oracle working.
Hello,
I am getting confused here.
1) Why am I getting a no java message when I type: which java ?
2) When I type java -version, I get nothing ?
3) How can I go about resolving this issue ?
4) How can I use those files, mentionned to me with the tar.bz2 extension ?
PT