This forum is currently locked. You can't register or post questions at this time. (read more)

bash_profile

All posts relating to Oracle database administration.

Moderator: Tim...

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Tue Jan 21, 2014 1:42 pm

Hello Sir, When I run my bash profile its giving the following error

[oracle1@localhost ~]$ . .bash_profile
bash: export: `0RACLE_HOME=/home/oracle1/app/oracle1/product/11.1.0/db_1': not a valid identifier

The following are the contents of my bash profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
export 0RACLE_HOME=/home/oracle1/app/oracle1/product/11.1.0/db_1
export ORACLE_SID=peers
PATH=$PATH:$0RACLE_HOME/bin

export PATH
unset USERNAME
~
~
~
~
~
~
~
~
~
".bash_profile" 14L, 286C

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Tue Jan 21, 2014 2:10 pm

Hi.

It looks like you've got a zero instead of an O in ORACLE_HOME...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Tue Jan 21, 2014 2:42 pm

Thank you Sir.. What you said was absolutely right...

After that i start my database i come across following

[oracle1@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 21 17:34:04 2014

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle1/app/oracle1/product/11.1.0/db_1/dbs/initpeers.ora'


Here my SID is peers and i dont have initpeers.ora and i dont have my parameter file in my dbs directory

[oracle1@localhost ~]$ cd $ORACLE_HOME/dbs
[oracle1@localhost dbs]$ ls -ltr
total 36
-rw-r--r-- 1 oracle1 dba 8385 Sep 11 1998 init.ora
-rw-r--r-- 1 oracle1 dba 12920 May 3 2001 initdw.ora

My paramerter file shall be initpeers.ora but i dont find it..

Thanks..

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Tue Jan 21, 2014 4:16 pm

Hi.

Can you tell me if there is a file called spfilepeers.ora in the dbs directory?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Tue Jan 21, 2014 4:45 pm

No Sir its is not there in the dbs dir.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Tue Jan 21, 2014 5:25 pm

Hi.

The it does not appear that you have created a database called "peers", or it would be there. What does the following command produce?

Code: Select all

ps -ef | grep [s]mon


Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Wed Jan 22, 2014 4:27 am

the output of the command is

[oracle1@localhost ~]$ ps -ef | grep smon
oracle1 32703 32425 0 07:09 pts/1 00:00:00 grep smon

Yeah Sir there is no database running in the background as i have not created database. I am going to create it manually and configure parameter file manually..

Thanks for your kind help

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Wed Jan 22, 2014 6:11 am

Hello Sir, I have created parameter file manually and after that i am starting the database and when i start it i get the following

[oracle1@localhost dbs]$ export ORACLE_SID=peers
[oracle1@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 22 09:01:11 2014

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORA-00371: not enough shared pool memory, should be atleast 102341017 bytes

here are the contents of my parameter file which i configured manually

#db_name=peers
shared_pool_size = 112341017
control_files = ('/home/oracle1/app/oracle1/oradata/prd/control01.ctl', '/home/oracle1/app/oracle1/oradata/prd/control02.ctl')
compatible=11.1.0
undo_management=auto

The shared pool size is more than the required asked by oracle

Thanks...

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Wed Jan 22, 2014 3:29 pm

Hi.

Funny message. :)

I would suggest you do not specify the shared pool. Instead, specify just the SGA_TARGET and PGA_AGGREGATE_TARGET. Let the database decide hwo to subdivide that memory.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Wed Jan 22, 2014 5:17 pm

Hi sir, I did it and it is as follows

#db_name=peers
pga_aggregate_target=300M
sga_target=400M
control_files=(/home/oracle/app/oracle/oradata/prd/control01.ctl',/home/oracle/app/oracle/oradata/prd/control02.ctl')
compatible=11.1.0

AND THEN

SQL> startup
ORA-01078: failure in processing system parameters
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

And I TRIED THIS WAY ALSO

startup pfile='/home/oracle/app/oracle/product/11.1.0/db_1/dbs/inittest.ora'
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
ORA-01078: failure in processing system parameters

Thanks..
Last edited by syedhafeez69 on Wed Jan 22, 2014 5:25 pm, edited 1 time in total.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Wed Jan 22, 2014 5:21 pm

Hi.

That error message tells you to look in the alert log for more information. Have you done that?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Wed Jan 22, 2014 5:30 pm

Hi Sir.

Sorry Sir i donot know to check it..
how to do so ?

Thanks

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Wed Jan 22, 2014 5:41 pm

Hi.

Let's assume you set your ORACLE_BASE to "/u01/app/oracle" and your database was called "peers". I would expect the file to be something like this.

Code: Select all

$ORACLE_BASE/diag/rdbms/peers/peers/trace/alert_peers.log


Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

syedhafeez69
Senior Member
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby syedhafeez69 » Thu Jan 23, 2014 4:30 am

Hi sir...

[oracle@localhost ~]$ /home/oracle/app/oracle/diag/rdbms/prd/prd/trace/alert_prd.log
-bash: /home/oracle/app/oracle/diag/rdbms/prd/prd/trace/alert_prd.log: Permission denied

Why is this permission denied

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: bash_profile

Postby Tim... » Thu Jan 23, 2014 8:10 am

Hi.

I have no idea. Check the ownership is oracle:oinstall for all the files and check that your oracle user is actually part of the oinstall group.

More importantly, you are looking at an alert log for a database named "prd", yet you have been setting your ORACLE_SID to "peers". You really have to take a step back and understand what it is you are trying to achieve here.

You said it was called "peers", but you had no initpeers.ora or spfilepeers.ora, which suggested you never really created that database. Then you are looking at an alert log for a database called "prd". None of this fills me with confidence that you actually know what the database is called. Perhaps it would be better to create a new database with the "dbca" and write down what you call it and all the paths you pick during the installation, so you are not wasting your time and mine!

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 3 guests

cron