bash_profile

[Tim...]

Hi.

Well, I'm not sure why you have an sqlplus in the ORACLE_HOME, but I can see now why your path is not working.

You have your ORACLE_HOME set to this.

Code: Select all

/home/oracle/app/oracle/product/11.1.0./db_1

The path from the find command is this.

Code: Select all

/home/oracle/app/oracle/product/11.1.0/db_1

You have an extra "." after the "11.1.0" in the value.

Fix than and it should work.

Cheers

Tim...

[syedhafeez69]

ok tim sir i got it right with the dot(.)
and now when i am running sqlplus and after that when i want to go the the parameter file location with the command (cd $ORACLE_HOME/dbs)
the error is
{SP2-0734: unknown command beginning "cd $ORACLE..." - rest of line ignored.}

and when i want to see my redolog and control files with the command {select name from v$controlfiles;} and {select name from v$datafiles;}
the error is

ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

thanks for helping and very sorry for troubling u sir..

[Tim...]

Hi.

Regarding the first error, it looks like you are trying to run "cd $ORACLE_HOME/dbs" from inside sqlplus. You can't do that as this is a UNIX/Linux command, not a sqlplus command.

If you want to move into that directory, switch to it before opening sqlplus.

Regarding the second error, it looks to me like Oracle is not started yet. Make sure you have edited the "/etc/oratab" file as described in this article.

http://www.oracle-base.com/articles/11g ... stallation

Then start and stop the database using the following command line utilities. This is *not* from within sqlplus.

Code: Select all

$ dbstart $ORACLE_HOME
$ dbshut $ORACLE_HOME

Cheers

Tim...

[syedhafeez69]

thanks a lot sir, thanks a lott...

[syedhafeez69]

Tim sir, when i am starting sqlplus and when i want to see the redolog and control files with the command {select name from v$controlfiles;} and {select name from v$datafiles;}
i am getting the same error

{ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0}

even after starting and shutting the database...

[Tim...]

Hi.

That means the database has not started. What is the result of this command?

Code: Select all

ps -ef | grep smon

Cheers

Tim...

[syedhafeez69]

The result of the command { ps -ef | grep smon } is

oracle 11624 11564 0 02:07 pts/1 00:00:00 grep smon

[Tim...]

Hi.

That means you didn't actually start the database. This means one of a couple of things:

1) You did not edit your "/etc/oratab" file correctly.
2) You didn't call dbstart correctly.

Please post the contents of your "/etc/oratab" file. Making sure it has the correct path to the ORACLE_HOME and the correct ORACLE_SID defined in it.

Cheers

Tim...

[syedhafeez69]

The contents of /etc/oratab are...

{#



# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
prd:/home/oracle/app/oracle/product/11.1.0/db_1:Y
"/etc/oratab" 23L, 728C }

[syedhafeez69]

The above are the contents of /etc/oratab.. Again i have started and shut the database with the commands { $ dbstart $ORACLE_HOME $ dbshut $ORACLE_HOME } respectively.. I get the same error...

[Tim...]

Hi.

Look at the first entry in this file. You have a SID of prd, when previously you said your SID was test.

Looks to me like you have the wrong information in the file, which is why the database won't start properly.

You must pay attention if you ever want to understand how to use oracle.

Cheers

Tim...

[syedhafeez69]

ok here is my /etc/oratab file after editing

#



# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
test:/home/oracle/app/oracle/product/11.1.0/db_1:Y
"/etc/oratab" 23L, 729C


after that i have start and shut database then i run sqlplus and then when i want to see my redolg files its the same error as above..

[syedhafeez69]

Tim sir... my SID is "test" and when i type {echo $ORACLE_SID} its giving the name as {test}.. and when i see my parameter file with the command {$ORACLE_HOME/dbs}
my pfile is {spfileprd.ora}... I think it should be {spfiletest.ora} acccording to my SID name.. How to change it.. ? ? ?

[Tim...]

Hi.

Create a pfile from the spfile. Create a new spfile from the pfile.

create pfile='/tmp/pfile.txt' from spfile='/path/to/prdspfile.ora';
create spfile from pfile='/tmp/pfile.txt';

Cheers

Tim...

[syedhafeez69]

When i go with the first one {create pfile='/tmp/pfile.txt' from spfile='/path/to/prdspfile.ora';} the error is

ERROR at line 1:
ORA-01565: error in identifying file '/path/to/prdspfile.ora'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

and for the second {create spfile from pfile='/tmp/pfile.txt';} the error is

ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/tmp/pfile.txt'..

I am extremely sorry for troubling you Tim sir, as I don't have any source of help other than you... Please help me...