Home » RDBMS Server » Networking and Gateways » ORA-12514 (error after reboot Win2003 R2)
ORA-12514 (error after reboot Win2003 R2) [message #256286] Fri, 03 August 2007 13:10 Go to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member

Hello ALL,

This is my first time here and with Oracle (v10.2.0.1).
I guess that all configuration was okay... but the problem started after rebooting the Win2003server.

Before rebooting... I have installed Ora10g Database, created a database called "cm2", saved its template and scripts... using dbca tool.
Using netca created a listener with same name and an alias called "cm2" supplying an IP (192.168.1.8 = server2003r2) for the host field. Then I could make a test with success.

I also could acess OEM DB Control thru browser supplying the address: http://192.168.1.8:1158/em and could access its menu, could run ADDM... etc...

Success, happy and tired...
Poweroff and got rest... (05:00am)

After some hours...(by 11:00am)... turn on the server... and started my problem here below described.
=======================================================
C:\>sc query OracleServiceCM2

NOME_DO_SERVIÇO: OracleServiceCM2
TIPO : 10 WIN32_OWN_PROCESS
ESTADO : 4 RUNNING
(STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
CÓDIGO_DE_SAÍDA_DO_WIN32 : 0 (0x0)
CÓDIGO_DE_SAÍDA_DO_SERVIÇO : 0 (0x0)
PONTO_DE_VERIFICAÇÃO : 0x0
AGUARDAR_DICA : 0x0
--------------------------------------------------------
C:\>sqlplus system@cm2

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 14:27:40 2007

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

Informe a senha:
ERROR:
ORA-12514: TNS:listener não tem conhecimento sobre o serviço solicitado atualmente no descritor de conexão

--------------------------------------------------------
I went to "Environment variables" (Control Panel -> System -> Advanced... with:
ORACLE_HOME = c:\oracle\product\10.2.0\db_1
PATH = C:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\...

--------------------------------------------------------
In the file: listener.log I got:

03-AGO-2007 14:52:48 * (CONNECT_DATA=(SERVICE_NAME=cm2)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\jdk\jre\bin\java.exe)(HOST=SERVER2003R2)(USER=Administrad or))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.8)(PORT=2936)) * establish * cm2 * 12514
TNS-12514: TNS:listener não tem conhecimento sobre o serviço solicitado atualmente no descritor de conexão

---------------------------------------------------------
In the file sqlnet.ora I got:

Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.8)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=cm2)(CID=(PROGRAM=C:\oracle\product\10. 2.0\db_1\jdk\jre\bin\java.exe)(HOST=SERVER2003R2)(USER=Administrador))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 03-AGO-2007 14:52:48
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:conexão recusada
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

----------------------------------------------------
Then I turned trace on issueing:
C:\> lsnrctl trace 16
and I got the trace file attached with this message.
Please read it.
then ==> lsnrctl trace off
----------------------------------------------------
I googled in several sites/forums... searching... with no sucess.
Also searched here. :(

I am about 04 hours working on this case/problem... with no more light onward.

Please... some helping...
Very thanks,


mson77











  • Attachment: listener.trc
    (Size: 16.70KB, Downloaded 669 times)
Re: ORA-12514 (error after reboot Win2003 R2) [message #256287 is a reply to message #256286] Fri, 03 August 2007 13:15 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
If/when you are logged directly onto the system where the database is running, then you do NOT need SQL*Net to connect to the database.

What happens when you issue the command
lsnrctl start
or
lsnrctl status
or
sqlplus system
Re: ORA-12514 (error after reboot Win2003 R2) [message #256288 is a reply to message #256287] Fri, 03 August 2007 13:44 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello,

First of all... thank you for your very fast attention.

====================================================
C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-AGO-2007 15:30:53

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Estabelecendo conexão com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server2003r2)(PORT=1521)))
STATUS do LISTENER
------------------------
Apelido LISTENER
Versão TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Data Inicial 03-AGO-2007 14:15:51
Funcionamento 0 dias 1 hr. 15 min. 3 seg
Nível de Análise support
Segurança ON: Local OS Authentication
SNMP OFF
Arq. Param. Listn. c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Arq. Log Listener c:\oracle\product\10.2.0\db_1\network\log\listener.log
Arq. Rastr. Listn. c:\oracle\product\10.2.0\db_1\network\trace\listener.trc
Resumo de Atendimento...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server2003r2)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Resumo de Serviços...
O serviço "PLSExtProc" tem 1 instância(s).
Instancia "PLSExtProc", status UNKNOWN, tem 1 handler(s) para este serviço...
O comando foi executado com exito
====================================================

As you can read... my database (instance CM2) is not recognized.
And also I read this amazing UNKNOWN instance called "PLSExtProc" which may stand for PL/SQL External Procedure.

Well... if my instance CM2 was not recognized... the first place to check is in the file: tnsnames.ora and listener.ora... and so I will copy and paste here because I can upload only 01 file per message.

======= [listener.ora] file ==============================
# listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

============== [tnsnames.ora] file ==========================
# tnsnames.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

CM2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cm2)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

=====================================================
These 02 files above were created using "netca".




Below are the services recognized by the listener:
==> I cant see my database/instance CM2 recognized by the listener

C:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-AGO-2007 16:35:45

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Estabelecendo conexao com (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.8)(PORT=1521)))
Resumo de Servicos...
O servico "PLSExtProc" tem 1 instancia(s).
Instancia "PLSExtProc", status UNKNOWN, tem 1 handler(s) para este servico...
Handler(s):
"DEDICATED" estabelecido:0 recusado:0
LOCAL SERVER
O comando foi executado com exito

C:\>
=====================================================



Regards,


mson77

[Updated on: Fri, 03 August 2007 14:43]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256318 is a reply to message #256288] Fri, 03 August 2007 15:29 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL...

I am understanding partially this problem. Here is what I did.

The had stopped the service "OracleDBControlcm2"... and I started it again.
Via http://192.168.1.8:1158/em (OEM DB Control) I got the message that listener was on but TNS did not recognized the cm2 service.

There was an option at OEM DB Control... to repair/restart/... e I did it. I provided a host user/passwd and a sys/passwd as sysdba... and OEM DB control issued a SQL command STARTUP.

After that... everything was working fine again... with RESTRICTION. (Wait until I tell the whole situation)

What I have realized was:
Before OEM... at Windows Task Manager... the memory commited by the server was 250MB. After OEM starting up the database... the memory commited is 990MB due CM2 database been started up.

If I go to Windows Services (Administrative Tools)... and command to stop/start... the OracleServiceCM2... the memory commit fall down from 990MB to 240MB... and after starting up... the commited memory goes to 250MB (wrong) and not to 990MB (right).
I simulated a Windows2003 server reboot issueing OracleServiceCM2 stop/start. And the whole problem restart again... :((((.


I mean: the problem occurs when I stop and start the service... and the service does not start. Only shows as started but it is not.
Why the OracleServiceCM2 does not really startup?

Thanks...


mson77


Re: ORA-12514 (error after reboot Win2003 R2) [message #256319 is a reply to message #256318] Fri, 03 August 2007 15:40 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
STARTUP Oracle automatically after REBOOT.
http://www.orafaq.com/forum/t/86370/105911/
Re: ORA-12514 (error after reboot Win2003 R2) [message #256320 is a reply to message #256319] Fri, 03 August 2007 16:34 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello DreamzZ,

Thank you.
It seems to be an equal subject/issue but it is not.

The link that you refer regards about automatic startup fo a oracle service using "services.msc" or directly at "regedit location".

In my case... at:
"service.msc"; and
"regedit location" (HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1)

both are to be automatic start at boot time.

What I am trying to explain here is:

The service "OracleServiceCM2" is running and commiting 900MB of whole server memory (2gb). After stop and start this service... the service OracleServiceCM2 looks like "started" by "windows services.msc" but... but the commited memory is not 900MB anymore but it should be if it is really started up. The commited memory is just 250MB. What I mean is: The message displayed by the windows services.msc is wrong... the OracleServiceCM2 is not started up... the memory consumption is only 250MB (used by Win2003R2)... the memory comsumption should be by 900MB.

And also... when I try to access via sqlplus... I am not able to... the oracle seems to be down. See below.
===================================
C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 18:01:04 2007

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

SQL> conn sys as sysdba
Informe a senha: (supplied right password)
ERROR:
ORA-12560: TNS:erro de adaptador de protocolo ==> Protocol Adapter Error


SQL>
=====================================
I mean... I can not get connected to issue "startup" command.
How anyone can issue "startup" command in this scenary?

By now... I can only solve (bad way) using/via OEM DB Control... and asking OEM to Initialize (Startup slq command).

See image attached.

As you see... almost the same problem... but it is not.
It happens if I just restart the service at "services.msc".

Weird...


mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #256321 is a reply to message #256320] Fri, 03 August 2007 16:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
DELETE and recreate your oracle service and give a try

delete
======
cmd>Oradim -delete -sid DBNAME

Recreate
========

CMD>Oradim -new -sid MYDB -srvc oracleserviceMYDB -startmode auto -pfile d:\oracle\dbs\initMYDB.ora

[Updated on: Fri, 03 August 2007 16:38]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256327 is a reply to message #256321] Fri, 03 August 2007 17:05 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello DreamzZ,

Here is the code used by "dbca" to create CM2 database:
=======================================================
C:\oracle\product\10.2.0\db_1\bin\oradim.exe -new -sid CM2 -startmode manual -spfile
C:\oracle\product\10.2.0\db_1\bin\oradim.exe -edit -sid CM2 -startmode auto -srvcstart system
C:\oracle\product\10.2.0\db_1\bin\sqlplus /nolog @C:\oracle\product\10.2.0\admin\cm2\scripts\cm2.sql

======================================================

I dont have "pfile"... I have a "init.ora" located at:
C:\oracle\product\10.2.0\admin\cm2\scripts

I am attaching... to be checked if this is the -pfile that you say.

======================================================

At "C:\oracle\product\10.2.0\admin\cm2\pfile" folder there is a file called "init.ora.73200731424"

Thanks,


mson77
  • Attachment: init.ora
    (Size: 2.46KB, Downloaded 388 times)
Re: ORA-12514 (error after reboot Win2003 R2) [message #256329 is a reply to message #256327] Fri, 03 August 2007 17:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Oh Your instance running by SPFILE.
Can you paste exact screen from sqlplus for this command

$ 
SET ORACLE_SID=CM2    <<<for windows
sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Aug 3 22:15:19 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

[Updated on: Fri, 03 August 2007 17:20]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256332 is a reply to message #256329] Fri, 03 August 2007 17:23 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member

Hello DreamzZ,

Quote:

C:\>SET ORACLE_SID=CM2
C:\>sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 19:23:48 2007

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

Informe a senha:
ERROR:
ORA-01031: insufficient privileges


Informe o nome do usuario: sys
Informe a senha:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist



Informe o nome do usuario:



Thanks,

mson77


[Updated on: Fri, 03 August 2007 17:28]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256333 is a reply to message #256332] Fri, 03 August 2007 17:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
comment out these entries in sqlnet.ora and try again
# SQLNET.ORA Network Configuration File: D:OraHomenetworkadminsqlnet.ora
# Generated by Oracle configuration tools.
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
#NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES)
Re: ORA-12514 (error after reboot Win2003 R2) [message #256334 is a reply to message #256332] Fri, 03 August 2007 17:37 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member

Hi... another test:
Quote:
C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 19:33:20 2007

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

SQL> conn sys as sysdba;
Informe a senha:
Conectado a uma instancia inativa.
SQL> select * from v$instance;
select * from v$instance
*
ERRO na linha 1:
ORA-01034: ORACLE not available
SQL>


Regards,

mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #256335 is a reply to message #256334] Fri, 03 August 2007 17:40 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> SELECT * FROM V$INSTANCE;
SELECT * FROM V$INSTANCE
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL> STARTUP
ORACLE instance started.

Total System Global Area 3506438144 bytes
Fixed Size                  2132424 bytes
Variable Size             699504184 bytes
Database Buffers         2801795072 bytes
Redo Buffers                3006464 bytes
Database mounted.
Database opened.
SQL> SELECT COUNT(*) FROM V$INSTANCE;

  COUNT(*)
----------
         1

SQL>

[Updated on: Fri, 03 August 2007 17:41]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256336 is a reply to message #256335] Fri, 03 August 2007 18:00 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi DreamzZ...
Almost there... :)))
Quote:

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 19:49:26 2007

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

SQL> conn sys as sysdba
Informe a senha:
ERROR:
ORA-12560: TNS:erro de adaptador de protocolo


SQL> quit

C:\>set ORACLE_SID=CM2

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sex Ago 3 19:49:52 2007

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

SQL> conn sys as sysdba
Informe a senha:
Conectado a uma instancia inativa.
SQL> select * from v$instance;
select * from v$instance
*
ERRO na linha 1:
ORA-01034: ORACLE not available


SQL> startup
Instancia ORACLE iniciada.

Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 155192172 bytes
Database Buffers 452984832 bytes
Redo Buffers 2940928 bytes
Banco de dados montado.
Banco de dados aberto.
SQL> select count(*) from v$instance;

COUNT(*)
----------
1

SQL> quit
Desconectado de Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

C:\>


Now we found a way to startup manually. But... the problem stills. Why "net start OracleServiceCM2" can not fully startup the service?

Regards,

mson77

[Updated on: Fri, 03 August 2007 18:37]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256362 is a reply to message #256336] Sat, 04 August 2007 01:06 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
for your first error you have to edit listener.ora and add sid name.
http://dbataj.blogspot.com/2007/02/ora-12514.html


Re: ORA-12514 (error after reboot Win2003 R2) [message #256423 is a reply to message #256362] Sat, 04 August 2007 11:54 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello Mohammad Taj,

Thank you for your very kind help.

One thing that I can't understand is why the service/database is not started up.
Before regarding your recommendation about the LISTENER (listener.ora) let me expose something.

I decided to create another instance/database (using dbca) for test purpose only. I named this new one as CM3.

Results:
TEST 01: After Windows server reboot
CM2 few times initiates up and running (db mounted and open)
CM3 initiates showing running (but not mounted neither open)

TEST 02: At ms services.msc
I issue a RESTART command to CM2 database.
It stops and starts CM2... but:
==> very few times it restarts fine, with DB mounted and open;
==> other times it restarts fake: I do not have DB mounted/open.
It happens equal when I apply first a stop command... and after 30sec apply a start command. I dont have DB mounted but have status showing it is running at services.msc

At this moment if I issue: "lsnrctl services" at DOS prompt screen...I don't see listener recognizing CM2 service/database.

These tests do not care about listener.ora conf file.
Just stopping and starting a database. I don't understart that this issue regards listener file.. but I will change as your recommendation.

Below is my listener.ora running now:
----------------------------------
# listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2003r2)(PORT = 1521))
)
)
--------------------------------------------

Finally... what I am sure about is:
At task manager -> process...
If I see "oracle.exe" comsumption ony 11MB... surely my database is NOT mounted/open.
This problems can be easily reproduced just issueing stop/start service or restart service.

Regards,


mson77

[Updated on: Sat, 04 August 2007 12:04]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256442 is a reply to message #256423] Sat, 04 August 2007 13:41 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I posted this problem also at:
http://forums.oracle.com/forums/thread.jspa?messageID=1992596

I followed suggestion about delete/create the SID using ORADIM tool.

My DB uses SPFILE... located at:
{ORACLE_HOME}\DATABASE\SPFILExxx.ORA ==> WHERE xxx=SID_NAME

I create PFILE from SPFILE using:
CREATE PFILE="c:\my_pfile.ora" FROM SPFILE="...\SPFILExxx.ORA"

Then... at DOS PROMPT: (xxx above => CM3)
Delete and create a new instance as suggested by DreamzZ:
Quote:
cmd>Oradim -delete -sid CM3
cmd>Oradim -new -sid CM3 -srvc OracleServiceCM3 -startmode auto -pfile c:\my_pfile.ora



But... when I restart OracleServiceCM3 using Services Tool... the message is that service is up/running but the DB is not mounted/opened.

Also I checked step-by-step this below recommendation...
http://www.dba-oracle.com/oracle9iAS_tips_windows_service.htm
... but also not enough to solve this my problem.

Regards,

mson77 :(((
Re: ORA-12514 (error after reboot Win2003 R2) [message #256449 is a reply to message #256442] Sat, 04 August 2007 16:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
May be OS Problem.
Create another DATABASE from DBCA and check that weather his service auto-restart with reboot or not.
Re: ORA-12514 (error after reboot Win2003 R2) [message #256451 is a reply to message #256449] Sat, 04 August 2007 16:48 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Good evening... DreamzZ,

I have already did this.
Initially I had only instance named CM2. With this instance I got all of these troubles.

Yesterday night I created a test instance named CM3.
Occurs exactly the same simptoms.

Regards,

mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #256453 is a reply to message #256451] Sat, 04 August 2007 16:53 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Hi Mson,

Thats sound strange issue.One more question When you created service for pervious database using ORADIM did you specify the correct PFILE name?

Do you have password file,i know its not a deal with startup but just a confirmation.
Re: ORA-12514 (error after reboot Win2003 R2) [message #256459 is a reply to message #256453] Sat, 04 August 2007 17:13 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi DreamzZ,

Thank you for your availability.
Here is almost 7:00pm.

I will describe what I have done.
1) I created a new db using dbca... naming it as CM3;
2) Upon creation... CM works fine. It is really up/mounted/opened;
3a) I try to restart at services tool (ms services.mc)... restarts but I see at task manager-> process... oracle.exe process using only 11MB... (too low);
3b) Checking if mounted/opened...: fails... I mean.. not started up;
3c) I have to startup manually from sqlplus;
4a) I reboot the server (poweroff/poweron)... and CM3 service does not works even services tools showing me as running;
4b) From task manager I assure that memory usage of oracle.exe process is too low again. Conclusion: not mounted/opened.
========================

Well, dbca from my oracle 10gr2 (10.2.0.1) uses spfile as default.
Then I used:
SHOW PARAMETER SPFILE
to locate my spfile... and... create my PFILE using the command below:

CREATE PFILE="MY_PFILE" FROM SPFILE="MY_SPFILE"
where MY_SPFILE is that showed me by command (SHOW PARAMETER SPFILE);
and MY_PFILE ==> C:\test\pfile_cm3.ora

Then... having the PFILE... I used ORADIM tool... followed your recommendation:
1) ORADIM -delete -sid CM3
==> SID deleted w/ sucess
2) ORADIM -new -sid CM3 -srvc OracleServiceCM3 -startmode AUTO -pfile C:\test\pfile_cm3.ora
==> SID created w/ sucess
========================================

Again... the tests:
==> service restart... :(((
==> server reboot... :(((

looking at task manager--> process tab--> oracle.exe (low memory usage... 11MB; normal memory usage is about 300MB)

[Updated on: Sat, 04 August 2007 17:18]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256460 is a reply to message #256459] Sat, 04 August 2007 17:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You should contact ORACLE support.
Re: ORA-12514 (error after reboot Win2003 R2) [message #256461 is a reply to message #256460] Sat, 04 August 2007 17:27 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi,

this is not my job/work.
I am just starting to study by my own.
I just downloaded the software and I am practicing at home.
No important application running...

I am studying to understand oracle... and to be able to understand people talking about near by me. If I did never tryed oracle... I would never understand what dbas are talking about.

I have a computer with 2 OS (Win2003R2 and Fedora7).
The experience/test that I do at one OS... I retry in another OS.

Anyway... thank you very much.
I really appreciate a lot!!!


mson77
PS: I mean... I don't have way to contact Oracle support.
I am none to them... now. :(((

[Updated on: Sat, 04 August 2007 22:24]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256463 is a reply to message #256461] Sat, 04 August 2007 17:32 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You Welcome Wink

Here are lot of oracle books if you want to download.

http://www.scribd.com/people/my_documents
Re: ORA-12514 (error after reboot Win2003 R2) [message #256471 is a reply to message #256463] Sat, 04 August 2007 23:55 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I found this information to share about this problem.

http://forums.belution.com/en/oracle/000/009/44.shtml

Quote:
Sometimes the start option for the OracleServiceSID in services can't be started as it is not available(it is there but not dark so that we can't click on it)
So open task manager,end all Oracle processes.Then go to administrative tools,services.There the start option for OracleServiceSID is available(i.e we click).Click on it and the service starts.I had to check this a couple of times when I restarted.
From then onwards the service is starting automatically after restart.


Bye



I am testing the recommendation (quote above)... and I just posted here to share with everybody.

Regards,


mson77
PS: DreamzZ... THANK YOU VERY MUCH for your link at scribd
Re: ORA-12514 (error after reboot Win2003 R2) [message #256475 is a reply to message #256286] Sun, 05 August 2007 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
mson77,
I applauded you persistance & completeness of your posts.
I can only wish that other would show your professionalism.
I wish I could have contributed, but I don't do Windoze.

I hope that you greatly benefit from your efforts to learn.

HAND!
Re: ORA-12514 (error after reboot Win2003 R2) [message #256535 is a reply to message #256475] Sun, 05 August 2007 12:47 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I did the following test. Using Services tool (services.msc):

1) Select my OracleServiceCM3... and "STOP".
2) Wait for 5minutes...
3) "START" OracleServiceCM3.
===> WORKS!!!

But if I use "RESTART" option... does not work.

I repeted the steps above (1-2-3) many times.... and I can get the database loaded and working. The problem is "why do I have to pause such period od time?"...

If I pause (between STOP and START)... for a short period... for instance... 30sec... this procedure does not work... I mean... the DB is not correct loaded.

An weird thing that I notice... The SPFILECM3.ORA is been updated. Is it correct? I did not issued any "ALTER SYSTEM" command.

Thanks,


mson77

PS: But... if I have 02 instances... and after 5min pause I start one instance... then I have to wait (pause again) to start the second instance. If I start the second instance upon the first has been started... this second will show as running but will not mount the database... (like startup nomount).


[Updated on: Sun, 05 August 2007 13:35]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #256541 is a reply to message #256535] Sun, 05 August 2007 16:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Hi Mson,
May be some probelm with your OS?
whats your oracle version?
and which option you installed ?ENTERPRISE personal?
Re: ORA-12514 (error after reboot Win2003 R2) [message #256543 is a reply to message #256541] Sun, 05 August 2007 16:22 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello DreamzZ,

My environment:

Windows 2003 R2 (32-bit version) with updates from windowsupdate;
Oracle 10g (10.2.0.1.0) 32-bit version for windows;
I installed Enterprise version.

Regards,

mson77
PS: Attached regedit oracle key
Re: ORA-12514 (error after reboot Win2003 R2) [message #256831 is a reply to message #256543] Mon, 06 August 2007 19:15 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

Finally solved!

Format the hard disk and install a fresh Win2003R2.
With this fresh Windows install... Oracle databases were created... and initializing instances are perfect now.

a) from services tool...
b) from hardware reboot...

Thank you everybody... I really appreciate a lot your helps!

Regards,


mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #257091 is a reply to message #256831] Tue, 07 August 2007 10:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Laughing
Congrulations Man !!!
Did you notice where was the problem oracle or oS side?
Re: ORA-12514 (error after reboot Win2003 R2) [message #257100 is a reply to message #257091] Tue, 07 August 2007 10:27 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi...

I am not sure about anything.
Because... logically the system should run smooth... but did not.

There is an old tip: "When do you have problem in Windows environment that you don't understand... format the hd and reinstall Windows!" And I followed this tip.

Initially I was intended to understand the problem and solve it using the logic and knowledge... and it was good because meanwhile I had the opportunity to know you and you gave me some other new tips... This is good. This is life.

But everything has a timeout... :))) even us... :(((
Then yesterday I format and reinstall the whole windows... took me some hours only instead of days in other case. But both ways are good.

Regards,


mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #257111 is a reply to message #257100] Tue, 07 August 2007 10:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yea i know Windows have lot of problems then unix and linux.Most of the server are on unix/linux enviroment.So try to learn oracle on unix/linux enviroments .
Re: ORA-12514 (error after reboot Win2003 R2) [message #257125 is a reply to message #257111] Tue, 07 August 2007 11:05 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi DreamzZ,

I agree with you.
I have a linux environment. I use Fedora 7 now.
Fedora 7 is the best!!! Better than FC6...!!!

I was testing in Win32 environment because the place I go they use Win32. I first have to understand Win32... and apply the knowledge on linux (F7). This way I guess will be easier for me. Why? Cause this way I will understand their needs... and I will be able to apply on linux environment... providing to them better solution. But this is a long run. I am at less than first mille (started 10 days ago and walking less than turtle... I am too much dumb... while others learn in 10min... I take 10hours...).

Now I am studying the meaning of redo.log, controlfiles, datafiles, archivelog files, sqlplus commands and interaction, rman,... trying to understand the role,schema,user,objects... memoryzing names... views... creating/copying some basic scripts to help me avoid retyping... a lot of work to do...

I think to create a web page to generate scripts... I provide parameters... and this web page would provide the script to be run on sqlplus... (possible but spare time still short).
For instance:
1) If one wants to check if archieve mode is true; If not what command the user will have to apply... (basic but usefull);
2) User provide ts_names... and webpage provide scripts to be run with rman... etc...

... I mean... tool to ease lives.


Regards,


mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #257127 is a reply to message #257125] Tue, 07 August 2007 11:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thate kewl man ,Good luck!!!

Heres a website for oracle 10g R2 every topic with example take a look!

http://psoug.org/library.html

Again good luck..and study hard ;)Other wise you would be like me .Wink
Re: ORA-12514 (error after reboot Win2003 R2) [message #257134 is a reply to message #257127] Tue, 07 August 2007 11:20 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
YOU ARE THE MAN!!!
Sunday night at home I was talking about you.
I am very thankfull.

I try to read your messages on this forum... thousands... and I see your effort to help people truly.
CONGRATULATIONS... this is the real reason that make the world better each new day.

Sincerely,


mson77
Re: ORA-12514 (error after reboot Win2003 R2) [message #257139 is a reply to message #257134] Tue, 07 August 2007 11:28 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks,But i will refer you to read the posts by leading DBAs

Michel
Ana
Frank
Frank (part 2 Wink
Maaher
Ross
Taj
Little
MArtin
....
and all other Seniors except me Wink.

[Updated on: Tue, 07 August 2007 11:29]

Report message to a moderator

Re: ORA-12514 (error after reboot Win2003 R2) [message #257387 is a reply to message #256286] Wed, 08 August 2007 04:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Seems everything going so fine Laughing . Read streams configure replication. Come with me. Laughing
Re: ORA-12514 (error after reboot Win2003 R2) [message #257548 is a reply to message #257387] Wed, 08 August 2007 10:45 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I'cant read Wink
Previous Topic: tnsping unable to resolve
Next Topic: ORA-12560 TNS protocol adapter error
Goto Forum:
  


Current Time: Sun Dec 04 00:04:47 CST 2016

Total time taken to generate the page: 0.08398 seconds