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

Not able to connect SQLPLUS in Susi Linux OS [message #664721]

Tue, 01 August 2017 00:28

chrisindya
Messages: 33
Registered: July 2017

Member

Hi,

Iam Not able to connect SQLPlus, while using system user it throws the error message

ORA-12547: TNS: Lost Contact

Tried to connect ORACLE via SQL Developer, it throws the error
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Tried to stop and start the DB Service via terminal. In Shutdown.log throws the below error
ORA-00020: maximum number of processes (300) exceeded

Kindly someone please help to identify the issue and resolve the same.

Thanks
Christo

Report message to a moderator

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

Tue, 01 August 2017 01:42

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00020: maximum number of processes (%s) exceeded
 *Cause:  All process state objects are in use.
 *Action: Increase the value of the PROCESSES initialization parameter.

Report message to a moderator

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

Tue, 01 August 2017 01:54

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

Thanks for your reply..

Iam not able to connect the database via SQL Plus / Oracle developer client to Increase the process.

Is there any other way to increase the process without connecting the database.

Regards,
Christo

Report message to a moderator

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

Tue, 01 August 2017 01:59

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can always connect as SYS, at least locally, as it is not impacted by this parameter.

Do you use a pfile or a spfile?

[Updated on: Tue, 01 August 2017 01:59]

Report message to a moderator

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

Tue, 01 August 2017 02:24

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

Ok, Iam using pfile

Regards
Christo

Report message to a moderator

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

Tue, 01 August 2017 03:21

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

When i check the status of the Listener it shows the below message, this cause any issue during db connection?

The Listener supports no services
The Command completed successfully

Regards,
Christo

Report message to a moderator

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

Tue, 01 August 2017 03:22

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The problem is not there.
Change your "processes" parameter in pfile (to what is it set?) and restart the instance.

[Updated on: Tue, 01 August 2017 03:27]

Report message to a moderator

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

Tue, 01 August 2017 04:22

chrisindya
Messages: 33
Registered: July 2017

Member

Ok Michel,

I changed the processes into 500 in init.ora. Previously there is (Processes = 300)

After that i restart the db service using (dbshut and dbstart) command

Still the DB is not connecting, same error..

Regards,
Christo

Report message to a moderator

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

Tue, 01 August 2017 04:29

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Connect locally, use SQL*Plus, copy and paste your startup command and the answer.
After the error, copy and paste the last lines of your alert.log file from the startup command (line "Starting ORACLE instance" or "Starting up:" if the previous one is not there) to the end.

Before, Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

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

Tue, 01 August 2017 06:15

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

Below error I found in the alert.log, I could not paste "startup" command. since not able to connect SQL*PLUS using SYS or SYSDBA

ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Thu Jul 27 17:28:57 2017
ORA-00020: maximum number of processes 300 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Thu Jul 27 17:37:57 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 17:42:48 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Thu Jul 27 17:44:41 2017
PMON (ospid: 30843): terminating the instance due to error 474
Instance terminated by PMON, pid = 30843
[/alertlog]

Regards,
Christo

Report message to a moderator

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

Tue, 01 August 2017 06:45

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Those alert log messages are from BEFORE when Michael asked you to stop and restart the database. Plus you did not include the requested copy and paste of the terminal session where you stop and start the db.

Like this:

oracle:mydb$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 1 06:51:19 2017

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


Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size                  2257880 bytes
Variable Size             541068328 bytes
Database Buffers          289406976 bytes
Redo Buffers                6549504 bytes
Database mounted.
Database opened.
SQL>

[Updated on: Wed, 02 August 2017 09:18] by Moderator

Report message to a moderator

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

Tue, 01 August 2017 08:33

chrisindya
Messages: 33
Registered: July 2017

Member

Hi EdStevens/Michel,

When I Shut and Start the database instance, I found the below error in the startup.log

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 14:33:34 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact

SQL> ORA-12547: TNS:lost contact
SQL>
./dbstart: Database instance "oracle" warm started.
[/Err]

While connecting SQL*PLUS using SYSDBA i found the below error.

bin$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 18:59:50 2017

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

ERROR:
ORA-12547: TNS:lost contact
[/Error]

kindly help on this...

Regards,
Christo

Report message to a moderator

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

Tue, 01 August 2017 08:36

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Tue, 01 August 2017 11:29

Connect locally, use SQL*Plus, copy and paste your startup command and the answer.
After the error, copy and paste the last lines of your alert.log file from the startup command (line "Starting ORACLE instance" or "Starting up:" if the previous one is not there) to the end.

Before, Please read How to use [code] tags and make your code easier to read.

I no more read nor answer to not formatted post.

Report message to a moderator

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

Tue, 01 August 2017 08:47

chrisindya
Messages: 33
Registered: July 2017

Member

Hi EdStevens/Michel,

Sorry for the not formatted post, I thought we can use our own user-defined tags

When I Shut and Start the database instance, I found the below error in the startup.log

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 14:33:34 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL>
./dbstart: Database instance "oracle" warm started.

While connecting SQL*PLUS using SYSDBA i found the below error.

bin$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 18:59:50 2017

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

ERROR:
ORA-12547: TNS:lost contact

kindly help on this...

Regards,
Christo

Report message to a moderator

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

Tue, 01 August 2017 08:50

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post the result of:

env | sort
pwd
id

Report message to a moderator

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

Tue, 01 August 2017 09:11

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

Please find the result of commands you requested.

 
env | sort

COLORTERM=1
CPU=x86_64
CSHEDIT=emacs
DISPLAY=:2.0
ENV=/etc/bash.bashrc
FROM_HEADER=
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/root
HOST=ip-10-13-228-506
HOSTNAME=ip-10-13-228-506
HOSTTYPE=x86_64
INFODIR=/usr/local/info:/usr/share/info:/usr/info
INFOPATH=/usr/local/info:/usr/share/info:/usr/info
INPUTRC=/etc/inputrc
JAVA_HOME=/usr/jdk1.6.0_30
LANG=POSIX
LC_CTYPE=en_US.UTF-8
LESS=-M -I
LESSCLOSE=lessclose.sh %s %s
LESSKEY=/etc/lesskey.bin
LESSOPEN=lessopen.sh %s
LESS_ADVANCED_PREPROCESSOR=no
LOGNAME=oraclecloud
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
LS_OPTIONS=-A -N --color=tty -T 0
MACHTYPE=x86_64-suse-linux
MAIL=/var/mail/root
MANPATH=/usr/share/man:/usr/local/man:/usr/local/share/man
MINICOM=-c on
MORE=-sl
NNTPSERVER=news
OLDPWD=/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1
ORACLE_HOME=/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1
ORACLE_SID=oracle
OSTYPE=linux
PAGER=less
PATH=/root/bin:/usr/local/bin:/usr/bin:/sbin:/usr/sbin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/home/oracloud/app/oraclecloud/product/11.2.0/dbhome_1/bin:/bin:/fpdata/remotedeploy/LiveStreaming/apache-maven-3.2.3/bin
PROFILEREAD=true
PWD=/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin
PYTHONSTARTUP=/etc/pythonstart
QT_SYSTEM_DIR=/usr/share/desktop-data
SHELL=/bin/bash
SHLVL=6
SSH_CLIENT=58.68.67.162 48040 22
SSH_CONNECTION=58.68.67.162 48040 10.13.228.506 22
TERM=xterm
USER=oraclecloud
VNCDESKTOP=X
WINDOWID=6291490
XCURSOR_THEME=
XDG_CONFIG_DIRS=/etc/xdg
XDG_DATA_DIRS=/usr/share:/etc/opt/kde3/share:/opt/kde3/share
XKEYSYMDB=/usr/share/X11/XKeysymDB
XNLSPATH=/usr/share/X11/nls
XTERM_LOCALE=en_US.UTF-8
XTERM_SHELL=/bin/bash
XTERM_VERSION=X.Org 6.8.99.903(238)
_=/usr/bin/env

 
pwd
/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin

id
uid=0(root) gid=0(root) groups=0(root)

Please help
what shall i check next..

Report message to a moderator

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

Tue, 01 August 2017 09:15

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"root" can't be used to access/start/stop the database.
Use your Oracle owner OS user.
Which OS user is owner of Oracle files?

[Updated on: Tue, 01 August 2017 09:16]

Report message to a moderator

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

Tue, 01 August 2017 09:32

chrisindya
Messages: 33
Registered: July 2017

Member

Thank you Michel for supporting with me.

'oraclecloud' is the OS users which I see as owner of the oracle being installed.

you were right, I was in root user while trying startup earlier. Now I meet same issue once again, even after I tried connecting as 'oraclecloud' OS user. I tried below commands, pasted for your reference. Can you please guide me, what is wrong with my configuration?


ip-10-13-228-506:~ # pwd
/root

ip-10-13-228-506:~ # su oraclecloud

oraclecloud@ip-10-13-228-506:/root> cd ..

oraclecloud@ip-10-13-228-506:/> echo $ORACLE_HOME
/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1

oraclecloud@ip-10-13-228-506:/> cd $ORACLE_HOME
oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1> cd bin

oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> ./dbshut
Processing Database instance "oracle": log file /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/shutdown.log

oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> ./dbstart
Processing Database instance "oracle": log file /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/startup.log

oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 19:50:38 2017

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

ERROR:
ORA-12547: TNS:lost contact


Enter user-name: sys
Enter password: 
ERROR:
ORA-12547: TNS:lost contact


Enter user-name: system
Enter password: 
ERROR:
ORA-12547: TNS:lost contact


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Report message to a moderator

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

Tue, 01 August 2017 09:46

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same thing for this new user: the result of the 3 commands above.
In addition:

ps -eaf | grep pmon
ls -ld $ORACLE_HOME
cat /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/shutdown.log
cat /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/startup.log
tail -100 <alert.log file>

Report message to a moderator

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

Tue, 01 August 2017 10:34

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

The results for 3 commands below for the new user (oracle owner user) 'oraclecloud'


oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> env | sort
COLORTERM=1
CPU=x86_64
CSHEDIT=emacs
DISPLAY=:2.0
ENV=/etc/bash.bashrc
FROM_HEADER=
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oraclecloud
HOST=ip-10-13-228-506
HOSTNAME=ip-10-13-228-506
HOSTTYPE=x86_64
INFODIR=/usr/local/info:/usr/share/info:/usr/info
INFOPATH=/usr/local/info:/usr/share/info:/usr/info
INPUTRC=/etc/inputrc
JAVA_HOME=/usr/jdk1.6.0_30
LANG=POSIX
LC_CTYPE=en_US.UTF-8
LESS=-M -I
LESSCLOSE=lessclose.sh %s %s
LESSKEY=/etc/lesskey.bin
LESSOPEN=lessopen.sh %s
LESS_ADVANCED_PREPROCESSOR=no
LOGNAME=oraclecloud
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
LS_OPTIONS=-N --color=tty -T 0
MACHTYPE=x86_64-suse-linux
MAIL=/var/mail/root
MANPATH=/usr/share/man:/usr/local/man:/usr/local/share/man
MINICOM=-c on
MORE=-sl
NNTPSERVER=news
OLDPWD=/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1
ORACLE_HOME=/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1
ORACLE_SID=oracle
OSTYPE=linux
PAGER=less
PATH=/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/home/oracloud/app/oraclecloud/product/11.2.0/dbhome_1/bin:/bin:/fpdata/remotedeploy/LiveStreaming/apache-maven-3.2.3/bin
PROFILEREAD=true
PWD=/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin
PYTHONSTARTUP=/etc/pythonstart
QT_SYSTEM_DIR=/usr/share/desktop-data
SHELL=/bin/bash
SHLVL=7
SSH_CLIENT=58.68.67.162 48040 22
SSH_CONNECTION=58.68.67.162 48040 10.13.228.206 22
TERM=xterm
USER=oraclecloud
VNCDESKTOP=X
WINDOWID=6291490
XCURSOR_THEME=
XDG_CONFIG_DIRS=/etc/xdg
XDG_DATA_DIRS=/usr/share:/etc/opt/kde3/share:/opt/kde3/share
XKEYSYMDB=/usr/share/X11/XKeysymDB
XNLSPATH=/usr/share/X11/nls
XTERM_LOCALE=en_US.UTF-8
XTERM_SHELL=/bin/bash
XTERM_VERSION=X.Org 6.8.99.903(238)
_=/usr/bin/env


oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> pwd
/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin


oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> id
uid=1006(oraclecloud) gid=100(users) groups=100(users),16(dialout),33(video)

Additional command results

oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> ps -eaf | grep pmon
1006      3738  2729  0 20:28 pts/1    00:00:00 grep pmon

oraclecloud@ip-10-13-228-506:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> ls -ld $ORACLE_HOME
drwxr-xr-x 72 oraclecloud users 4096 Jul 31 16:53 /home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1

shutdown.log


SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 27 15:22:49 2017

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

SQL> ERROR:
ORA-00020: maximum number of processes (300) exceeded


SQL> ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 27 15:44:57 2017

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

SQL> ERROR:
ORA-00020: maximum number of processes (300) exceeded


SQL> ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 27 15:58:19 2017

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

SQL> ERROR:
ORA-00020: maximum number of processes (300) exceeded


SQL> ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 27 17:28:57 2017

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

SQL> ERROR:
ORA-00020: maximum number of processes (300) exceeded


SQL> ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 27 17:45:02 2017

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

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 27 17:55:01 2017

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

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 11:23:07 2017

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

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 11:27:31 2017

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

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 11:52:03 2017

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

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 12:08:36 2017

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

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> ORA-01012: not logged on
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 15:03:24 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 18:34:43 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 28 19:23:10 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 09:55:42 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 11:04:47 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 11:08:09 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 11:16:14 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 11:18:22 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 12:36:05 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 12:42:49 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 12:44:56 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 12:57:32 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 16:20:02 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 16:21:06 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 16:23:28 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 16:38:32 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 16:57:51 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 17:09:30 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 18:18:29 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 18:50:53 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 12:55:31 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 14:33:20 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 19:49:48 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> Database instance "oracle" shut down.

startup.log


./dbstart: Starting up database "oracle"
Mon Jul 31 16:58:27 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 16:58:27 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

/fpdata/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin/dbstart: Starting up database "oracle"
Mon Jul 31 17:11:11 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 17:11:11 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
/fpdata/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/bin/dbstart: Database instance "oracle" warm started.

./dbstart: Starting up database "oracle"
Mon Jul 31 18:19:41 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 18:19:41 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

./dbstart: Starting up database "oracle"
Mon Jul 31 18:51:08 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 31 18:51:08 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

./dbstart: Starting up database "oracle"
Tue Aug  1 12:55:37 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 12:55:37 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

./dbstart: Starting up database "oracle"
Tue Aug  1 14:33:34 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 14:33:34 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

./dbstart: Starting up database "oracle"
Tue Aug  1 19:50:10 IST 2017


SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 1 19:50:10 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

Alert.log (last 100 lines)

Path of alert log: /home/oraclecloud/app/oraclecloud/diag/rdbms/oracle/oracle/trace

ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 16:27:54 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Thu Jul 27 16:37:57 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 16:38:02 2017
Thread 1 cannot allocate new log, sequence 7491
Private strand flush not complete
Current log# 2 seq# 7490 mem# 0: /home/oraclecloud/app/oraclecloud/oradata/oracle/redo02.log
Thread 1 advanced to log sequence 7491 (LGWR switch)
Current log# 3 seq# 7491 mem# 0: /home/oraclecloud/app/oraclecloud/oradata/oracle/redo03.log
Thu Jul 27 16:38:30 2017
Process m000 submission failed with error = 20
Thu Jul 27 16:42:54 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 16:46:27 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 16:47:57 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 16:57:54 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Thu Jul 27 17:03:00 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 17:07:57 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 17:12:54 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 17:17:57 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 17:27:54 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Thu Jul 27 17:28:57 2017
ORA-00020: maximum number of processes 300 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Thu Jul 27 17:37:57 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Thu Jul 27 17:42:48 2017
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Thu Jul 27 17:44:41 2017
PMON (ospid: 30843): terminating the instance due to error 474
Instance terminated by PMON, pid = 30843

Report message to a moderator

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

Tue, 01 August 2017 11:59

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have you really install Oracle with "users" group?
I don't know if it is supported, you should have at least a "dba" group (not necessary named "dba") and, preferably, an Oracle installation group (usually named "oinstall" but can be what you want, except a standard one).

Also, depending how your dynamic link loader, you should set LD_LIBRARY_PATH to include $ORACLE_HOME/lib (in addition to /lib and /usr/lib, depending on your installation).

Also "Please look at trace files" as Oracle tells.

In my opinion, you should reinstall Oracle following the recommendations of the "Install" book.

Report message to a moderator

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

Tue, 01 August 2017 12:56

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

I did notice this,
Quote:

I changed the processes into 500 in init.ora. Previously there is (Processes = 300)

you have changed the wrong file, your instance will be using a file named initoracle.ora
Though if your database instance is anything like normal, it will actually be using an spfile.

Probably best to start again, with release 12.2 rather than 11.2.0.1.

Report message to a moderator

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

Tue, 01 August 2017 13:58

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Gee! You're right, I wrongly assumed init.ora means init<sid>.ora as senior (ab)usually tell it.

Report message to a moderator

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

Wed, 02 August 2017 00:45

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel , John Watson

I tried to set LD_LIBRARY_PATH = $ORACLE_HOME/lib
Also changed the Processes = 500 in spfileoracle.ora file placed in $ORACLE_HOME/dbs location and start, stop the instance and verified the startup.log.

Still the below error exist

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 2 11:06:15 2017

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

SQL> ERROR:
ORA-12547: TNS:lost contact


SQL> ORA-12547: TNS:lost contact
SQL> 
./dbstart: Database instance "oracle" warm started.

Kindly help on this..

Report message to a moderator

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

Wed, 02 August 2017 00:50

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Also changed the Processes = 500 in spfileoracle.ora file

How did you do this? spfile is a binary file, it can't be modified simply using a text editor.

Report message to a moderator

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

Wed, 02 August 2017 01:06

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

I directly open the spfileoracle.ora file and modified the "Processes = 500" using text editor and open using vi editor and verified. It is modified.
Is there any other way to modify the Processes?

Report message to a moderator

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

Wed, 02 August 2017 01:11

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sure the correct ways are:
1/ Use, when database is at least in NOMOUNT mode, ALTER SYSTEM ... SCOPE=SPFILE
2/ Use, when database is at least in NOMOUNT mode, CREATE PFILE=... FROM SPFILE and modify the pfile with a text editor.

Use the second way and post your generated pfile.
And do NOT use dbstart/dbstop, use ONLY SQL*Plus.

Report message to a moderator

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

Wed, 02 August 2017 05:40

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

Since we are not able to connect sql*plus using SYSDBA to change NOMOUNT mode and CREATE PFILE

Still same error is throwing

oraclecloud@ip-10-13-228-206:~/app/oraclecloud/product/11.2.0/dbhome_1/bin> ./sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 2 13:58:28 2017

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

SQL> connect / as sysdba
ERROR:
ORA-12547: TNS:lost contact

Thanks
Christo

Report message to a moderator

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

Wed, 02 August 2017 05:43

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

You have destroyed your spfile by editing it manually. Best to remove everything, and start again.

Report message to a moderator

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

Wed, 02 August 2017 05:50

chrisindya
Messages: 33
Registered: July 2017

Member

Ohh Ok John,

Could you please guide me to uninstall the oracle11G and install latest version of Oracle in the same system (SUSE Linux OS)

Report message to a moderator

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

Wed, 02 August 2017 05:55

chrisindya
Messages: 33
Registered: July 2017

Member

John Watson wrote on Wed, 02 August 2017 05:43

You have destroyed your spfile by editing it manually. Best to remove everything, and start again.

The Only way is uninstall oracle correct?

Report message to a moderator

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

Wed, 02 August 2017 06:00

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

No, it is not the only way. However, in your case, it probably is.
I'm not going to tell you how to do it. Deinstallation is well described in the docs. However, you might find it quicker to re-install Linux.
Note that the latest release, 12.2.0.1, is not certified for Suse Linux. You could consider using OEL instead.

Report message to a moderator

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

Wed, 02 August 2017 06:09

chrisindya
Messages: 33
Registered: July 2017

Member

John Watson wrote on Wed, 02 August 2017 06:00

No, it is not the only way. However, in your case, it probably is.
I'm not going to tell you how to do it. Deinstallation is well described in the docs. However, you might find it quicker to re-install Linux.
Note that the latest release, 12.2.0.1, is not certified for Suse Linux. You could consider using OEL instead.

Hi John,

You mean we need to re-install Linux or re-install Oracle alone?

Report message to a moderator

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

Wed, 02 August 2017 08:21

chrisindya
Messages: 33
Registered: July 2017

Member

Hi

Now iam able to connect sql*plus using SYSDBA, but getting the below errors during startup,


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

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 2 18:44:37 2017

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'

Report message to a moderator

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

Wed, 02 August 2017 08:36

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What did you do to come to this point?
Once again, post the content of '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs/initoracle.ora', or better attach the file to your post.

Report message to a moderator

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

Wed, 02 August 2017 08:49

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

Thanks for you helping me.. I tried with su oracle and then connect with sql*plus using sysdba, it is connected.

Under the '/home/oraclecloud/app/oraclecloud/product/11.2.0/dbhome_1/dbs' location i found only init.ora and spfileoracle.ora files but not find 'initoracle.ora'

Report message to a moderator

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

Wed, 02 August 2017 09:11

chrisindya
Messages: 33
Registered: July 2017

Member

Hi Michel,

currently iam getting below error when i use the below command connect with sql*plus using sysdba

SQL> startup
ORA-01031: insufficient privileges

Report message to a moderator

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

Wed, 02 August 2017 09:15

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Christo, this is hopeless. One moment you say this:
Quote:

SQL> startup
ORA-01078: failure in processing system parameters

and the next moment this:
Quote:

SQL> startup
ORA-01031: insufficient privileges

These are different problems with different causes and solutions. I now have no idea what is going on.

Report message to a moderator

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

Wed, 02 August 2017 09:17

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Result of same commands with "oracle" than with "root" and "oraclecloud" above?
Post the spfile.
Do not post an abstract of your sqlplus session ALWAYS post the COMPLETE session including the prompt following the last command.

Report message to a moderator

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

Wed, 02 August 2017 23:39

chrisindya
Messages: 33
Registered: July 2017

Member

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>

Report message to a moderator

Pages (2): [1 2 › »]

Previous Topic:	RAC databases migration from RHEL6 to RHEL7 nodes
Next Topic:	Best RHEL 64bit Version for Oracle 11g 11.2.0.10?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 06 20:16:08 CST 2025