OraFAQ Forum: Linux » Not able to connect SQLPLUS in Susi Linux OS

Home » Infrastructure » Linux » Not able to connect SQLPLUS in Susi Linux OS (Oracle 11G, 1.2, Susi Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664776 is a reply to message #664775]

Wed, 02 August 2017 23:52

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..

Attachment: spfileoracle.ora
(Size: 8.21KB, Downloaded 177 times)

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664777 is a reply to message #664775]

Thu, 03 August 2017 00:34

Michel Cadot
Messages: 67667
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)

Attachment: initoracle.ora
(Size: 0.68KB, Downloaded 177 times)

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664778 is a reply to message #664777]

Thu, 03 August 2017 00:57

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>

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664779 is a reply to message #664778]

Thu, 03 August 2017 01:07

Michel Cadot
Messages: 67667
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

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

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664781 is a reply to message #664780]

Thu, 03 August 2017 01:36

Michel Cadot
Messages: 67667
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';

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664782 is a reply to message #664781]

Thu, 03 August 2017 03:11

chrisindya
Messages: 33
Registered: July 2017

Member

Ok Michel, Thanks

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664783 is a reply to message #664781]

Thu, 03 August 2017 03:44

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...

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664784 is a reply to message #664775]

Thu, 03 August 2017 06:50

EdStevens
Messages: 1293
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.

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664787 is a reply to message #664784]

Thu, 03 August 2017 07:38

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..

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #664898 is a reply to message #664775]

Thu, 10 August 2017 06:23

EdStevens
Messages: 1293
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.

Report message to a moderator

Re: Not able to connect SQLPLUS in Susi Linux OS [message #665131 is a reply to message #664784]

Tue, 22 August 2017 20:04

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

Report message to a moderator