tomerbar
asked on
Changed NLS_LANGUAGE and now getting ORA-12514, 10g XE Edition
Hello all, recently I Installed Oracle 10g XE on my Windows XP PC.
I tried ran this command (Charachter set was not OK):
ALTER SYSTEM SET NLS_LANGUAGE = 'AMERICAN_AMERICA.IW8PC150
and since then I cant connect to my DB, all i'm getting is:
ORA-12514: TNS:listener does not currently know of service requested in connectdescriptor
I tried to do everything the Oracle 10g libraries says, but they all reffer to the Net Services Administrator's Guide and more stuff that are not supported in the XE.
I cant even see the connect page of the Oracle XE Management!!
please try to help me if you can.
Tomer.
I tried ran this command (Charachter set was not OK):
ALTER SYSTEM SET NLS_LANGUAGE = 'AMERICAN_AMERICA.IW8PC150
and since then I cant connect to my DB, all i'm getting is:
ORA-12514: TNS:listener does not currently know of service requested in connectdescriptor
I tried to do everything the Oracle 10g libraries says, but they all reffer to the Net Services Administrator's Guide and more stuff that are not supported in the XE.
I cant even see the connect page of the Oracle XE Management!!
please try to help me if you can.
Tomer.
ASKER
Yes I shut it down many times,
and the whole computer, Doesnt work.
and the whole computer, Doesnt work.
Go to $ORACLE_BASE\admin\spfile directory.
Will find there a parameter file.
Rename it to init.ora.
Try to connect the instance. Stop the Oracle service and restart it.
SQL>connect sys/manager@your_entry as sysdba
or
SQL>connect / as sysdba
if you connect:
SQL>shutdown immediate
SQL>startup pfile=....\admin\pfile\ini
After that wait for further instructions.
Will find there a parameter file.
Rename it to init.ora.
Try to connect the instance. Stop the Oracle service and restart it.
SQL>connect sys/manager@your_entry as sysdba
or
SQL>connect / as sysdba
if you connect:
SQL>shutdown immediate
SQL>startup pfile=....\admin\pfile\ini
After that wait for further instructions.
ASKER
well i didnt really understand,
do you want me to change the file spfilexe.ora to init.ora??
well i tried and it didnt work,
or did I understand you wrong.
do you want me to change the file spfilexe.ora to init.ora??
well i tried and it didnt work,
or did I understand you wrong.
Hi,
Problem looks related to Listner/Services.
Can you please upload the result of
lsnrctl > status
Also your TNSNAMES.ORA Entry
-Pradeep
Problem looks related to Listner/Services.
Can you please upload the result of
lsnrctl > status
Also your TNSNAMES.ORA Entry
-Pradeep
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
conn sys as sysdba / password
then
select tname from tab where tname like 'V_$NL%';
u will get
---------------------
V_$NLS_PARAMETERS
then write this statment :
update props$ set value$ = ' here write your character set u want ' where name = 'NLS_CHARACTERSET' ;
then
select tname from tab where tname like 'V_$NL%';
u will get
---------------------
V_$NLS_PARAMETERS
then write this statment :
update props$ set value$ = ' here write your character set u want ' where name = 'NLS_CHARACTERSET' ;
Is the service running?