| Oracle 9i on Linux Red Hat 9 - Problems [message #111881] |
Mon, 21 March 2005 08:16  |
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 #111935 is a reply to message #111900] |
Mon, 21 March 2005 23:38  |
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- Mahesh Please Help [message #112264 is a reply to message #112030] |
Thu, 24 March 2005 00:33 |
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 |
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: dbca started - db creation 100% but alas [message #112513 is a reply to message #112473] |
Sat, 26 March 2005 07:53 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Pratap