OraFAQ Forum: Server Administration » ORA-00119: invalid specification for system while dbca deleteDatabase

Home » RDBMS Server » Server Administration » ORA-00119: invalid specification for system while dbca deleteDatabase (Oracle 11g on linux red hat)

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

ORA-00119: invalid specification for system while dbca deleteDatabase [message #570120]

Mon, 05 November 2012 14:41

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

dbca -silent -deleteDatabase -sourceDB TEST
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_TEST'

also tried to start the same instance and i get these messages - i did not created these oracle instance just trying to remove it and recreating it

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 5 15:34:41 2012

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

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_TEST'
SQL> exit
Disconnected

Report message to a moderator

Re: ORA-00119: invalid specification for system while dbca deleteDatabase [message #570121 is a reply to message #570120]

Mon, 05 November 2012 14:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

SQL> CREATE PFILE FROM SPFILE;
-- edit pfile & remove line containing "LOCAL_LISTENER" line
SQL> CREATE SPFILE FROM PFILE;
SQL> STARTUP

Report message to a moderator

Re: ORA-00119: invalid specification for system while dbca deleteDatabase [message #570135 is a reply to message #570121]

Mon, 05 November 2012 18:41

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

hi
I copied the init.ora made my changes and worked - sorry im cleaning up others messes here

Report message to a moderator

Re: ORA-00119: invalid specification for system while dbca deleteDatabase [message #570929 is a reply to message #570120]

Mon, 19 November 2012 00:10

vatsal
Messages: 1
Registered: November 2012
Location: HYDERABAD

Junior Member

hi,
you first check your listener status go to port no u have given, if your database is have multi-listeners then check out which listener is being used change it to other
startup

Report message to a moderator