Home » Infrastructure » Linux » Not able to connect SQLPLUS in Susi Linux OS (Oracle 11G, 1.2, Susi Linux)
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664776 is a reply to message #664775] Wed, 02 August 2017 23:52 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
chrisindya wrote on Wed, 02 August 2017 23:39
Hi Michel,

Results of the same commands with "oracle" user as below.

Copyright (c) 1982, 2009, 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/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
SQL> connect system/system_tpt
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Warning: You are no longer connected to ORACLE.
SQL> startup
ORA-01031: insufficient privileges
SQL> 

Please find the spfile attached..
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664777 is a reply to message #664775] Thu, 03 August 2017 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 66721
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Your spfile is corrupted
2/ Delete it
3/ Download the initoracle.ora attached file and put it in /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/
4/ Startup (connected as SYS)

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664778 is a reply to message #664777] Thu, 03 August 2017 00:57 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
Hi Michel,

Thanks for helping me..

I deleted the spfileoracle.ora and pasted the given initoracle.ora

Then I tried to connect as SYS in SQL*PLUS

below error is throwing..

oracle@ip-10-13-228-206:/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin> ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 3 11:16:41 2017

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

Connected to an idle instance.

SQL> connect sys    
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Warning: You are no longer connected to ORACLE.
SQL> 

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664779 is a reply to message #664778] Thu, 03 August 2017 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 66721
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

When you connect with SYS you must specified AS SYSDBA, or if prefer just "/ AS SYSDBA" (without the ").
This is a basic of database administration.
I advise you to read:
Database Concepts
2 Day DBA
Administrator's Guide

[Updated on: Thu, 03 August 2017 01:07]

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664780 is a reply to message #664779] Thu, 03 August 2017 01:28 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
Ok Sure Michel, Thanks a lot for your help and support.. Now Database Opened and Instance Started Successfully, I can able to connect via SQL Developer too..

oracle@ip-10-13-228-206:/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin> ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 3 11:45:43 2017

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

Connected to an idle instance.

SQL> connect sys as sysdba
Enter password: 
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 6480490496 bytes
Fixed Size                  2213816 bytes
Variable Size            3489663048 bytes
Database Buffers         2952790016 bytes
Redo Buffers               35823616 bytes
Database mounted.
Database opened.
SQL> 

Regards,
Christo
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664781 is a reply to message #664780] Thu, 03 August 2017 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 66721
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Now create a spfile from your pfile, rename the pfile and restart the database:
create spfile='/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/spfileoracle.ora' 
from pfile='/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora';

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664782 is a reply to message #664781] Thu, 03 August 2017 03:11 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
Ok Michel, Thanks
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664783 is a reply to message #664781] Thu, 03 August 2017 03:44 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
Michel Cadot wrote on Thu, 03 August 2017 01:36

Now create a spfile from your pfile, rename the pfile and restart the database:
create spfile='/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/spfileoracle.ora' 
from pfile='/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora';

Hi Michel,

I followed the steps you mentioned and created a spfile from the pfile and started the database. Now the database is connected and working.

Thanks again...
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664784 is a reply to message #664775] Thu, 03 August 2017 06:50 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
Quote:

LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
What do you suppose that means?

do the following commands, then copy and paste the entire session, commands and responses.

ls /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora
cat /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora

BTW, installing oracle under the /home directory was not the best place to put it. Almost universally, on *nix systems, we install at /u01/app/oracle/product/<version>/dbhome_<n>.
I'm really beginning to believe you never really read the Installation Guide.
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664787 is a reply to message #664784] Thu, 03 August 2017 07:38 Go to previous messageGo to next message
chrisindya
Messages: 33
Registered: July 2017
Member
EdStevens wrote on Thu, 03 August 2017 06:50
Quote:

LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
What do you suppose that means?

do the following commands, then copy and paste the entire session, commands and responses.

ls /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora
cat /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora

BTW, installing oracle under the /home directory was not the best place to put it. Almost universally, on *nix systems, we install at /u01/app/oracle/product/<version>/dbhome_<n>.
I'm really beginning to believe you never really read the Installation Guide.

OK, Thanks for helping me Stevens.. Now the Database connecting error resolved, and the db server is up and running..
Re: Not able to connect SQLPLUS in Susi Linux OS [message #664898 is a reply to message #664775] Thu, 10 August 2017 06:23 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
chrisindya wrote on Wed, 02 August 2017 23:39
Hi Michel,

Results of the same commands with "oracle" user as below.

Copyright (c) 1982, 2009, 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/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
SQL> connect system/system_tpt
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


Warning: You are no longer connected to ORACLE.
SQL> startup
ORA-01031: insufficient privileges
SQL> 

I see three consecutive 'startup' commands, all - as expected - with the same response.
The definition of insanity is doing the same thing over and over and expecting a different outcome.

Show us the following commands:

ls -l /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora
cat /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora
env | grep ORA

BTW, I would NOT have installed my ORACLE_HOME under /home. The 'home' directory of the oracle owner is not the same concept as ORACLE_HOME.
Re: Not able to connect SQLPLUS in Susi Linux OS [message #665131 is a reply to message #664784] Tue, 22 August 2017 20:04 Go to previous messageGo to next message
DannyEm
Messages: 2
Registered: August 2017
Junior Member
EdStevens wrote on Thu, 03 August 2017 06:50
Quote:

LRM-00109: could not open parameter file '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora'
What do you suppose that means?

do the following commands, then copy and paste the entire session, commands and responses.

ls /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora
cat /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora

BTW, installing oracle under the /home directory was not the best place to put it. Almost universally, on *nix systems, we install at /u01/app/oracle/product/<version>/dbhome_<n>.
I'm really beginning to believe you never really read the Installation Guide.
Thanks mate. I read this. It worked for me
Re: Not able to connect SQLPLUS in Susi Linux OS [message #665146 is a reply to message #665131] Wed, 23 August 2017 06:41 Go to previous message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
DannyEm wrote on Tue, 22 August 2017 18:04

Thanks mate. I read this. It worked for me
Your mother should be proud of you for being so good.
Previous Topic: oracle load testing
Next Topic: df command insert into sqlplus and table databas
Goto Forum:
  


Current Time: Wed Dec 11 00:07:57 CST 2019