OraFAQ Forum: Server Administration » Not able to connect to Oracle Instance : ORA-12514

Home » RDBMS Server » Server Administration » Not able to connect to Oracle Instance : ORA-12514 (Orace 11G (11.2.0.1.0))

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

Not able to connect to Oracle Instance : ORA-12514 [message #638207]

Sat, 06 June 2015 02:53

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

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

Report message to a moderator

Re: Not able to connect to Oracle Instance : ORA-12514 [message #638210 is a reply to message #638209]

Sat, 06 June 2015 05:56

John Watson
Messages: 8964
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

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

Report message to a moderator

Re: Not able to connect to Oracle Instance : ORA-12514 [message #638215 is a reply to message #638211]

Sat, 06 June 2015 07:10

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: Not able to connect to Oracle Instance : ORA-12514 [message #638217 is a reply to message #638211]

Sat, 06 June 2015 07:58

EdStevens
Messages: 1376
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

Report message to a moderator

Previous Topic:	error during install oracle 12c R1
Next Topic:	LGWR doing non-clean dismount of group

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:45:26 CST 2025