| ORA-12514 (error after reboot Win2003 R2) [message #256286] |
Fri, 03 August 2007 13:10  |
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 2453 times)
|
|
|
|
|
|
| Re: ORA-12514 (error after reboot Win2003 R2) [message #256288 is a reply to message #256287] |
Fri, 03 August 2007 13:44  |
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 |
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 #256320 is a reply to message #256319] |
Fri, 03 August 2007 16:34 |
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 #256329 is a reply to message #256327] |
Fri, 03 August 2007 17:15 |
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 |
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 |
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 |
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 |
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 |
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 #256423 is a reply to message #256362] |
Sat, 04 August 2007 11:54 |
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 |
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 #256451 is a reply to message #256449] |
Sat, 04 August 2007 16:48 |
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 |
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 |
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 #256461 is a reply to message #256460] |
Sat, 04 August 2007 17:27 |
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 #256471 is a reply to message #256463] |
Sat, 04 August 2007 23:55 |
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 #256535 is a reply to message #256475] |
Sun, 05 August 2007 12:47 |
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 #256543 is a reply to message #256541] |
Sun, 05 August 2007 16:22 |
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 |
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 #257100 is a reply to message #257091] |
Tue, 07 August 2007 10:27 |
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 #257125 is a reply to message #257111] |
Tue, 07 August 2007 11:05 |
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 #257134 is a reply to message #257127] |
Tue, 07 August 2007 11:20 |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
