Home » RDBMS Server » Server Administration » Not able to connect to Oracle Instance : ORA-12514 (Orace 11G (11.2.0.1.0))
Not able to connect to Oracle Instance : ORA-12514 [message #638207] Sat, 06 June 2015 02:53 Go to next message
sachinj
Messages: 13
Registered: February 2012
Location: India
Junior Member
I had changed my shared pool size from 608M to 1G using the below command.

alter system set shared_pool_size=1G scope=spfile;

After restarting the oracle service, I am not able to connect to oracle instance. I am getting below error :

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Can someone please suggest how do I now rollback the shared pool size changes,as oracle instance could not be connected.

Thanks,
Sachin

[Updated on: Sat, 06 June 2015 03:02]

Report message to a moderator

Re: Not able to connect to Oracle Instance : ORA-12514 [message #638209 is a reply to message #638207] Sat, 06 June 2015 04:38 Go to previous messageGo to next message
sachinj
Messages: 13
Registered: February 2012
Location: India
Junior Member
I have noticed below error in oraadmin.log.

C:\app\Administrator\product\11.2.0\dbhome_1\bin\oradim.exe -startup -sid ornage -usrpwd * -log oradim.log -nocheck 0
Sat Jun 06 02:27:31 2015
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 1088M


Please suggest how do I fix this, as I am not able to connect to oracle instance.?
Re: Not able to connect to Oracle Instance : ORA-12514 [message #638210 is a reply to message #638209] Sat, 06 June 2015 05:56 Go to previous messageGo to next message
John Watson
Messages: 7259
Registered: January 2010
Location: Global Village
Senior Member
Connect with SYSDBA privileges, and generate a pfile from your spfile. Make whatever edits you want, and re-generate the spfile from you edited pfile. For example,
sqlplus / as sysdba
create pfile='c:\tmp\initornage.ora' from spfile;
host notepad c:\tmp\initornsage.ora
create spfile from pfile='c:\tmp\initornage.ora';
startup force



[Updated on: Sat, 06 June 2015 05:57]

Report message to a moderator

Re: Not able to connect to Oracle Instance : ORA-12514 [message #638211 is a reply to message #638209] Sat, 06 June 2015 05:57 Go to previous messageGo to next message
sachinj
Messages: 13
Registered: February 2012
Location: India
Junior Member

I have been able to resolve the issue by increasing the memory_target as recommended in below link :

http://dbatricksworld.com/ora-00838-specified-value-of-memory_target-is-too-small-needs-to-be-at-least-3072m-oracle-12c/

Thanks
Re: Not able to connect to Oracle Instance : ORA-12514 [message #638215 is a reply to message #638211] Sat, 06 June 2015 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 65384
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the relation between the posted problem and the solution?

Re: Not able to connect to Oracle Instance : ORA-12514 [message #638217 is a reply to message #638211] Sat, 06 June 2015 07:58 Go to previous message
EdStevens
Messages: 902
Registered: September 2013
Senior Member
sachinj wrote on Sat, 06 June 2015 05:57

I have been able to resolve the issue by increasing the memory_target as recommended in below link :

http://dbatricksworld.com/ora-00838-specified-value-of-memory_target-is-too-small-needs-to-be-at-least-3072m-oracle-12c/

Thanks


I am disturbed by the fact that the guy that wrote that article thought you needed to actually start the database from the pfile before you could create an spfile from it, thus necessitating yet another restart of the instance. It is not.

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size                  2217992 bytes
Variable Size             549455864 bytes
Database Buffers          285212672 bytes
Redo Buffers                2396160 bytes
Database mounted.
Database opened.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /db_1/dbs/spfileoklacity.ora
Previous Topic: error during install oracle 12c R1
Next Topic: LGWR doing non-clean dismount of group
Goto Forum:
  


Current Time: Mon Feb 19 22:40:36 CST 2018

Total time taken to generate the page: 0.01465 seconds