bash_profile

All posts relating to Oracle database administration.

Moderator: Tim...

Re: bash_profile

Postby Tim... » Thu Nov 07, 2013 4:25 pm

Hi.

Not in SQL*Plus. On the command line.

So if the output from this command was nothing, then it means Oracle is not started.

Code: Select all
[oracle@localhost ~]$ ps -ef | grep [s]mon


That is why you can't do anything with the database. It is not turned on.

Assuming the SId you used is ORCL, you need to do the following:

Code: Select all
$ export ORACLE_SID=ORCL
$ sqlplus / as sysdba


When you are in SQL*Plus you need to do the following:

Code: Select all
SQL> startup


If you are running on Linux and want to automate the startup/shutdown, you need to do the following:

http://www.oracle-base.com/articles/lin ... -linux.php

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Fri Nov 08, 2013 4:28 am

Hi Sir,
When i am starting up the database the error is

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

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

Re: bash_profile

Postby Tim... » Fri Nov 08, 2013 8:28 am

Hi.

Read that error message and tell me what you think you should do now to investigate it...

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Fri Nov 08, 2013 3:33 pm

Do I need to start the parameter file ?
syedhafeez69
Senior Member
 
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby Tim... » Fri Nov 08, 2013 3:43 pm

Hi.

The error message says, "could not open parameter file". That would instantly make me check the location to see if the parameter file is there, and if not, what other parameter files are in the directory.

You are currently looking for "inittest.ora", which suggests your SID is "test". Did you create a database with the SID of "test"?

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Sun Dec 22, 2013 5:37 am

hi,

Yeah my SID is "test".. I get the same error after starting the database
syedhafeez69
Senior Member
 
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby Tim... » Sun Dec 22, 2013 8:16 am

Hi.

An did you check that inittest.ora is present in the ORACLE_HOME/dbs directory, as I asked?

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Sun Dec 22, 2013 12:58 pm

[oracle@localhost ~]$ cd $ORACLE_HOME/dbs
[oracle@localhost dbs]$ ls
hc_prd.dat initdw.ora init.ora lkPRD orapwprd

No sir it is not present
syedhafeez69
Senior Member
 
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby Tim... » Sun Dec 22, 2013 1:41 pm

Hi.

OK. So the error message was totally correct. You do not have an inittest.ora or an spfiletest.ora in that directory, it is impossible for a database instance called "test" to be started. Furthermore, I would suggest that if either of those files is not present, it means you did not create the database. If you did, the DBCA would create one of them in that 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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Tue Jan 07, 2014 4:55 pm

Hi Sir,

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jan 7 23:21:53 2014

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

Connected to an idle instance.

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

AFTER RESIZING THE SHARED POOL SIZE ALSO ITS GIVING THE SAME ERROR..
THANKS...
syedhafeez69
Senior Member
 
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby Tim... » Wed Jan 08, 2014 7:33 am

Hi.

So make it bigger. When an error message actually tells you to do something is wrong, your natural reaction should be to fix that thing...

Why is your SHARED_POOL_SIZE being set anyway? You are on 10g. You should be using PGA_AGGREGATE_TARGET and SGA_TARGET.

http://www.oracle-base.com/articles/9i/ ... Management
http://www.oracle-base.com/articles/10g ... management

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Tue Jan 21, 2014 11:12 am

Hello Sir.. I have installed oracle and after installation when i type ls command i see the foolowing

[oracle1@localhost ~]$ ls
app Desktop oraInventory

Instead of

[oracle@localhost ~]$ ls
app Desktop diag inittest.ora oradiag_oracle oraInventory

Why is this error Sir ?
Thanks
syedhafeez69
Senior Member
 
Posts: 51
Joined: Thu Dec 27, 2012 11:37 am

Re: bash_profile

Postby Tim... » Tue Jan 21, 2014 11:33 am

Hi.

It looks like you are in the "oracle" user's home directory, so you would not expect to the see the installation there. If you have followed the installation I did, the "oracle" users home directory is,

Code: Select all
/home/oracle


but the software was loaded below,

Code: Select all
/u01/app/oracle


If you want to look at the contents of the installation, you will need to either "ls" the installation location, or "cd" into it and run an "ls".

Code: Select all
ls /u01/app/oracle

# or

cd /u01/app/oracle
ls


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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: bash_profile

Postby syedhafeez69 » Tue Jan 21, 2014 11:50 am

Hello Sir..

I tried this

[oracle1@localhost ~]$ cd /mnt/hgfs/Oracle
[oracle1@localhost Oracle]$ ls -ltr
total 6
drwxrwxrwx 1 root root 0 Oct 29 15:53 DBA
drwxrwxrwx 1 root root 0 Oct 29 15:53 Oracle11g
drwxrwxrwx 1 root root 0 Oct 29 15:54 Videos
drwxrwxrwx 1 root root 0 Oct 29 15:55 Windows
drwxrwxrwx 1 root root 12288 Jan 4 08:55 Documents
[oracle1@localhost Oracle]$ cd DBA
[oracle1@localhost DBA]$ ls -ltr
total 2052526
-rwxrwxrwx 1 root root 1844527800 Dec 17 2008 linux_11gR1_database_1013.zip
-rwxrwxrwx 1 root root 2359033856 Jun 3 2011 linux.iso
-rwxrwxrwx 1 root root 2794 May 9 2013 hotbackup.txt
-rwxrwxrwx 1 root root 496 May 9 2013 datapump.txt
-rwxrwxrwx 1 root root 323 May 9 2013 cold backup.txt
-rwxrwxrwx 1 root root 3539 May 16 2013 dg using physical file.txt
-rwxrwxrwx 1 root root 431 May 16 2013 rman.txt
-rwxrwxrwx 1 root root 791 May 16 2013 restore to specific scn.txt
drwxrwxrwx 1 root root 0 Oct 29 15:51 database
drwxrwxrwx 1 root root 0 Oct 29 15:53 DBA
drwxrwxrwx 1 root root 0 Oct 29 15:53 VMware Workstation 8.0.1
[oracle1@localhost DBA]$ cd database
[oracle1@localhost database]$ ls -ltr
total 5
-rwxrwxrwx 1 root root 4835 Sep 26 2008 welcome.html
-rwxrwxrwx 1 root root 2911 Sep 26 2008 runInstaller
-rwxrwxrwx 1 root root 124 Oct 6 2008 README
drwxrwxrwx 1 root root 0 Oct 29 15:51 doc
drwxrwxrwx 1 root root 0 Oct 29 15:51 install
drwxrwxrwx 1 root root 0 Oct 29 15:53 stage
[oracle1@localhost database]$ ls
doc install README runInstaller stage welcome.html
[oracle1@localhost database]$

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

Re: bash_profile

Postby Tim... » Tue Jan 21, 2014 12:34 pm

Hi.

You know where you installed the stuff. You typed in an installation location when you did the installation. I can't tell you what you typed in...

I don't know what you expect me to do. Use telepathy? :)

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
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

PreviousNext

Return to Oracle Database Administration

Who is online

Users browsing this forum: kfoster and 1 guest