First of all you have to know that I am not DBA at all (i'm web dev) and my knowledge in Oracle is very limited. Since 2 days i'm facing a big problem since my server has reboot for a unknown reason. Before the machine reboot by itself, everything was working good with my oracle instance. I could use SQL Developer to check the datas, I could send request from a ASP.NET/C# application etc. The configuration was made by a person who is no more with me now, I can't ask his help at the moment.
After the machine did reboot nothing worked right. First of all, I mentioned the problem when I tried to open my database from SQL Developer the following message was displayed :
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Then I launched sqlplus from command prompt and did as follow just to try :
C:/>sqlplus /nolog
SQL>conn sys/sys as sysdba
SQL>startup
ORA-12700: invalid NLS parameter value. (nls_numeric_characters)
here we go. I searched all over the internet and found no solution. I found it was probably caused by "spfilexe.ora" which contains the line ".nls_numeric_characters='.'" I tried ".nls_numeric_characters=',.'" and other combination, nothing worked.
I also tried to create pfile from spfile, then remove the "nls_numeric_characters" line from pfile and try :
startup pfile='<file_url>'.
The database was mounted but in exclusive mode :
Instance ORACLE lancÚe.
Total System Global Area 285212672 bytes
Fixed Size 1287016 bytes
Variable Size 226495640 bytes
Database Buffers 54525952 bytes
Redo Buffers 2904064 bytes
ORA-01102: montage de base de donnees en mode EXCLUSIVE
Then after it is mounted if i try to access to the database it returns the ORA-12514 message.
I'm running Oracle 10.2.0 on Windows Server 2003.
(Sorry for my approximative english, I do my best to be understood!)
Thanks
EDIT1:
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string C:\oraclexe\app\oracle\flash_r
ecovery_area
db_recovery_file_dest_size big integer 10G
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG ,98 0 2
ARCHIVELOG 0 0 0
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 ligne(s) sÚlectionnÚe(s).
rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Lun. Juin 15 15:47:21 2015
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connectÚ Ó la base de donnÚes cible (non dÚmarrÚe)
RMAN> crosscheck archivelog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: Úchec de la commande crosscheck Ó 06/15/2015 15:47:30
RMAN-12010: Úchec d'initialisation de l'allocation automatique de canal
RMAN-06403: impossible d'obtenir une session avec toutes les autorisations
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
EDIT2: When i enter the following command :
SQL> show parameter nls;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string CHAR
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_timestamp_format string
nls_timestamp_tz_format string
nls_time_tz_format string
SQL>
Language is AMERICA while it should probably be FRANCE. Is that a normal behaviour ou do I have to edit something?