Oracle database in not being started

[Former Member]

Hi Gurus,

I am working on AIX 5.3 / Oracle 9.2.4 & facing below mentioned problem when I am trying to start the database. Copied the sqlplus in /home/devadm directory & change the rights also but still same problem. Please advise how to overcome this problem & also let me know how to upgrade KERNEL. Grateful if any body could send me the link to the documentation of KERNEL upgrade.

hpmdev:devadm 4> startsap

Checking DEV Database

-

---

ABAP Database is not available via R3trans

Checking DEV Database

-

---

Starting SAP-Collector Daemon

-

---

10:22:34 08.12.2006 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.88 640 - AIX v6.15 5L-64 bit 050707

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 385050) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/DEV/SYS/exe/run/startdb

Trying to start DEV database ...

Log file: /home/devadm/startdb.log

Can not find executable sqlplus

DB startup failed

Thanks in advance

Sanjay

[Former Member]

I am also getting the same error... pls help

environment variables are set

xxx:<SID>adm 36> startdb

Trying to start UP6 database ...

Log file: /home/up6adm/startdb.log

Can not find executable sqlplus

xxx:<SID>adm 37> sqlplus /nolog

sqlplus: Command not found.

xxx:<SID>adm 32> R3trans -d

This is R3trans version 6.05 (release 46D - 27.03.05 - 14:30:00).

R3trans finished (0000).

while stopping SAP also getting the same

xxx:<SID>adm 35> stopsap

Stopping the SAP R/3 UP6 Processes
----------------------------------
Shutdown-Log is written to /home/up6adm/stopsap_rp34-100_00.log
Instance on host xxxxx stopped
Waiting for cleanup of resources...........

Stopping SAP R/3 UP6 Database
------------------------------
Shutdown-Log is written to /home/up6adm/stopdb.log
Trying to stop UP6 database ...
Log file: /home/up6adm/stopdb.log
Can not find executable sqlplus
Database stopped

[Former Member]

Hi,

I am getting the same error message while starting startsap. Could you please provide the solution how it can be fixed.

My of OS is AIX.

Trans Log from oracle user:

4 ETW000 R3trans version 6.09 (release 620 - 27.03.03 - 14:30:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 08.12.2006 - 03:17:34

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Dec 8 03:17:34 2006 46 0.000046

4 ETW000 [dev trc ,00000] db_con_init called 30 0.000076

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 58 0.000134

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/CPR/SYS/exe/run/dboraslib.o' ...

4 ETW000 29 0.000163

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= No such file or directory -> DLENOACCESS (2,No such file or directory)

4 ETW000 648 0.000811

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/CPR/SYS/exe/run/dboraslib.o'

4 ETW000 20 0.000831

2EETW169 no connect possible: "invalid values set for DIR_LIBRARY '/usr/sap/CPR/SYS/exe/run' or dbms_type 'ORA'"

(EOF):cpradm> pg startdb.log

-

---

Mon Dec 25 13:09:00 WST 2006

LOGFILE FOR STARTING ORACLE

Trying to start CPR database ...

-

---

Mon Dec 25 13:09:00 WST 2006

checking required environment variables

ORACLE_HOME is >/oracle/CPR/920_64<

ORACLE_SID is >CPR<

-

---

Mon Dec 25 13:09:00 WST 2006

check initora

-

---

Mon Dec 25 13:09:00 WST 2006

check initora

-

---

Mon Dec 25 13:09:00 WST 2006

checking V2 connect

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.3.0 - Production on 25-DEC-2006 13:09:00

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

/oracle/CPR/920_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = afgfail) (PORT = 1527))) (CONNECT_DATA = (SID = CPR) (GLOBAL_NAME = CPR.WORLD)))

OK (0 msec)

tnsping: V2 connect to CPR

-

---

Mon Dec 25 13:09:00 WST 2006

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Mon Dec 25 13:09:00 WST 2006

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Mon Dec 25 13:09:01 WST 2006

starting database

SQL*Plus: Release 9.2.0.3.0 - Production on Mon Dec 25 13:09:01 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 7944402960 bytes

Fixed Size 747536 bytes

Variable Size 4076863488 bytes

Database Buffers 3865468928 bytes

Redo Buffers 1323008 bytes

Database mounted.

Database opened.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.3.0 - Production

-

---

Mon Dec 25 13:09:09 WST 2006

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/CPR/SYS/exe/run/startdb: Terminating with error code 2

-

---

Mon Dec 25 13:09:00 WST 2006

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Mon Dec 25 13:09:01 WST 2006

starting database

SQL*Plus: Release 9.2.0.3.0 - Production on Mon Dec 25 13:09:01 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 7944402960 bytes

Fixed Size 747536 bytes

Variable Size 4076863488 bytes

Database Buffers 3865468928 bytes

Redo Buffers 1323008 bytes

Database mounted.

Database opened.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.3.0 - Production

-

---

Mon Dec 25 13:09:09 WST 2006

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/CPR/SYS/exe/run/startdb: Terminating with error code 2

Please help me out to fix this issue.

regards

sridhar.V

[Former Member]

Hi,

Perhaps you should have opened a new thread instead of using one that is SOLVED.

Nevertheless, I'm pretty sure you do not have installed the oracle client:

<b>4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/CPR/SYS/exe/run/dboraslib.o' ...

4 ETW000 29 0.000163

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= No such file or directory -> DLENOACCESS (2,No such file or directory)

4 ETW000 648 0.000811

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/CPR/SYS/exe/run/dboraslib.o'</b>

[Former Member]

hi

try with your os: env perhaps your problem it's in your environnement, and try

R3trans -d or -x

[Former Member]

Dear Sanjay,

Check if yr oracle is ok or not. In cmd prompt execute the following

sqlplus /nolog;

connect /as sysdba;

startup;

Pl let me know what msg or errors it throws.

Regards

[Former Member]

Dear Manas,

Thanks for your prompt reply. I am getting below mentioned messages.

hpmdev:oradev 1> sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Dec 8 16:48:45 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba;

Connected to an idle instance.

SQL> startup;

ORACLE instance started.

Total System Global Area 975145464 bytes

Fixed Size 743928 bytes

Variable Size 520093696 bytes

Database Buffers 452984832 bytes

Redo Buffers 1323008 bytes

Database mounted.

Database opened.

[Former Member]

Sanjay

Now ur Db is up and running....

Regards

Vinod

[Former Member]

Hi,

Still I am not able to connect to the server through Sapgui 640. Following error is appearing on the screen:-

partner not reached (host 10.0.1.202, service sapdp00)

WSAECONNREFUSED: Connection refused

Regards

Sanjay

[Former Member]

Dear Sanjay,

As Vinod said rightly yr db is up and running.

Pl try to login in the r/3 server itself and see if you can login via the saplogon. If u r able to logon to sap from there then it seems some of your network settings prevents u to login from the specific client. Pl do a ping check from the client machine to check if the route to the server is ok or nor. command is ping 10.0.1.202 -t. If it cant ping there is some bottleneck in the network settings mostprobably in firewall setting. If it is able to ping then check the saplogon entries.Pl checkfor an entry sapdp00 3200/tcp in file

C:\WINDOWS\system32\drivers\etc\services.

Pl let me know.Pl dont forget to award a point yaar.

Regards

[Former Member]

Hi,

I have already checked the details provided by you before posting this message to the forum . In my opinion this is nothing but the authorisation problem. I have checked the sqlplus files & they are available in following directories:-

oracle/DEV/920_64/inventory/filemap/sqlplus oradev/dba

oracle/DEV/920_64/inventory/filemap/oem_webstage/oracle/sysman/help/master/vtc oradev/dba

oracle/DEV/920_64/bin devadm/sapsys

oracle/DEV/920_64/sqlplus devadm/sapsys

oracle/DEV/920_64/oem_webstage/oracle/sysman/help/master/vtc oradev/dba

I used to start the database through devadm. Please look into it.

Regards

Sanjay

[andreas_herzog]

^^ i thought you have a connection problem between your pc and your sap server?? any database tools like sqlplus are totally irrelevant in this case...the sapgui tries to connect to the appropriate sap application server (which on the other hand must have a working connection to he database server), so what you need is a valid connection! check your pc's tcp/ip settings (subnet & gateway as well!), try to ping your sap server, if really nothing works actvate the trace function in your saplogon utility (options -> activate trace level) and post the results here...

<b>-> is your sap system started???</b> after you started the database you have to start the sap application server as well...login as <sid>adm and type <i>startsap R3</i>

GreetZ, AH

[Former Member]

Server is pinging. I logged in as devadm & typed startsap but below mentioned error is coming.

hpmdev:devadm 4> startsap

Checking DEV Database

-

---

ABAP Database is not available via R3trans

Checking DEV Database

-

---

Starting SAP-Collector Daemon

-

---

10:22:34 08.12.2006 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.88 640 - AIX v6.15 5L-64 bit 050707

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 385050) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/DEV/SYS/exe/run/startdb

Trying to start DEV database ...

Log file: /home/devadm/startdb.log

Can not find executable sqlplus

DB startup failed

Thanks in advance

Sanjay

[andreas_herzog]

aahhh...

<b>still sqlplus is not found???</b> it should reside under /oracle/<SID>/920_64/bin (if you're running Oracle 9i on 64 bit)

<u>workaround:</u>

the database is running, so you don't have to start it anymore! just type "startsap <b>R3</b>" and report the results! <b>(ONLY START R3!!!)</b>

GreetZ, AH

[Former Member]

sqlplus is available in /oracle/sid/920_64/bin with oradev/dba rights.

hpmdev:devadm 1> startsap R3

Checking DEV Database

-

---

ABAP Database is not available via R3trans

Checking DEV Database

-

---

Starting SAP-Collector Daemon

-

---

09:28:01 13.12.2006 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.88 640 - AIX v6.15 5L-64 bit 050707

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 372844) is already running .....

************************************************************************

saposcol already running

Database DEV must be started first

Regards

Sanjay

[Former Member]

Hi,

HAve u set all the environmental variables correctly? Pl recheck and also check the logfile /home/devadm/startdb.log.

Pl paste the same here.

Regards

[Former Member]

Sanjay

Any latest update logs. meanwhile have a look on 403004.

Give some trans logs and check all Environment Variables.Give some detail log if possible.

Regards

Vinod

[Former Member]

Hi,

hpmdev:devadm 9> cat startdb.log

-

---

Wed Dec 13 11:21:17 PAKST 2006

LOGFILE FOR STARTING ORACLE

Trying to start DEV database ...

Can not find executable sqlplus

Regards

Sanjay

[Former Member]

Hi,

hpmdev:devadm 11> cat trans.log

4 ETW000 R3trans version 6.13 (release 640 - 06.07.05 - 07:56:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 09.12.2006 - 12:19:59

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Sat Dec 9 12:19:59 2006 59 0.000059

4 ETW000 [dev trc ,00000] db_con_init called 13 0.000072

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 39 0.000111

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/DEV/SYS/exe/run/dboraslib.o' ...

4 ETW000 41 0.000152

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= Permission denied -> DLENOACCESS (13,Permission denied)

4 ETW000 522 0.000674

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/DEV/SYS/exe/run/dboraslib.o'

4 ETW000 21 0.000695

2EETW169 no connect possible: "invalid values set for DIR_LIBRARY '/usr/sap/DEV/SYS/exe/run' or dbms_type 'ORA'"

Regards

Sanjay

[Former Member]

Sanjay

You need to have look on 193616.Hope this will solve ur problem.

Vinod

[Former Member]

Hi,

Actually there was a permission problem with /oracle (drwx------) so I have changed it to (drwxr-xr-x) & again tried to start sap now I am getting different error.

START SAP

=========

hpmdev:devadm 19> startsap

Checking DEV Database

-

---

ABAP Database is not available via R3trans

Checking DEV Database

-

---

Starting SAP-Collector Daemon

-

---

13:46:34 14.12.2006 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.88 640 - AIX v6.15 5L-64 bit 050707

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 368640) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/DEV/SYS/exe/run/startdb

Trying to start DEV database ...

Log file: /home/devadm/startdb.log

/usr/sap/DEV/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

R3TRANS CHECK

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

hpmdev:devadm 20> R3trans -x

This is R3trans version 6.13 (release 640 - 06.07.05 - 07:56:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"

R3trans finished (0012).

TRANS.LOG FILE

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

hpmdev:devadm 18> cat trans.log

4 ETW000 R3trans version 6.13 (release 640 - 06.07.05 - 07:56:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 14.12.2006 - 13:14:52

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu Dec 14 13:14:52 2006 57 0.000057

4 ETW000 [dev trc ,00000] db_con_init called 12 0.000069

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 40 0.000109

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/DEV/SYS/exe/run/dboraslib.o' ...

4 ETW000 42 0.000151

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/DEV/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000 6120 0.006271

4 ETW000 [dev trc ,00000] Library '/usr/sap/DEV/SYS/exe/run/dboraslib.o' loaded

4 ETW000 23 0.006294

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/DEV/SYS/exe/run/dboraslib.o

4 ETW000 39 0.006333

4 ETW000 [dev trc ,00000] Version of '/usr/sap/DEV/SYS/exe/run/dboraslib.o' is "640.00", patchlevel (0.79)

4 ETW000 187 0.006520

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/DEV/SYS/exe/run/dboraslib.o

4 ETW000 21 0.006541

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/DEV/SYS/exe/run/dboraslib.o

4 ETW000 43 0.006584

4 ETW000 [dev trc ,00000] New connection 0 created 27 0.006611

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 27 0.006638

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 39 0.006677

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 :

71 0.006748

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 23 0.006771

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/DEV/920_64 from environment

4 ETW000 372 0.007143

4 ETW000 [dev trc ,00000] -->oci_init1 25 0.007168

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 38 0.007206

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 31 0.007237

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 991 0.008228

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPHPM's password 40 0.008268

4 ETW000 [dev trc ,00000] Connecting as /@DEV on connection 0 (nls_hdl 0) ...

4 ETW000 42 0.008310

4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

4 ETW000 40 0.008350

4 ETW000 [dev trc ,00000] 0 1 110b45ec0 110b4d978 110b4d2a8

4 ETW000 38 0.008388

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 13 0.008401

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.008415

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=110b4d0f8,svrhp=110b4e0b8)

4 ETW000 61 0.008476

4 ETW000 [dev trc ,00000] Assigning server context 110b4e0b8 to service context 110b4d0f8

4 ETW000 33057 0.041533

4 ETW000 [dev trc ,00000] Allocating user session handle 20 0.041553

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110b4d0f8,srvhp=110b4e0b8,usrhp=110b56af8)

4 ETW000 45 0.041598

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 1830 0.043428

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=110b4e0b8)4 ETW000 34 0.043462

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110b4d0f8,srvhp=110b4e0b8)

4 ETW000 20 0.043482

4 ETW000 [dev trc ,00000] Deallocating server context handle 110b4e0b8 218 0.043700

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 33 0.043733

4 ETW000 [dev trc ,00000] Try to connect with default password 24 0.043757

4 ETW000 [dev trc ,00000] Connecting as SAPHPM/<pwd>@DEV on connection 0 (nls_hdl 0) ...

4 ETW000 22 0.043779

4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

4 ETW000 :

24 0.043803

4 ETW000 [dev trc ,00000] 0 1 110b45ec0 110b4d978 110b4d2a8

4 ETW000 21 0.043824

4 ETW000 [dev trc ,00000] Allocating server context handle 13 0.043837

4 ETW000 [dev trc ,00000] Attaching to DB Server DEV (con_hdl=0,svchp=110b4d0f8,svrhp=110b4e0b8)

4 ETW000 33 0.043870

4 ETW000 [dev trc ,00000] Assigning server context 110b4e0b8 to service context 110b4d0f8

4 ETW000 34396 0.078266

4 ETW000 [dev trc ,00000] Assigning username to user session 110b56af8 22 0.078288

4 ETW000 [dev trc ,00000] Assigning password to user session 110b56af8 17 0.078305

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=110b4d0f8,srvhp=110b4e0b8,usrhp=110b56af8)

4 ETW000 24 0.078329

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705

4 ETW000 :

4761 0.083090

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=110b4e0b8)4 ETW000 24 0.083114

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=110b4d0f8,srvhp=110b4e0b8)

4 ETW000 40 0.083154

4 ETW000 [dev trc ,00000] Deallocating server context handle 110b4e0b8 226 0.083380

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 33 0.083413

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dblink#2 @ 419]

4 ETW000 69 0.083482

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified [dblink#2 @ 419]

4 ETW000 20 0.083502

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"

Regards

Sanjay

[Former Member]

Sanjay,

ORA-12705 "invalid or unknown NLS parameter value specified"

usually means, we cannot interpret the NLS information our Client (eg: SQL*Plus) is receiving.This is mostly a configuration issue either in your environment or

the NLS information we receive from the Server (eg: because of version missmatches between client and server).

The variable NLS_LANG needs to be in Uppercase on Unix Systems.

On Unix: depending on the shell, you have to export the environment variable to make it visible to the subprocesses

If you do not have the right permissions set on the NLS data files ORACLE_HOME/ocommon/nls/admin/data on Unix you will receive an ORA-12705.

So this error involves many things So I recmd you to have close look on all perms Env variables and correct Oracle Home and locate in listenr and check for tnsping.

U need to have close look to identify problem.

Regards

Vinod

[Former Member]

DEAR SANJAY,

It seemsyour NLS_LANG environment variable is set to NA. Pl unset it and try. Execute the following.

unset NLS_LANG

let me know what happens.

regards

[Former Member]

DEAR SANJAY,

It seemsyour NLS_LANG environment variable is set to NA. Pl unset it and try. Execute the following.

unset NLS_LANG

let me know what happens.

regards

[Former Member]

Hi,

Problem solved. It was nothing but the permission issue.

Thanks for your kind co-operation.

Regards

Sanjay

[Former Member]

Hi sanjay

sqlplus u copied I didnt unstd

sqlplus resides in $ORACLE_HOME/bin.To execute u need to set ORACLE_HOME and PATH in profile file.

set Oracle Env variable and execute profile file and execute sqlplus and let me know if u need any more help.

Regards

Vinod

[Former Member]

Hi Vinod,

Thanks for your suggestions. To be very frank I am new to this field so grateful if you could send me step by step commands.

Regards

Sanjay