Home » RDBMS Server » Enterprise Manager » Oracle 9i on Linux Red Hat 9 - Problems
Oracle 9i on Linux Red Hat 9 - Problems [message #111881] Mon, 21 March 2005 08:16 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
i have installed oracle9i version 9.2.0.1.0 (Entrprise Edition)on Linux Red Hat 9
with ORACLE_HOME AS /oradir/OraHome (i created /oradir mount point with 3000mb space)
i gave insatnce name as DB02 (and db_domain as world) for starter database during installation
after database is created
$ /oradir/OraHome/bin/sqlplus
Enter user-name: sys/ as sysdba
Connected to an idle instance

then i searched for initDB02.ora file or any spfile with DB02 as substring in it. but could not found
there were only 3 init.ora files as
./OraHome/hs/admin/inithsodbc.ora
./OraHome/dbs/init.ora
./OraHome/dbs/initdw.ora
then i copied
./OraHome/dbs/init.ora
to
./OraHome/dbs/initDB02.ora
SQL>startup pfile=/oradir/OraHome/dbs/initDB02.ora
ORACLE instane started
Total System Global Area 42741800
Fixed Size
Variable Size
Database Buffers
Redo Buffers
ORA-00205: error in identifying controlfile, check alert log for more info
then i found alertSId.log in
./OraHome/rdbms/log/alert_DB02.log
with control file identification error in it.
The db_name in it was proper i.e. DB02
now i am unable to find any folders e.g. udump,bdump,cdump,oradata and not even any file or folder with DB02* name.
how do i find my control file and put the path in my initDB02.ora as created above?
also whether my control and data files are not created?(space and permissions are checked and are proper)
or Do i need any setting to view them?
i have set
ORACLE_HOME=/oradir/OraHome
ORACLE_SID=DB02
Do i need to run any Post-Installtion script for this
the links
http://www.linuxdevcenter.com/pub/a/linux/2003/09/04/oracle_install.html?page=2
http://www.oracle-base.com/articles/9i/Oracle9iInstallationOnRedHat9.php
advise to execute following after Installation
cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk install
but this too gives following error
ins_net_client.mk:23: /network/lib/env_network.mk No such file or directory
make: *** No rule to make target '/network/lib/env_network.mk'. Stop

however
/network/lib/env_network.mk exists in the lib folder and i gave a+w,a+x permissions on it as well as on lib itself.
what could be the issue?dbca is also not working
bin$ ./dbca
SIGSEGV 11* segmentation violation
stackbase=0x453d0000 stackpointer=0x453cfd5c
...
...

Kindly advice
Thanks in Advance.
Pratap

Re: Oracle 9i on Linux Red Hat 9 - Problems [message #111900 is a reply to message #111881] Mon, 21 March 2005 12:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you follow all the steps told?

i am not seeing ORACLE_BASE in your posting.
are semaphores properly set?
first Do a proper installation of oracle.
then you can create the database.

startup pfile option will try to open an existing database.
do you have one?

Please go through http://www.puschitz.com/
Re: Oracle 9i on Linux Red Hat 9 - Problems [message #111935 is a reply to message #111900] Mon, 21 March 2005 23:38 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
Is Setting semaphors is must?
please correct me for : The environment variables are set during installation.e.g. during installation, user is asked to give ORACLE Home
and if i am wrong here, please advice me how i will give ORACLE_HOME AND oracle_base?
also shall i mention that in .profile or only will set on conssole?

if i will be installing oracle under /oradir which a mount point created with 3000 mb space?
ORACLE_HOME=?
ORACLE_BASE=?
also do i need to create directories before installation for ORACLE_HOME AND ORACLE_BASE?
if patches are required only for Red Hat Advance Server? In that case if i am not having registration with metalink then what is alternative?

Finally..
in my case (earlier post), what could be the reason that 'i am unable to see datafiles and control files'
the instance is starting with nomount proprly using sys user.

Thanks in Advance
Pratap
Re: Oracle 9i on Linux Red Hat 9 - Problems [message #112030 is a reply to message #111935] Tue, 22 March 2005 08:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is Setting semaphors is must?
Ofcourse yes.
>>please correct me for : The environment variables are set during installation.e.g. during installation, user is asked to give ORACLE Home
and if i am wrong here, please advice me how i will give ORACLE_HOME AND oracle_base?
also shall i mention that in .profile or only will set on conssole?

It is all set in the profile.
The one your prompted for during installation in runInstaller IS name for ORACLE_HOME for inventory not the value for ORACLE_HOME.
ORACLE_BASE is also set in profile.
>>
if i will be installing oracle under /oradir which a mount point created with 3000 mb space?
ORACLE_HOME=?
ORACLE_BASE=?
also do i need to create directories before installation for ORACLE_HOME AND ORACLE_BASE?


DId you read the http://www.puschitz.com/ docs?
the author has given extensive documentation.
PLEASE GO THROUGH IT.
Oracle recomends something called as OFA ( oracle flexible architecture) which nothing but a standard naming convention for directories.

You can have antyhing you want ( Below is just an example)
/oracledir/admin is ORACLE_BASE
/oracledir/product/version is ORACLE_HOME

>> patches are required only for Red Hat Advance Server? In that case if i am not having registration with metalink then what is alternative?
Might be available in some portals.
GOOGLE for it.

>>Finally..
in my case (earlier post), what could be the reason that 'i am unable to see datafiles and control files'
the instance is starting with nomount proprly using sys user.

FIrst your installation is not proper.
second you have not yet created the database.
and you have NOT issues startup nomount.
startup pfile='pfile' assumes an exisiting database.
So there is no datafiles/ control files available.

oracle in linux / unix depends on lot of little thingies.

Re: Oracle 9i on Linux Red Hat 9 - Problems [message #112097 is a reply to message #112030] Tue, 22 March 2005 23:04 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Thank u very much for the reply and the reference URL of puschitz.
i shall reload the software and reply to you.


Best Regards,
Pratap

Re: Oracle 9i on Linux Red Hat 9 - Problems- Mahesh Please Help [message #112264 is a reply to message #112030] Thu, 24 March 2005 00:33 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
Below mentioned are the list of things i have done.
Things went fine for Installation but after that .. problems
I have really struggled a lot for this(right from getting CDs:(

Now seems things are closer, once again i need your help!!
please advice
I am trying Oracle 9.2.0.1.0 on Red Hat 9

Checked Memory
grep MemTotal /proc/meminfo : found proper

Checked Swap space
cat /proc/swaps : found proper

set Shared Memory
echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf

checked the space in /tmp
$ df /tmp : found adequate

Oracle Disk Space
/oradir mount point with 3GB space

checked Development Packages
rpm -q gcc cpp compat-libstdc++ glibc-devel glibc-kernheaders binutils

Created Oracle user Account
su - root
groupadd dba # group of users to be granted with SYSDBA system privilege
groupadd oinstall # group owner of Oracle files
useradd -c "Oracle software owner" -g oinstall -G dba oracle
passwd oracle

Created Oracle Directories
su - root
mkdir /oradir/oracle
mkdir /oradir/oracle/product
mkdir /oradir/oracle/product/9.2.0
chown -R oracle.oinstall /oradir/oracle

Following not created as i was not having /var mount point
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle


Added Following Environment variables in .bash_profiles of oracle user and confirmed by relogging and 'set' as well as echo
export LD_ASSUME_KERNEL=2.4.1

export ORACLE_BASE=/oradir/oracle
export ORACLE_HOME=/oradir/oracle/product/9.2.0
export ORACLE_SID=SAKET
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH

Now, i relogged in and checked environment variables are proper

put CD 1 Of 3 ->the OUI started Properly
ORacle Home Name : j
Oracle Home Path : /oradir/oracle/product/9.2.0.1.0 (was selected by default)

Privileged Operating System Groups :dba (i kept the default)
Oracle Managent Server Repository: New i selected
Create database : No


The Error1 (resolved finally)
-----------------------------
"Error in invoking target install of makefile /opt/oracle/product/9.2.0/ctx/lib/ins_ctx.mk"
adding "`cat $(LIBHOME)/sysliblist`" string to $ORACLE_HOME/ctx/lib/env_ctx.mk and clicking 'Retry' resolved it
INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m `cat $(LIBHOME)/sysliblist` $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)

Then
Database Creation complete successful
Link Successful
Network Services Successful

Then Error2 (unresolved)
-------------------------
the attemp to create a database for the enterprise manager repository failed, because:
The command:
"/oradir/oracle/product/9.2.0.1.0/bin/dbca -
progress_only -emca_interrnal -createDatabase -
templateName Transaction_Processing.dbc -
gdbName OEMREP.localdomain -sid OEMREP"
RETURNED STATUS: 137


Here i finished installation thinking that i will go for OEM stuff later point of time.

Then Error3 (unresolved)
--------------------------
then tried to start dbca
dbca
SIGSEGV 11* segmentation violation
stackbase stackpointer
Full thread:
..
..
..
/oradir/oracle/product/9.2.0.1.0/bin/dbca: line 124: 3170 killed $JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -classpath $CLASSPATH..........
oracle.sysman.assistants.dbca.Dbca $ARGUMENTS

I executed the ipcs command to get the address of the shared memory segments that have been allocated by Oracle:
$ su - root
# ipcs

But there was no entry with 'oracle' as owner name.

Then Error4 (unresolved)
------------------------
Then Tried lsnrctl
lsnrctl status
.. Got an error
According to puschitz.com

su - root
mkdir /var/tmp/.oracle
chown oracle:dba /var/tmp/.oracle
Now try to run lsnrctl start as oracle again.
But i do not have /var
What to do here?
------------------

Here i am stuck up, i struggled a lot last few days.
success seems closer but how to get it.

Here again i need your advice
puschitz.com asks for patches for RH As not for RH. so how to proceed are any patches required for RH 9 also or same as RH As.
if yes can you help me in getting URL.


Please suggest
Thanks in Advance
Pratap

Re: Oracle 9i on Linux Red Hat 9 - Problems- Mahesh Please Help [message #112266 is a reply to message #112264] Thu, 24 March 2005 00:37 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
this is an addition to my recent earlier mail
i also set semaphors by
Adding following lines to the /etc/sysctl.conf file:

kernel.shmmax = 2147483648
kernel.shmmni = 128
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

Kindly Reply

Best Regards,
Pratap
Re: Oracle 9i on Linux Red Hat 9 - Problems- Mahesh Please Help [message #112331 is a reply to message #112266] Thu, 24 March 2005 08:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
before invoking dbca
set this ENV variable and try again.

THREADS_FLAG=native
dbca started - db creation 100% but alas [message #112472 is a reply to message #112331] Fri, 25 March 2005 14:10 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Great and Great!!!
dbca started properly.
Many thanks to you.


very happy indeed.

set the THREADS_FLAG=native - started dbca
datbase creation completed with 100% - then it shown password management - unnecesarrily i clicked button for displaying the pasword management - seeing all password and locked password -click ok- and then...

then both DBCA screens the main one (showing various screen 1 of 7 to 7 of 7) and the smaller one showing progress of database creation 100%. both were cleared i.e. only title bars of the screen were visible.and all controls and text in working area was invisible.
i thought it must me memory problem. so first i changed the screens to other workspace but no results .
the i tried to change priority of the services but no results - still the screens are left as it is - with my pc on

can u suggest somethings things are closer and on last moment i am loosing everything it seems..

please suggest
Thanks in Advance
http://C:\Documents and Settings\Administrator\Desktop/dbca_problem.bmpPratap
Re: dbca started - db creation 100% but alas [message #112473 is a reply to message #112472] Fri, 25 March 2005 14:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I am not able to visualize it exactly.
must be somekind of minor issue that you can ignore and startover.

>>can u suggest somethings things are closer and on last moment i am loosing everything it seems..
just startover.
reboot the machine.
login as oracle.
start and mount the instance.
( set your ORACLE_SID etc.
use sqlplus to startup logged in sys/password as sysdba.
if the spfile is not yet initilaized and complians about pfile
use pfile to mount and open the database.)

hope everything works cool.
else
NO BIG DEAL.
do it again ( installation & dbcreation). More you break, more you are goin to learn.
Oracle is not black magic or something to fear about.

Re: dbca started - db creation 100% but alas [message #112513 is a reply to message #112473] Sat, 26 March 2005 07:53 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Mahesh,
finally done!!
Many thanks to you.
now being successful in this installation(17:55 IST) with your help, i am ready to help others for this.
even somebody needs CDs please refer my name.

The first installation gave problem i again installed Os with little large parameters.
now part from other problems i faced earlier new one were,
1)Segmentation fault - here i used "ipcrm shm" as guided in "puschitz "
2)second was for character set problem- which was resolved when i removed parameters NLS_LANG and ORA_NLS33 from .bash_profile.

Hope now i will not face trouble agai restarting the database.

Once again thanks to you.

Sincerely,
Pratap
Re: Oracle 9i on Linux Red Hat 9 - Problems- Mahesh Please Help [message #145065 is a reply to message #112331] Mon, 31 October 2005 13:23 Go to previous message
saustin
Messages: 43
Registered: June 2003
Member
Thank you Mahesh for this very helpfull post !!!

Steve.
Previous Topic: A problem when executing PL/SQL in Oracle 8i Database release 3. URGENT !!!
Next Topic: OEM Grid Control of 10.2
Goto Forum:
  


Current Time: Thu Mar 28 14:52:00 CDT 2024