Содержание
- Error 45 Initializing In SQL*Plus When Running A Sql Script From OCFS (Doc ID 281450.1)
- Applies to:
- Symptoms
- Cause
- To view full details, sign in with your My Oracle Support account.
- Don’t have a My Oracle Support account? Click to get started!
- Error 45 Initializing SQL*Plus — Internal Error When Execute One Specific Query/Script (Doc ID 2627459.1)
- Applies to:
- Symptoms
- Changes
- Cause
- To view full details, sign in with your My Oracle Support account.
- Don’t have a My Oracle Support account? Click to get started!
- World of Oracle DBA
- Error 45 initializing SQL*Plus Internal error
- Error 45 Initializing In SQL*Plus When Running A Sql Script
- Answers
- Error 45 initializing SQL*Plus
- Answers
Error 45 Initializing In SQL*Plus When Running A Sql Script From OCFS (Doc ID 281450.1)
Last updated on NOVEMBER 12, 2019
Applies to:
Symptoms
Executing a SQL script file, located on a non-local disk (filesystem), errors out with the following:
Error 45 initializing SQL*Plus
Internal error
Steps to reproduce are shown by example as follows:
1. Create a test.sql script on OCFS filesystem containing sql:
startup nomount
2. Check that test.sql script is in correct directory:
$ ls -l /ocfs/scripts
total 1
-rw-r—r— 1 16 Aug 25 18:11 test.sql
3. Invoke SQL*Plus:
$ sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 — Production on Wed Aug 25 18:17:41 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
4. Connect to database:
SQL> connect / as sysdba
Connected.
5. Execute script:
SQL> @/ocfs/scripts/test.sql
Error 45 initializing SQL*Plus
Internal error
Cause
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | 
| 
| 
| Legal Notices | Terms of Use
Источник
Error 45 Initializing SQL*Plus — Internal Error When Execute One Specific Query/Script (Doc ID 2627459.1)
Last updated on NOVEMBER 03, 2021
Applies to:
Symptoms
Executing one specific query/script fails with following error.
The problem occurs with one specific query in a script. Other queries run okay.
It fails in more than one environment using SQL*Plus.
However, the same query works fine using SQL Developer.
Steps to Reproduce:
1. Login to SQL*Plus:
Changes
Fails only with one specific query/script.
Cause
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. пїЅ Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use
Источник
World of Oracle DBA
Error 45 initializing SQL*Plus Internal error
- Get link
- Other Apps
If you are executing normal SQL script then review the script. I ran one SQL script and I saw after executing the script at the end it generated Error 45 initializing SQL*Plus Internal error. I review the script and I saw at the end of it there are some spool output. So I deleted that I ran again and it solved the problem.
However there is related oracle bug when fired whenever you run a Sql Script From OCFS. This bug retained from SQL*Plus — Version 9.0.1.0 to 10.1.0.2. When SQL script file is on a OCFS filesystem created on shared device then executing that script from SQL*Plus will fire the bug.
You can reproduce the bug by following steps.
1.Create a test.sql script on OCFS filesystem containing sql:
startup nomount
2. Check that test.sql script is in correct directory:
$ ls -l /ocfs/scripts
total 1
-rw-r—r— 1 oracle dba 17 Mar 25 03:12 test.sql
3. Invoke SQL*Plus:
$ sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 — Production on Wed Aug 25 18:17:41 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
4. Connect to database:
SQL> connect / as sysdba
Connected.
5. Execute script:
SQL> @/ocfs/scripts/test.sql
Error 45 initializing SQL*Plus
Internal error
Solution of The Problem
If this happens while you execute your script from OCFS then just copy the SQL script file to a local disk and then execute the script.
Источник
Error 45 Initializing In SQL*Plus When Running A Sql Script
I have a daily scheduled jobs running on Windows server 2003 and 2008. Oracle Version :10.2.0.1 and 10.2.0.4
right now jobs are not even starting when i run them manually. Found the error Error 45 Initializing In SQL*Plus When Running A Sql Script.
it says Bug:3039738.
what is the solution to fix this Bug ?
Answers
Running an SQL script file on OCFS (or some other type of SAN or shared) storage? Try on a local filesystem?
Jobs as in those types of jobs that show in a DBA or USER JOBS listing? Is your JOBSQUEUE_PROCESSES parameter = 0 ?
My jobs are not in DBA_jobs.
These are scheduled on server most of them are Rman backup jobs.
current JOBS_QUEUE_PROCESSES parameter = 10
try post the troublemaker script here
do you think the Problem is not with the script ?
when i run the job its reaching SQLPLUS and giving error
Error 45 Initializing In SQL*Plus When Running A Sql Script .
Server:windows 2003 and oracle version :10.2.0.1
CMD /C %ORACLE_HOME_PRIME%binsqlplus.exe /NOLOG @ %xxxx_HOME%DBA_BackupBackupDo.sql testdb BackupFull
Script:
rmanbackup.rman
BACKUP AS COMPRESSED BACKUPSET DATABASE FORCE PLUS ARCHIVELOG;
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE DISK;
LIST BACKUP SUMMARY;
LIST BACKUP;
user9174724 wrote:
Hi
do you think the Problem is not with the script ?
when i run the job its reaching SQLPLUS and giving error
Error 45 Initializing In SQL*Plus When Running A Sql Script .
Server:windows 2003 and oracle version :10.2.0.1
CMD /C %ORACLE_HOME_PRIME%binsqlplus.exe /NOLOG @ %xxxx_HOME%DBA_BackupBackupDo.sql testdb BackupFull
The above line does the following:
1) launches a command procesor
2) passes that command processor the following command line parms:
/C
(process the following command, then terminate)
%ORACLE_HOME_PRIME%binsqlplus.exe
the launched processor will process the executable ‘sqlplus.exe’ found in the bin subdirectory, found in the directory indicated by the environment variable ‘ ORACLE_HOME_PRIME’. The remainder of the command line will be passed to sqlplus.exe for interpretation and processing
/NOLOG
tell sqlplus to start up without trying to immediately log on to a database
@
typically used to indicate to sqlplus that the immediately following string names a file of sql and sqlplus commands to be processed.
%xxxx_HOME%DBA_BackupBackupDo.sql
tell sqlplus to execute the commands found in the file ‘BackupDo.sql’, found in the subdirectory DBA_Backup, found in the directory name by the environment variable ‘xxxx_HOME’.
testdb
BackupFull
pass the values ‘testdb’ and ‘BackupFull’ to be used as values for substitution variables &1 and &2 in the file ‘BackupDo.sql’
Script:
rmanbackup.rman
BACKUP AS COMPRESSED BACKUPSET DATABASE FORCE PLUS ARCHIVELOG;
DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE DISK;
LIST BACKUP SUMMARY;
LIST BACKUP;
I don’t know what you expect of this. It is an rman script and we’ve seen no sign of an rman script being executed in any of what you’ve shown us. RMAN commands are processed by rman, not sqlplus.
Unfortunately, you didn’t think showing us the contents of BackupDo.sql was of any value in finding out what your problem was.
Edited by: EdStevens on Jul 11, 2011 7:58 PM
Источник
Error 45 initializing SQL*Plus
When I try to execute a create view script, I encounter a «Error 45 initializing SQL*Plus Internal Error».
When googled for it. The BUG 3039738 is associated with this error message.
My question is, When the Metalink has explained the scenario in BUG description that. This error is encountered when a shell script is trying to invoke the sqlplus.
I donno why I am getting it when I try to run a SQL create view script.
Details:
OS:Red Hat Linux 5.2
DB:Oracle 10g (10.2.0.4)
Regards,
SAM
Answers
And your script is. ?
There are multiple causes for this bug. Do a google search and you will find similar to your case.
What kind of filesystem is the script on ?
Its quite a huge script. Do you still want me to post the same?
We use eChangeMan for scripts transfer.
The scripts are uploaded into eChangeMan and then sent for approval. Once Approved. The eChangeMan automatically transfers the scripts to specific location on server, from where we execute them.
In one link I found this
»
Cause: The issue is identified as Bug:3039738. This typically reproduces when SQL script file is on a OCFS filesystem created on shared device (for example, SAN storage).
Fix: The only workaround, until bug is fixed, is to copy the SQL script file to a local disk (in case of Linux, a ext3 filesystem).
«
But this is the first time I have encountered this error. When i did a vi on script, It looks fine, without any spl characters.
Источник
Error 45 initializing SQL*Plus Internal error
If you are executing normal SQL script then review the script. I ran one SQL script and I saw after executing the script at the end it generated Error 45 initializing SQL*Plus Internal error. I review the script and I saw at the end of it there are some spool output. So I deleted that I ran again and it solved the problem.
However there is related oracle bug when fired whenever you run a Sql Script From OCFS. This bug retained from SQL*Plus — Version 9.0.1.0 to 10.1.0.2. When SQL script file is on a OCFS filesystem created on shared device then executing that script from SQL*Plus will fire the bug.
You can reproduce the bug by following steps.
1.Create a test.sql script on OCFS filesystem containing sql:
startup nomount
2. Check that test.sql script is in correct directory:
$ ls -l /ocfs/scripts
total 1
-rw-r—r— 1 oracle dba 17 Mar 25 03:12 test.sql
3. Invoke SQL*Plus:
$ sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 — Production on Wed Aug 25 18:17:41 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
4. Connect to database:
SQL> connect / as sysdba
Connected.
5. Execute script:
SQL> @/ocfs/scripts/test.sql
Error 45 initializing SQL*Plus
Internal error
Solution of The Problem
If this happens while you execute your script from OCFS then just copy the SQL script file to a local disk and then execute the script.
Popular posts from this blog
Configure Raw Devices for ASM in RAC
Configuring RAW decides in RAC is just similiar as you do configure raw devices for voting disk and OCR. In this example, I have faced a different scenario where in In racnode-1 disk sdb is mapped to sdf in ranode-2 In racnode-1 disk sdc is mapped to sdd in ranode-2 In racnode-1 disk sdd is mapped to sde in ranode-2 First I have created three raw partitions from my raw devices sdb, sdc and sdd of racnode-1 each of 80GB for ASM. [root@racnode-1 ~]# /sbin/fdisk /dev/sdb The number of cylinders for this disk is set to 19581. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with: 1) software that runs at boot time (e.g., old versions of LILO) 2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK) Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 2 First cylinder (33-19581, default 33): +80000M Last cylinder or +size or +sizeM or +sizeK (9726-19
ORA-04062: timestamp of procedure has been changed
Problem Description In the database I have created one procedure named a as below. create or replace procedure a(a number) as begin insert into t1 values(1); commit; end; / Now after creating database link using remote database machine whenever I access this procedure «A» it executes successfully and I get value «1» in table t1. Like below in example where orastdby_m is the database link, shaik is the schema name and value 1 is the argument value though argument value is not used in the procedure. SQL> exec shaik.a@orastdby_m(1); PL/SQL procedure successfully completed. Now in the source database machine I changed the procedure as below. Though you can change anything like any literal; adding space or remove space. I changed value to be inserted from 1 to 2. create or replace procedure a(a number) as begin insert into t1 values(2); commit; end; / Now in the other database whenever I execute the procedure using database link it throws error ORA-04062. But subseq
ORA-31655: no data or metadata objects selected for job
Problem Description You are going to do data pump export operation in order to export objects based on filtering via EXCLUDE or INCLUDE parameter of expdp. In this example you wanted tables ‘ACCOUNT_GROUP’,’ADDRESS’,’AREA_GROUP’ and all the tables starting with word CV(like ‘CV’, ‘CV_EXPERIENCE’, ‘CV_EDUCATION’ etc) Your parameter file is like below. userid=smilebd/a directory=d dumpfile=b.dmp include =TABLE:»IN(‘ACCOUNT_GROUP’,’ADDRESS’,’AREA_GROUP’)» include =TABLE:»LIKE ‘CV%’ » And you invoke expdp as expdp parfile=d:parfile.txt from command line. But it fails with below message on my windows PC. C:>expdp parfile=d:parfile.txt Export: Release 10.1.0.4.2 — Production on Thursday, 29 January, 2009 14:53 Copyright (c) 2003, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 — Produc tion With the Partitioning, OLAP and Data Mining
12/07/2017 / Oracle DBA
Error 45, initializing SQL*Plus
My command :
$nohup sqlplus "/ as sysdba" @script.sql &Error Messages :
Error 45 initializing SQL*PlusSolutions:
Go to end of the script, You have to add another line with a lone “/” after it, or you will get this error.
Bug 3039738 – Error 45 Initializing Sql*Plus Running A Shell Script
Advertisement
Filed under Troubleshooting
← ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.
How to find table size? →
Leave a Reply
Enter your comment here…
Fill in your details below or click an icon to log in:
Email (required) (Address never made public)
Name (required)
Website
You are commenting using your WordPress.com account.
( Log Out /
Change )
You are commenting using your Twitter account.
( Log Out /
Change )
You are commenting using your Facebook account.
( Log Out /
Change )
Cancel
Connecting to %s
Notify me of new comments via email.
Notify me of new posts via email.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Сегодня утром на свежеустановленном тестовом сервере Centos 4.4 + Oracle 10gR1 получил ошибку Error 45 initializing SQL*Plus
[oracle@centest ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 — Production on Sat Jun 9 10:19:14 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Error 45 initializing SQL*Plus
Internal error
Судя по металинку эта бага обнаруживается на разных платформах и версиях Oracle, нашел упоминание о Bug 3039738 (Oracle Cluster File System (OCFS) ) и в форуме данная проблема присутствует. Заглянул в первое попавшееся и когда вычитал реплику автора о подобной проблеме «Even I faced the same problem. But when I set the oracle_home,nls_lang and path environment variables it worked fine» сразу проверил свои переменные окружения и обалдел, когда увидел, что HOSTNAME=my_server_name.other_domain.ru 
Заглянул в /etc/hosts, /etc/resolv.conf, /etc/sysconfig/network — так и есть, там прописан не мой, а «левый» домен.
Исправил, ребутнулся — ошибка осталась 
Проблема остается открытой …
Hi All,
When I try to execute a create view script, I encounter a "Error 45 initializing SQL*Plus Internal Error".
When googled for it. The BUG 3039738 is associated with this error message.
My question is, When the Metalink has explained the scenario in BUG description that. This error is encountered when a shell script is trying to invoke the sqlplus.
I donno why I am getting it when I try to run a SQL create view script.
Details:
OS:Red Hat Linux 5.2
DB:Oracle 10g (10.2.0.4)
SQL> #EXP_HR_UK_EMPLOYEE_DETAIL_V.txt
Error 45 initializing SQL*Plus
Internal errorRegards,
SAM
And your script is... ?
Nicolas.
There are multiple causes for this bug. Do a google search and you will find similar to your case.
What kind of filesystem is the script on ?
Hi Nicolas,
Its quite a huge script. Do you still want me to post the same?
Regards,
SAM
can you run any file even one as simple as
SELECT SYSDATE FROM DUAL:
Hi Robert,
We use eChangeMan for scripts transfer.
The scripts are uploaded into eChangeMan and then sent for approval. Once Approved. The eChangeMan automatically transfers the scripts to specific location on server, from where we execute them.
In one link I found this
"
Cause: The issue is identified as Bug:3039738. This typically reproduces when SQL script file is on a OCFS filesystem created on shared device (for example, SAN storage).
Fix: The only workaround, until bug is fixed, is to copy the SQL script file to a local disk (in case of Linux, a ext3 filesystem).
"
But this is the first time I have encountered this error. When i did a vi on script, It looks fine, without any spl characters.
Regards,
SAM
Yup,
I ran remaining SQL scripts, which were part of another scripts bundle. All ran without any problem.
Its the problem with only this script.
Regards,
SAM
Did you try the suggested workaround ?
Otherwise, in SQL*Plus you could do :
set echo on
#your_script
and check the exact statement it fails on.
Nicolas.
Hi Nocolas,
I tried the workaround and it works bt not my script.
SQL> !cat sample.txt
SELECT SYSDATE FROM DUAL;
SQL> #sample.txt
SYSDATE
---------
07-JAN-10
SQL> #EXP_HR_UK_EMPLOYEE_DETAIL_V.txt
Error 45 initializing SQL*Plus
Internal error
SQL> set echo on
SQL> #EXP_HR_UK_EMPLOYEE_DETAIL_V.txt
.
.
.
926 past.user_status assignment_status, NULL payroll,
927 NULL salary_basis, NULL work_hours, NULL normal_start,
928 NULL normal_finish, NULL salary_change_date,
929 Error 45 initializing SQL*Plus
Internal error
[oradb01#sgi-not-etbbd03 1_Views]$I shall check whats the text in line #929
Regards,
SAM
Hi Nicolas,
These are the lines.
927 NULL salary_basis, NULL work_hours, NULL normal_start,
928 NULL normal_finish, NULL salary_change_date,
929 NULL salary_reason, NULL fte_salary, NULL fte_hrs,
930 NULL actual_salary, NULL mon_hrs, NULL tue_hrs,
931 NULL wed_hrs, NULL thu_hrs, NULL fri_hrs, NULL sat_hrs,I dont see anything surprising
Regards,
SAM
Just out of curiosity, your script is creating a view, right ? Only one ?
As far as I can see, it is already a 930 lines of columns script for the same view, considering you have 3 columns per rows, that'll make around 3,000 columns in your views which is much more than max. allowed for a view (max nb columns <= 1,000).
Nicolas.
Hi Nicolas,
No. They have used sub queries and UNIONS to create the view. the line #929 is under the UNION.
I searched the metalink and found this.
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=281450.1
I used winSCP and copied the file from server, renamed it and copied renamed file back to server and executed, but no success.
Regards,
SAM
Bingo!
I just did the simpler thing.
Copied 1018 line script and manually pasted in sqlplus promt. It worked.
But I still doesnt know, why didnt it run as a script.
Regards,
SAM
If you have PL/SQL block in the script without '/' after 'end;' in the end of the script, you also can see sqlplus 45 error
The first error I saw was the cyptic "O/S Message: Invalid argument" when running the script. Running interactively gave me Error 45. Definately caused by bug 3039738, only workaround is to run from non-OCFS2 drive.
Related
EOF communication error when two integer type variables are compared.
Hi guys, Im using Oracle Database 10g Release 10.1.0.2.0 - Production , on a desktop pc windows xp 32 bit. I simply installed it and did not apply any patches. here is my situation code in pl/sql procedure I have written. I am running the proc with sqldbx personal edition from another pc which is xp 32 bit. if (aAgentRateProfile <> gAgentRateProfile) then raise dynsql.incorrect_agentrate_profile; end if; both aAgentRateProfile , gAgentRateProfile variables are integer type and I have declared them as TABLE%COLUMN TYPE. Problem: Whenever this piece of code is executed, oracle crashes, it shows end of file communication error error code is ORA-03113: end-of-file on communication channel. I simply tried like if (5 <> 5) it works fine. The values coming for aAgentRateProfile = 2 , and gAgentRateProfile = 2 , so 2 <> 2 right ? . So what might be causing the problem ? Is it any bug in oracle ? because this is a simple integer comparison and there is nothing that could go wrong here.
Hi, What's between the two operands "aAgentRateProfile2" and "gAgentRateProfile "? Does the code you are showing is really compiled? .. Sorry but what's SQLDBX? Edited by: user11268895 on Jul 12, 2010 11:44 AM
Thank you for replying.. 1. here there is no operand like aAgentRateProfile2 , its aAgentRateProfile and gAgentRateProfile there is a A and G infront of both operands. Im putting 'A' in front to identify tats its an IN parameter to the proc and im putting 'G' in front to identify as a local variable. 2. The procedure is compiled with no errors. I get the error when I run the procedure. If i comment the if loop , the procedure works fine. when that comparison comes, EOF communication error from oracle comes. it shows end of file communication error error code is ORA-03113: end-of-file on communication channel. 2. SQLDBX is a small query editor , something like TOAD.
Hi, Sorry but i don't talk about prefixes, "here there is no operand" i mean a sign between the two operans, for example: avariable*=*anotherone or avariable*!=*anotherone or avariable*>*anotherone .. (= , != >, < ...) could you please do a such select: select * from user_errors where name=<yourprocedurename>
it returns a no rows. So I guess no compilation errors in the proc. Its very strange. I do a simply integer variable comparison and I get end of file communication error.
1. here there is no operand like aAgentRateProfile2 , its aAgentRateProfile and gAgentRateProfile there is a A and G infront of both operands. Im putting 'A' in front to identify tats its an IN parameter to the proc and im putting 'G' in front to identify as a local variable.2. The procedure is compiled with no errors. I get the error when I run the procedure. If i comment the if loop , the procedure works fine. when that comparison comes, EOF communication error from oracle comes. it shows end of file communication error error code is ORA-03113: end-of-file on communication channel.What are you trying to do? Your IF usage if (aAgentRateProfile gAgentRateProfile) thenis unorthodox, even if you get expected results when hard-codeing values (re: your 5 5 comparison). Try using a standard operator between the values for whichever comparison you need: =, <, >, et cetera and see if the error persists. If this doesn't fix the error you can consider logging a Service Request (SR) on My Oracle Support about the issue but I personally get better results trying to solve issues myself (like you are doing). Usuallly when I see this kind of behavior I usually fix it by performing the task in a different way. I'd start with using a standard value - operator - value comparison in the IF statement Good luck!
oops , i forgot the ** operator when i posted the code here , the actual code is if ( aAgentRateProfile ** gAgentRateProfile ) then raise dynsql.incorrect_agentrate_profile; end if; here aAgentRateProfile is an IN parameter and gAgentRateProfile is a local variable both variable's datatype is table.column%type which is integer. . When I debugged , im sure both variables are not equal and it shud raise the incorrect_agentrate_profile exception. this simple code makes the oracle to crash. i really suspect this is a bug in oracle. It shows EOF communication channel ** Im sorry , this forum is not allowing me to put the not equals symbol ,I dont know why.Please read the ** as not equals operator. Edited by: 781395 on Jul 12, 2010 5:43 PM
When you ask something, please take care about what we are saying as remarks for your request, this would save everybody a lot of time .. and again,sorry to insist, i still don't know what "**" means as operator...
the forum is not allowing me to put the not equals pl/sql operator , it simply shows blank when I post the message.I dont know why.. I using chrome browser. Tats why I put **
...your can put "!=" (if you have 5 minutes have a look to the Forum FAQ...) REM: You also have the "preview" tab when posting ...
Are you sure your datatypes are defined correctly? If they are, assign them to local number/integer/whatever variables and try the comparision against the local values and not the arguments
yes, my datatypes are correct , I have given them as table column%type. I also tried assigning them to local variables and compared the local variables , but the same error throws. :(
tito cheriachan wrote: yes, my datatypes are correct , I have given them as table column%type. I also tried assigning them to local variables and compared the local variables , but the same error throws. :(We're into the twilight zone of PL/SQL now :(. Time to do unlikely things ... Drop the package and recreate it. Rename the arguments involved in the comparision. There are 4 != operators; try all 4, and try NOT BETWEEN just to see what happens. Verfiy that this line is causing the error by commenting the whole IF block and see if the error recurs. Then keep the IF condition and comment the inner statements, using the NULL; command to fill in the space. Good luck! Edited by: riedelme on Jul 13, 2010 5:58 AM
Thank you , I will try it asap.
Thank u lots.. simply dropping the proc and renaming the variables worked !!! .. If you could throw some light , why it happens , it wud be great. Again thanks..
Question on Oracle 8i Personal Edition
Please excuse my ignorance but I'm still fumbling my way through Oracle's DBMS. I am wondering if there is any limitation on the functionality of the Oracle 8i Personal Edition. I'm trying to create several table triggers applied with sequences. I can run the instruction to create the triggers in SQLplus as raw code but if I use an external sql file and try to execute the file with #filename.sql I get a truncation to 11 characters and trigger compilation error. Is there some special requirement for using the trigger coding in an external file or is this a limitation of the personal edition.
did you do a SHOW ERRORS to display the errors?
Same problem i also faced. I was trying to execute the sql file in Oracle Enterprise Ed. (NT Platform) by #C:trig.sql. The message came as line truncated 15 char at line no 45 and some characters were truncated at the next line. When i did show error it showed the truncated line as error. I also tried this after increasing the buffer length, width and linesize but did not work. I copied the same trigger text and tried it thru SQL Plus and it worked perfectly. Even i am waiting for an answer. Can anybody tell y it was so? Rgds Manoj Philip
This is the Trigger code I am using in a file called test2.sql -- CREATE OR REPLACE TRIGGER AddressTrigger BEFORE INSERT ON Address REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN SELECT AddressSeq.nextval into :NEW.RecID FROM DUAL; END AddressTrigger; When I run it as #c:test2 I get the following: I did a show errors and the response is -- PLS- 00103 Encontered the symbol "CREATE" on Line 9/1 Any idea what is going on. If you have any suggestions I would greatly appreciate the help.
In the code that you posted, you do not have / at the end of your trigger and you also do not have SHOW ERRORS after that. Are you sure that your script file actually has the / and SHOW ERRORS at the end?
Of course Kamal is right; Nd Kamal I was serching you and if you are willing to share my problems let me your email address asadbaba#fsd.paknet.com.pk is mine: Waiting
ORA-03117: TWO-TASK SAVE AREA OVERFLOW
I have oracle 8i database and powerbuilder 7 application. When I try to execute a store procedure through powerbuilder script ,I got a oracle error "ORA-03117: TWO-TASK SAVE AREA OVERFLOW". That stored procedure is inside a package . That oracle package contains more than 10 procedure , function and user define data type declarations. The same procedure (inside package) execute properly in oracle 7 DBMS and its prompt "TWO-TASK SAVE AREA OVERFLOW" error in oracle 8i DBMS. The profile string to connect oracle database and powerbuilder is follow: [Profile TEST] DBMS=O84 Database=Oracle8i UserId= DatabasePassword= LogPassword= ServerName=TEST LogId= Lock= Prompt=1 DbParm=DisableBind=0,DelimitIdentifier='No',CommitOnDisconnect='No' When I try execute other package stored procedures , it execute properly without any error through powerbuilder application. Please anyone help me how to solve the error "ORA-03117: TWO-TASK SAVE AREA OVERFLOW' in oracle 8i DBMS Thanks Leela
There is probably more in the alert log. Does this cause extra log files in the udump directory ?
I checked with the alert log and Udump directory. I am not able to find any information regarding this problem from this log files.There is no extra log file in udump directory I don't understand what is the root cause of this problem . some procedure only i am getting this error. Thanks Ashok Babu.
Could be a TTC error.. I think you should log a Bug and let Oracle trace this one.
Ashok, This is about Two Task Save Area Overflow error that you were getting in 2003. Did you ever get a resolution from Oracle about it? I am getting the same error. When I do an OCIDescribe on some procedures I get this error. It is not consistent because most of the procedures go through fine. Only a few generate this error. Oracle tech support's response is to apply the latest patch, but they don't do any root cause analysis. So I am wondering if you (or someone else) found the reason for this error. Thank you. Rahul
Hello,
I think we found the explanation for ORA-03117 error in PowerBuilder environment.
Before EACH time when PowerBuilder calls stored procedure or function it runs dbms_describe.describe_procedure
It looks like at some point this function stops working and it becomes a problem. So far I found the way to discover it.
SET pagesize 0
SET trimspool ON
SPOOL c:tempdescribe.sql
SELECT 'PROMPT Object: ' || object_name || CHR(13) || CHR(10) || 'DESCRIBE ' || object_name
FROM all_objects
WHERE owner = 'ABC'
AND object_type IN ('PROCEDURE', 'PACKAGE', 'FUNCTION CLASS')
ORDER BY object_name;
SPOOL OFF
SPOOL c:tempdescribe.log
#c:tempdescribe.sql
SPOOL OFF
If you will find text "ORA-03117" in c:tempdescribe.log then this could lead you to the solution.
What's weird is that SQL*Plus can not describe package but it can execute any of its function without any problem.
I will update this thread if something new will come up.
Hope this will help,
Boris
FWIW, I managed to get this error from a broken installation of Perl DBD::Oracle (half Oracle 9, half Oracle 10).
It seems to be related with describe command..and whether some privileges to describe are given or not..I got this error in Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 , in SQL * Plus. SQL> desc dbms_metadata ERROR: ORA-03117: two-task save area overflow But I can describe other packages without getting any errors..So looks like Privilege related.
Hi All I'm Also getting same Error After Running RDA. SQL> desc dbms_metadata ERROR: ORA-03117: two-task save area overflow Any Reason for Error
Have a look into this Doc ID: Note:362447.1
I hate reviving old threads, but this issue doesn't seem to be fixed... we're experiencing this under 11.2.0.2 using PowerBuilder 12 + O90 DBMS + Oracle client 9.2.0.4. It seems to be related to objects that have other complex types or tables of record as members. Once we remove those from the package everything is fine. We've also tested PB 9+O90 DBMS+Oracle client 9.2.0.4, and PB 12+ORA DBMS+Oracle Instantclient 10.2.0.4, and they do not suffer this issue. To make matters worse, the PB 12 describe behavior (occurs with both PB 12 setups above) is something we've never seen with PB 9. This seems like a Bad Thing ^(TM)^ - the amount of extra network traffic generated is quite large (over 10x in this case.) Edit: to anyone else who looks for this, the problem is solved with a dbparm - RPCStringCheck=0. This stops the describes from occurring and will prevent the overflow. Edited by: br**** on Apr 27, 2012 2:06 PM
Calling Sqlplus from 10g forms
I am upgrading my 6i web forms to 10g. Some of these create simple reports using HOST('sqlplus #script') followed by web.show_document to display the spooled output. I have found that I now need to add an exit statement at the end of the sql script otherwise it just hangs. This was not needed before. Is this a new feature of sqlplus 9 ? Can anyone explain it ?
Kevin, we are having somewhat of the same problem. We have a form that executes a host sqlplus script and then goes and displays a report. We can execute the host command successfully numerous times UNTIL we run the report. After one running of the report, the sqlplus host command won't execute. This is a major issue for us. What operating system are you on? We have filed a TAR with Oracle, and this issue seems to only exist for unix/linux platforms.
I am on solaris. Are you using a spool command in the script ? If so, have you also tried redirecting (>) the output from the sqlplus command to another file and looking at that ?
We are Solaris also. Yes, we do spool and write output to another file. The first time through, the output is written. However, after a report is run, the output is no longer written to by the sql script nor is the DB updated per the script.
I have not not encountered that problem. One thing we found we need to beware of is caching of files (depending on the browser settings). If a report replaces a file of the same name, web.show_document can continue to display the old version from the cache. We found it better to generate a new unique filename each time to prevent this. Another slightly annoying thing; I cannot find a way to specify a default path for sqlplus scripts without hard coding it.
Yes, we have also run into the caching issue. I don't think this problem is related to caching though. We are not displaying the file in the browser, but actually going to look at it on our Solaris server. Would you mind sending me and example of your code that issues the host command and the sql script associated with it? We, also, cannot get around having to code the entire path.
Example as requested...
WHEN-BUTTON-PRESSED Trigger
declare
-- Print version of the current Block Query
-- 10g servlet Version
-- Unique name for output file to avoid displaying previously chached file
outfile varchar2(60) := lower(user)||'_'||to_char(sysdate,'DDMonYY_hh24miss')||'.html';
-- output path will be the forms server default working directory for config=fy
-- defined in formsweb.cfg which is /home/efy/temp
query_text varchar2(2000) := :system.last_query;
begin
-- failmess displays an alert and raises failure
if query_text is null
then failmess('Execute a query on the screen first, the report will do the same query');
end if;
-- extract the text from 'WHERE' onwards which will include the ORDER BY clause, too.
-- note: default where is 1 = 1 to ensure there is always a WHERE clause
query_text := SUBSTR(query_text, INSTR(query_text,'WHERE'));
-- param1 will be the output file name,
-- param2 is the where clause which will be lexically appended to the sqlplus query
-- this will connect to sqlplus as user oracle.
-- tried getting rid of hard coded path but haven't decided a solution yet
host('sqlplus /#test #/home/efy/implemented/testing_record '||outfile||' "'||query_text||'" > log.log');
-- fytemp is virtual directory defined in forms90.conf pointing at /home/efy/temp
-- because web.show_document does not use physical paths
web.show_document('fytemp/'||outfile);
end;
SQL SCRIPT
set lines 240
col tr_finding heading "Finding"
col tr_reaction heading "Reaction"
col col1 heading " " format a12 word_wrap
set pages 50000
set newpage 1
set verify off
set markup html on spool on head "Testing Record" table 'border=1 bordercolor=black height=50%'
ttitle off
whenever sqlerror exit
select
TR_ENTERED_BY col1,
TR_FINDING,
TR_REACTION
from testing_record &2
spool &1
/
spool off
exit
I think I have now hit the same bug as you in a completely different HOST command which does not involve sqlplus at all. Some occurence during the runform session is causing subsequent calls to a particular host command (which had been working) to fail. Unfortunately I have not been able to narrow it down far enough to determine what makes it happen.
Kevin, thanks for keeping me updated. We have a tar but are not getting very good response from Oracle. I'll keep you posted on anything we find out. Deborah
Deborah Could you let me know the number of your TAR please ? I intend to raise a TAR myself, and they might take it more seriously if I can cross refer to another customer having a similar problem. I seem to be getting the problem if I do a run_report_object followed by a web.show_document. Afterwards some host commands work and some don't.
Kevin, Here is our tar number - 3638283.996 The latest update from Oracle Support is that they are filing a bug and will get back with us shortly. I can't begin to tell you what a huge effort it is going to be for us to code a work-around while we wait for this to get fixed. Our developers are very close to mutiny over this! Deborah
Kevin, Oracle has filed a bug on our host/sqlplus problem. The bug number is 3585011. Thought you might want to reference it if you file a tar also. Deborah
Thanks very much. I do intend to file a Tar but I suspect they will ask me to reproduce the problem in a simple test form, which might be difficult to do, and I don't really have time to do it at present.
PS. I cannot access the bug on metalink.
I can't access it either. I have asked Oracle support to make it accessible. Hopefully it will be later on today.... I'm sure they will ask for a test case. One of the hardest things for us was to get support to test this issue on a unix platform. They initially tested on Windows and said they couldn't reproduce the problem. After pushing and insisting, they tested on unix and then saw the problem. I'll keep you posted. Deborah
blank space script
Hello everybody, i have Oracle Database 10g Express Edition Release 10.2.0.1.0 installed, and i've done a Script for insertions , here u got an example: INSERT INTO AAP_PARQUE VALUES (seq_parque.nextval,'Magic Kingdom','3111 World Dr., Lake Buena Vista, FL 32830'); when i run the script, all the insertions are successfully completed, but for an instance, if i do this query : select id_parque from aap_parque where nombre = 'Magic Kingdom" it doesnt return anything... and the "no data found error its thrown... when i retrieve this info using C# or Java, the string that gets the "nombre" or name row, comes like "Magic nKingdom" and i think that n its causing the problem... If i do a manual insertion, the n is not on the data and i can access it freely or doing the query shown above... Can anyone help me solve this? im asuming that the n came from the Scrip interpretation by oracle... im just guessing...
Could you describe this table? Have you used any CHAR columns?
Hello.... of course i can describe the table.... it has 3 colums, id_parque, name, and location. id_parque is number(7,0) and name is Varchar2(50)...
user13651646 wrote: when i run the script, all the insertions are successfully completed, but for an instance, if i do this query : select id_parque from aap_parque where nombre = 'Magic Kingdom" it doesnt return >anything... and the "no data found error its thrown...Are you running the query in the same session the inserts are or a different session? If the session is different you'll have to COMMIT before the other session can see the inserts AFAIK NO_DATA_FOUND only occurs through PL/SQL so you are not just doing a simple query but must be executing a script or form or something to execute your query. The error is one of the downsides to implicit selects; you have to do extra coding for exception handling in some cases Edited by: riedelme on Jan 7, 2011 5:34 AM
user13651646 wrote: Can anyone help me solve this? im asuming that the n came from the Scrip interpretation by oracle... im just guessing...If you edit the script and search for 'Magic Kingdom', is it found?? Looks to me like a type error in the script. And ofcourse make sure the script issues a commit at the end; Cheers, FJFranken
Hello Everyone,
I am facing problem in connecting to Oracle DB (version 10) from post session failure command task (informatica 8.x).
Following things included in the script:
sqlplus UN/PSWD@SID
delete statement includes subquery;
commit;
exit;
Note: I have included above code in .bat script and calling it from post session failure command task.
You can consider followings things:
— Sql syntax/statements are written correctly.
— Oracle DB is running .
— Connection permissions are correct and tested.
The external log that got generated during .bat execution is as follows:
************
X:InformaticaPowerCenter8.6.0serverbin>sqlplus UN/PSWD@SID
SQL*Plus: Release 10.2.0.1.0 on Fri Jan 7 08:46:08 2011
Connected to:
Oracle Database 10g Development Edition Release 10.2.0.1.0
SQL>
X:InformaticaPowerCenter8.6.0serverbin>delete from*;
X:InformaticaPowerCenter8.6.0serverbin>commit;
X:InformaticaPowerCenter8.6.0serverbin>exit;
***************
The session log generated as part of above script execution is:
***********
Severity Timestamp Node Thread Message Code Message
ERROR 1/7/2011 8:46:10 AM NODE01 POST-SESS CMN_1949 Error: [Pre/Post Session Command] Process id 6096. The shell command failed with exit code 9009.
INFO 1/7/2011 8:46:10 AM NODE01 POST-SESS CMN_1954 [Pre/Post Session Command] Process id 6096. Standard output and error:
Error 45 initializing SQL*Plus
Internal error
‘delete’ is not recognized as an internal or external command,
operable program or batch file.
‘commit’ is not recognized as an internal or external command,
operable program or batch file.
************
Need your help
Thanks
Read these next…
Green Brand Rep Wrap-Up: January 2023
Spiceworks Originals
Hi, y’all — Chad here. A while back, we used to feature the top posts from our brand reps (aka “Green Gals/Guys/et. al.) in a weekly or monthly wrap-up post. I can’t specifically recall which, as that was approximately eleven timelines ago. Luckily, our t…
Help with domain controller setup
Windows
I just got a new job as the only IT person for a business with around 270 employees (I would say probably less than half use computers) They don’t have any policies or procedures when it comes to IT, as they have never had an IT person. My background cons…
Malicious URLs
Security
We have firewall, we have endpoint protection, we have Safe links and Attachments for Office 365 (Microsoft Defense for Office 365 Plan 1), and still receiving links that lead to malicious web sites.It seems like security companies still didn’t develop a …
Snap! — Old Batteries, Lovable Bots, Quantum Breakthrough, Should We Trust AI?
Spiceworks Originals
Your daily dose of tech news, in brief.
Welcome to the Snap!
Flashback: February 8, 1996: The massive Internet collaboration “24 Hours in Cyberspace” takes place (Read more HERE.)
Bonus Flashback: February 8, 1974: Americans end outer spa…
Large collection of Mac Minis
Best Practices & General IT
We are getting rid of a lot of older equipment that doesn’t have a purpose anymore on our campus. Most of it is 2010 and 2014 Mac Minis. When they were purchased, they were the absolute base model, so nothing special about them. I’ve reached out to multip…
Hi All,
When I try to execute a create view script, I encounter a «Error 45 initializing SQL*Plus Internal Error».
When googled for it. The BUG 3039738 is associated with this error message.
My question is, When the Metalink has explained the scenario in BUG description that. This error is encountered when a shell script is trying to invoke the sqlplus.
I donno why I am getting it when I try to run a SQL create view script.
Details:
OS:Red Hat Linux 5.2
DB:Oracle 10g (10.2.0.4)
SQL> @EXP_HR_UK_EMPLOYEE_DETAIL_V.txt
Error 45 initializing SQL*Plus
Internal errorRegards,
SAM
Hi Robert,
We use eChangeMan for scripts transfer.
The scripts are uploaded into eChangeMan and then sent for approval. Once Approved. The eChangeMan automatically transfers the scripts to specific location on server, from where we execute them.
In one link I found this
Cause: The issue is identified as Bug:3039738. This typically reproduces when SQL script file is on a OCFS filesystem created on shared device (for example, SAN storage).
Fix: The only workaround, until bug is fixed, is to copy the SQL script file to a local disk (in case of Linux, a ext3 filesystem).
But this is the first time I have encountered this error. When i did a vi on script, It looks fine, without any spl characters.
Regards,
SAM
Similar Messages
-
Error 57 initializing SQL*Plus
i am not able to start sql plus. It gives me the below mentioned error message. I did not have any problem when i worked a month back but now when i am going to start again, it gives me this error. In between, the only change i brought into my PC is the installation of Kaspersky Antivirus and doing the full scan?
Error 57 initializing SQL*Plus
Error loading message shared library
thankshick wrote:
i am not able to start sql plus. It gives me the below mentioned error message. I did not have any problem when i worked a month back but now when i am going to start again, it gives me this error. In between, the only change i brought into my PC is the installation of Kaspersky Antivirus and doing the full scan?
Error 57 initializing SQL*Plus
Error loading message shared library
thanksThis error is raised during the early startup processing for sqlplus and is, by nature, rather generic. Since it is raised during initialization, it’s quite possible that not all libraries that might be needed for additional details (such as localized error messages) are loaded.
As the only thing you mention has changed is installation of Kaspersky, that suggests it is blocking a required library from being loaded. This error can also be raised when there is insufficient memory available (which would also prevent loading of required libraries, etc).
Here’s a simple test you can do to illustrate this (obviously not on a production system, etc!):
$ cd Oracle11.2databaseBIN
$ dir /s /b oraclient11.dll
C:Oracle11.2databaseBINoraclient11.dll
$ rem temporarily rename the Oracle RDBMS Client Library for testing
$ ren oraclient11.dll oraclient11.dll.save
$ rem this will raise error 57 since a required library could not be loaded during initialization
$ sqlplus.exe /nolog
Error 57 initializing SQL*Plus
Error loading message shared library
$ rem be sure to change back!
$ ren oraclient11.dll.save oraclient11.dllRegards,
Mark -
Error 5 Initializing SQL*Plus
Hi, I’ve Oracle 9.2.0.5 over Solaris 9. I’ve set NLS_LANG=spanish_spain.WE8ISO8859P15
and when I try to start sqlplus (sqlplus «/as sysdba») I receive the next error:
$ sqlplus «/as sysdba»
Error 5 initializing SQL*Plus
NLS initialization error
I’m getting this error from this morning, when I delete the file $ORACLE_HOME/ocommon/nls/admin/data/lx10006.nlb and I restore the same file but from version 9.2.0.1, may it be the cause?
Any idea? I haven’t a copy of this file of version 9.2.05…
Thank you,I only can access to the database if I unset NLS_LANG or if I set NLS_LANG=american_america.WE8ISO8859P1
-
Error 7 initializing SQL*Plus
Hi,
when I laucnh sqlplus I obtain this error:
[email protected]:/grid/app/9.2.0>sqlplus
Error 7 initializing SQL*Plus
Message file sp2<lang>.msb not found
[email protected]:/grid/app/9.2.0>which sqlplus
/grid/app/9.2.0/bin/sqlplus
I have these environment settings:
[email protected]:/grid/app/9.2.0>env
_=/usr/bin/env
LANG=en_US
LOGIN=oracle
SSH_TTY=/dev/pts/0
PATH=/grid/app/9.2.0/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.:
NLS_LANG=AMERICAN_AMERICA.UTF8
ORACLE_BASE=/grid/app
LC__FASTMSG=true
EDITOR=vi
LOGNAME=oracle
MAIL=/usr/spool/mail/oracle
ORACLE_SID=TEST
LOCPATH=/usr/lib/nls/loc
USER=oracle
AUTHSTATE=compat
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
HOME=/home/oracle
SSH_CONNECTION=172.27.1.176 8799 172.27.13.210 22
SSH_CLIENT=172.27.1.176 8799 22
TERM=xterm
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/grid/app/9.2.0
PWD=/grid/app/9.2.0
TZ=Europe/Rome
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/grid/app/9.2.0/lib:/grid/app/9.2.0/lib32:/usr/dt/lib:/usr/openwin/lib:/grid/app/9.2.0/ctx/lib
LD_LIBRARY_PATH=/grid/app/9.2.0/lib:/grid/app/9.2.0/lib32:/usr/dt/lib:/usr/openwin/lib:/grid/app/9.2.0/ctx/lib
this is my oratab:
[email protected]:/grid/app/9.2.0>cat /etc/oratab
+ASM1:/grid/11.2.0:N # line added by Agent
#TEST:/grid/app/product/10.2.0:N
TEST:/grid/app/9.2.0:N
What I’m doing wrong?Hi BelMan,
this works fine:
[email protected]:/home/oracle>export ORACLE_HOME=/grid/11.2.0
[email protected]:/home/oracle>export ORACLE_SID=+ASM
[email protected]:/home/oracle>/grid/11.2.0/bin/sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 27 12:51:44 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name:
But I need to use 9.2.0.8 home! -
[Emergency] sqlplus gets «Error 5 initializing SQL*Plus NLS initialization»
Hi, all.
I issued sqlplus, but I got the following error.
What could be the reasons for the following error?
Thanks in advance.
Best Regards.
[esumedi(ngwapt1):/GXS/esumedi] sqlplus
Error 5 initializing SQL*Plus
NLS initialization error
cat .profile
export ORACLE_BASE=/ora_client
export ORACLE_HOME=$ORACLE_BASE/OraHome_1
export ORACLE_TERM=vt100
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=American_america.KO16KSC5601
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin:.:/bin:/usr/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/opt/perf/bin:$ORACLE_HOME/OPatch:/oracle/app/oracle10/product/102
0/bin:.
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/network/lib:/usr/lib
export DISPLAY=172.23.19.134:0.0
export PATH=$PATH:/opt/java1.5/bin:/opt/java1.5/jre/bin
—————————————————————————Thanks for your reply.
I solved this problem by adding «esumedi» user to dba group.
[esumedi(ngwapt1):/GXS/esumedi] cat /etc/group
adm::4:root,adm
dba::107:anylink,almnp,albat,alon,almnp180,alon180,albat180
ngwapt1:/ora_client/OraHome_1/bin>ll sql*
-rwxr-x—x 1 oracle dba 1748248 Sep 17 2009 sqlldr*
-rwxr-x—x 1 oracle dba 1748248 May 6 2008 sqlldrO*
-rwxr-x—x 1 oracle dba 72048 Sep 17 2009 sqlplus*
-rwxr-x—x 1 oracle dba 72048 May 6 2008 sqlplusO*
ngwapt1:/ora_client/OraHome_1/bin>
My guess is that a oracle client user needs «read» and «excute» privilege.
Before I add «esumedi» to dba group, the user of esumedi could not read some file in the $ORACLE_HOME.
After I added «esumedi» to dba group, the user of esumedi was able to read some file in the $ORACLE_HOME.
This is my guess.
Is my guess right?
If I change «file access mode» under $ORACLE_HOME directory, it could be the another solution??
Thanks.
Best Regards. -
Strange error in sql*plus in a line with «&»
Hi friends, this error is very strange:
Open your SQL*PLUS.
write this:
DECLARE
V_1 VARCHAR2(10);
V_2 VARCHAR2(10);
BEGIN
V_1:=&var1;
—V_2:=&var2;
END;
Why it ask me for a value to var2 ???????????
Does it ignore the — at the begining of the line
(same result with /* */ )
Thanks,
Jose.It is not an error.
There are two parsers here doing their thing. The SQL*Plus Parser. The Oracle (SQL and/or PL/SQL) parser.
SQL*Plus reads a line at a time and processs it. It has no idea whether or a line is actually a comment line for SQL or PL/SQL. It however does see that the line contains a SQL*PLUS substitution variable called &var2. Thus it prompts for a value for this variable (as VERIFY is ON). It substitutes &var2 with the value that the user supplies.
When the SQL*Plus parser encounters the end-of-block marker (the forward slash in this case), it transmits that block to the Oracle Server for execution. There the Oracle Server runs it through the PL/SQL or SQL parsers (depending on whether the block is SQL or anonymous PL/SQL).
Nothing strange about it. Nothing wrong with it. -
Error in Sql plus Logging
[[email protected] ~]$ set oracle_sid=oraclee
[[email protected] ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 — Production on Thu Nov 5 09:35:30 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Error 1:
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup force
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’
Error2:
I created a user through em as gg identified by gg it was succesful ,but i was not able
to login using it…….this s the error which i got , whats the pbm ?
SQL> connect gg
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Edited by: user12076598 on Nov 4, 2009 10:55 PMSet the exact SID. Then statrup.
SQL > startup
OR
SQL > startup pfile = ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’;
Regards
Asif Kabir -
Signal 11 error in SQL Plus report
Hi,
While running the sql plus type of report in oracle apps environment, i’m getting below error in the log after generating half of the o/p.
stat_low = 8B
stat_high = 0
emsg:was terminated by signal 11
Please help if anyone have idea on this.
Thanks in advance,
Devaraj.KPlease post the details of the application release, database version and OS.
While running the sql plus type of report in oracle apps environment, i’m getting below error in the log after generating half of the o/p.
stat_low = 8B
stat_high = 0
emsg:was terminated by signal 11
Please help if anyone have idea on this.Is this a custom or seeded concurrent program?
Please post the contents of the concurrent request log file here.
https://forums.oracle.com/forums/search.jspa?threadID=&q=Signal+AND+11&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
Thanks,
Hussein -
Error with Sql*Plus and Spatial
When i create a new table with a column SDO_GEOMETRY (spatial), i insert a new field.
When i do a simple select * from this table, i receive this error :
SP2-0591: Unable to allocate dynamic space needed (37748736 bytes)
I can’t find any information about this error. I thougth it was an error of the configuration on the server, but i’ve found that SQL*PLUS use lot of virtual space on my PC when i query on ‘Spatial table’ and don’t free this space. After three execution of my query, I receive an error NT ‘Not enough virtual space’!
What do i have to do ?
ThanksYeah, I am also encountering this problem too! Can anyone help?
null -
XML Parser Error in SQL*Plus
I’m getting this error when I try to run the DOMSample:
SQL> exec domsample(‘d:utlfiledir’, ‘family.xml’, ‘errs.out’ )
BEGIN domsample(‘d:utlfiledir’, ‘family.xml’, ‘errs.out’ ); END;
ERROR at line 1:
ORA-29540: class oracle/xml/parser/plsql/XMLParserCover does not exist
ORA-06512: at «SCOTT.XMLPARSERCOVER», line 0
ORA-06512: at «SCOTT.XMLPARSER», line 57
ORA-06512: at «SCOTT.DOMSAMPLE», line 72
ORA-06512: at line 1
I get the same thing with the xslsample. Any ideas?
Thanks,
Lewis
nullOk. I’ve narrowed this down some. The package XMLPARSERCOVER is invalid. I recompile it, and XMLPARSER is invalidated, I rocompile that, my dom and xsl sample procedures are invalidated. Allrighty, I recompile them. Using a select from user objects, I know that now everything is valid. I run my sample and it errors out with the first message again. Guess what, XMLPARSERCOVER is now invalid. Any ideas about this?
Thanks,
Lewis
null -
Foreign key errors in sql plus
Hello, im pretty new to sql and i am stuck on a project in my database management class and i was wondering if anyone can help us out. I don’t know if it would be easier to send what i’ve done or just post the error so if anyone could help it will be appreciated.
This is one part of the sql
CREATE TABLE PREREQUISITE_T
(COURSECODE VARCHAR2(10)NOT NULL,
PREREQUISITECODE VARCHAR2(20),
PRIMARY KEY (COURSECODE),
PRIMARY KEY (PREREQUISITECODE),
FOREIGN KEY (COURSECODE) REFERENCES COURSE_T(COURSECODE),
FOREIGN KEY (PREREQUISITECODE));
INSERT INTO PREREQUISITE_T VALUES (‘23131’, ‘3213’);
INSERT INTO PREREQUISITE_T VALUES (‘23541’, ‘4213’);
INSERT INTO PREREQUISITE_T VALUES (‘23251’, ‘3413’);
INSERT INTO PREREQUISITE_T VALUES (‘56131’, ‘3513’);
INSERT INTO PREREQUISITE_T VALUES (‘75431’, ‘3613’);
INSERT INTO PREREQUISITE_T VALUES (‘45631’, ‘3813’);
INSERT INTO PREREQUISITE_T VALUES (‘65461’, ‘3913’);
INSERT INTO PREREQUISITE_T VALUES (‘45351’, ‘5413’);
the error i get is
ERROR at line 1:
ORA-02298: cannot validate (STUDENT.SYS_C003016) — parent keys not found
It works fine without the primary keys but when i put in foreign keys it is all messed up. If there a a tutorial or anyone could take a look at the rest of the code i can send it out. Any help is appreciated.probably u had given the column value not exists in the reference table.
see the example
create table tst(x number ,y number);
alter table tst add constraints pk_x primary key(x);
create table tst1(x number, y number);
alter table tst1 add constraints fk_x foreign key(x) references tst(x);
SQL> insert into tst values(&x,&y);
Enter value for x: 1
Enter value for y: 2
old 1: insert into tst values(&x,&y)
new 1: insert into tst values(1,2)
1 row created.
SQL> /
Enter value for x: 2
Enter value for y: 3
old 1: insert into tst values(&x,&y)
new 1: insert into tst values(2,3)
1 row created.
SQL> commit;
Commit complete.
SQL> insert into tst1 values(&x,&y);
Enter value for x: 2
Enter value for y: 1
old 1: insert into tst1 values(&x,&y)
new 1: insert into tst1 values(2,1)
1 row created.
SQL> /
Enter value for x: 5
Enter value for y: 6
old 1: insert into tst1 values(&x,&y)
new 1: insert into tst1 values(5,6)
insert into tst1 values(5,6)
ERROR at line 1:
ORA-02291: integrity constraint (SHFLDEV.FK_X) violated — parent key not found -
I am getting the following error using SQL Plus on Windows «ORA-28865: SSL connection closed»
I have set up my certificates on client and server and have tested the port using TCP and works fine. TCPS fails with ORA-28865. I have attached my trace file which was using level 10
Please any assistance is appreciated
(5888) [11-APR-2015 09:36:28:365] nsnainit: NS Connection version: 315
(5888) [11-APR-2015 09:36:28:365] nsnainit: inf->nsinfflg[0]: 0x41 inf->nsinfflg[1]: 0x41
(5888) [11-APR-2015 09:36:28:365] nsnainit: «or» info flags: 0x41 Translations follow:
native service(s) is (are) wanted
(5888) [11-APR-2015 09:36:28:365] nsnainit: «or» info flags: 0x41 Translations follow:
native service(s) is (are) wanted
«and» info flags: 0x41 Translations follow:
native service(s) is (are) wanted
(5888) [11-APR-2015 09:36:28:365] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:365] nsopen: global context check-in (to slot 0) complete
(5888) [11-APR-2015 09:36:28:365] nsopen: lcl[0]=0xf4ffefff, lcl[1]=0x102000, gbl[0]=0xfabf, gbl[1]=0x1, tdu=2097152, sdu=8192
(5888) [11-APR-2015 09:36:28:365] nsfull_opn: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x0
(5888) [11-APR-2015 09:36:28:365] nsfull_opn: nsctx: state=7, flg=0x4001, mvd=0
(5888) [11-APR-2015 09:36:28:365] nsmal: 168 bytes at 0x214d1a0
(5888) [11-APR-2015 09:36:28:365] nsmal: 168 bytes at 0x214dbf0
(5888) [11-APR-2015 09:36:28:365] nsmfr: 239 bytes at 0x20e53a0
(5888) [11-APR-2015 09:36:28:365] nsdo: cid=0, opcode=67, *bl=238, *what=8, uflgs=0x0, cflgs=0x3
(5888) [11-APR-2015 09:36:28:365] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:365] nsdo: rank=64, nsctxrnk=0
(5888) [11-APR-2015 09:36:28:365] nsdo: nsctx: state=14, flg=0x4005, mvd=0
(5888) [11-APR-2015 09:36:28:365] nsdo: gtn=10, gtc=10, ptn=10, ptc=8111
(5888) [11-APR-2015 09:36:28:365] nscon: doing connect handshake…
(5888) [11-APR-2015 09:36:28:365] nscon: sending NSPTCN packet
(5888) [11-APR-2015 09:36:28:365] nspsend: plen=70, type=1
(5888) [11-APR-2015 09:36:28:365] ntzwrite: entry
(5888) [11-APR-2015 09:36:28:365] nzos_Write: entry
(5888) [11-APR-2015 09:36:28:365] nttwr: entry
(5888) [11-APR-2015 09:36:28:365] nttwr: socket 560 had bytes written=99
(5888) [11-APR-2015 09:36:28:365] nttwr: exit
(5888) [11-APR-2015 09:36:28:365] nzos_Write: exit
(5888) [11-APR-2015 09:36:28:365] ntzwrite: exit
(5888) [11-APR-2015 09:36:28:365] nspsend: 70 bytes to transport
(5888) [11-APR-2015 09:36:28:365] nscon: sending 238 bytes connect data
(5888) [11-APR-2015 09:36:28:365] nsdo: cid=0, opcode=67, *bl=238, *what=1, uflgs=0x4002, cflgs=0x0
(5888) [11-APR-2015 09:36:28:365] nsdo: nsctx: state=2, flg=0x4005, mvd=0
(5888) [11-APR-2015 09:36:28:365] nsdo: gtn=10, gtc=10, ptn=10, ptc=431
(5888) [11-APR-2015 09:36:28:365] nsdo: 238 bytes to NS buffer
(5888) [11-APR-2015 09:36:28:365] nsdofls: DATA flags: 0x0
(5888) [11-APR-2015 09:36:28:365] nsdofls: sending NSPTDA packet
(5888) [11-APR-2015 09:36:28:365] nspsend: plen=248, type=6
(5888) [11-APR-2015 09:36:28:365] ntzwrite: entry
(5888) [11-APR-2015 09:36:28:365] nzos_Write: entry
(5888) [11-APR-2015 09:36:28:365] nttwr: entry
(5888) [11-APR-2015 09:36:28:365] nttwr: socket 560 had bytes written=277
(5888) [11-APR-2015 09:36:28:365] nttwr: exit
(5888) [11-APR-2015 09:36:28:365] nzos_Write: exit
(5888) [11-APR-2015 09:36:28:365] ntzwrite: exit
(5888) [11-APR-2015 09:36:28:365] nspsend: 248 bytes to transport
(5888) [11-APR-2015 09:36:28:365] nsdoacts: flushing transport
(5888) [11-APR-2015 09:36:28:365] ntzcontrol: entry
(5888) [11-APR-2015 09:36:28:365] ntzcontrol: Command = 4
(5888) [11-APR-2015 09:36:28:365] ntzcontrol: unknown command 4 — calling underlying protocol adapter
(5888) [11-APR-2015 09:36:28:365] nttctl: entry
(5888) [11-APR-2015 09:36:28:365] ntzcontrol: operation is unsupported
(5888) [11-APR-2015 09:36:28:365] ntzcontrol: exit
(5888) [11-APR-2015 09:36:28:365] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:365] nsdo: nsctxrnk=0
(5888) [11-APR-2015 09:36:28:365] nsdo: cid=0, opcode=68, *bl=2048, *what=9, uflgs=0x0, cflgs=0x3
(5888) [11-APR-2015 09:36:28:365] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:365] nsdo: rank=64, nsctxrnk=0
(5888) [11-APR-2015 09:36:28:365] nsdo: nsctx: state=2, flg=0x4005, mvd=0
(5888) [11-APR-2015 09:36:28:365] nsdo: gtn=10, gtc=10, ptn=10, ptc=8111
(5888) [11-APR-2015 09:36:28:380] nscon: recving a packet
(5888) [11-APR-2015 09:36:28:380] nsprecv: reading from transport…
(5888) [11-APR-2015 09:36:28:380] ntzread: entry
(5888) [11-APR-2015 09:36:28:380] ntznzosread: entry
(5888) [11-APR-2015 09:36:28:380] nzos_Read: entry
(5888) [11-APR-2015 09:36:28:380] nttrd: entry
(5888) [11-APR-2015 09:36:28:380] ntt2err: entry
(5888) [11-APR-2015 09:36:28:380] ntt2err: exit
(5888) [11-APR-2015 09:36:28:380] nttrd: socket 560 had bytes read=0
(5888) [11-APR-2015 09:36:28:380] nttrd: exit
(5888) [11-APR-2015 09:36:28:380] nzos_Read: exit
(5888) [11-APR-2015 09:36:28:380] ntznzosread: encountered «wouldblock» error
(5888) [11-APR-2015 09:36:28:380] ntctst: size of NTTEST list is 1 — not calling poll
(5888) [11-APR-2015 09:36:28:396] nzos_Read: entry
(5888) [11-APR-2015 09:36:28:396] nttrd: entry
(5888) [11-APR-2015 09:36:28:396] nttrd: exit
(5888) [11-APR-2015 09:36:28:396] ntt2err: entry
(5888) [11-APR-2015 09:36:28:396] ntt2err: Read unexpected EOF ERROR on 560
(5888) [11-APR-2015 09:36:28:396] ntt2err: exit
(5888) [11-APR-2015 09:36:28:396] nzos_Read: exit
(5888) [11-APR-2015 09:36:28:396] ntznzosread: SSL connection closed gracefully.
(5888) [11-APR-2015 09:36:28:396] ntznzosread: SSL connection terminated normally.
(5888) [11-APR-2015 09:36:28:396] ntznzosread: returning NZ error 28865 in result structure
(5888) [11-APR-2015 09:36:28:396] ntznzosread: exit
(5888) [11-APR-2015 09:36:28:396] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=28865, ora[1]=0, ora[2]=0
(5888) [11-APR-2015 09:36:28:396] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:396] nsdo: nsctxrnk=0
(5888) [11-APR-2015 09:36:28:396] nscall: unexpected response
(5888) [11-APR-2015 09:36:28:396] nsvntx_dei: entry
(5888) [11-APR-2015 09:36:28:396] nsvntx_dei: exit
(5888) [11-APR-2015 09:36:28:396] nstimarmed: no timer allocated
(5888) [11-APR-2015 09:36:28:396] ntzcontrol: entry
(5888) [11-APR-2015 09:36:28:396] ntzcontrol: Command = 14
(5888) [11-APR-2015 09:36:28:396] ntzcontrol: exit
(5888) [11-APR-2015 09:36:28:396] ntzcontrol: entry
(5888) [11-APR-2015 09:36:28:396] ntzcontrol: Command = 15
(5888) [11-APR-2015 09:36:28:396] ntzcontrol: exit
(5888) [11-APR-2015 09:36:28:396] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:396] nsfull_cls: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x440
(5888) [11-APR-2015 09:36:28:396] nsfull_cls: nsctx: state=1, flg=0x4001, mvd=0
(5888) [11-APR-2015 09:36:28:396] nsclose: closing transport
(5888) [11-APR-2015 09:36:28:396] ntzdisconnect: entry
(5888) [11-APR-2015 09:36:28:396] ntzFreeNTZData: entry
(5888) [11-APR-2015 09:36:28:396] nzos_DestroyCtx: entry
(5888) [11-APR-2015 09:36:28:396] nzos_DestroyCtx: exit
(5888) [11-APR-2015 09:36:28:396] ntzFreeNTZData: exit
(5888) [11-APR-2015 09:36:28:396] nttdisc: entry
(5888) [11-APR-2015 09:36:28:396] nttdisc: Closed socket 560
(5888) [11-APR-2015 09:36:28:396] nttdisc: exit
(5888) [11-APR-2015 09:36:28:396] ntzdisconnect: exit
(5888) [11-APR-2015 09:36:28:396] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:396] nsclose: global context check-out (from slot 0) complete
(5888) [11-APR-2015 09:36:28:396] nadisc: entry
(5888) [11-APR-2015 09:36:28:396] nacomtm: entry
(5888) [11-APR-2015 09:36:28:396] nacompd: entry
(5888) [11-APR-2015 09:36:28:396] nacompd: exit
(5888) [11-APR-2015 09:36:28:396] nacompd: entry
(5888) [11-APR-2015 09:36:28:396] nacompd: exit
(5888) [11-APR-2015 09:36:28:396] nacomtm: exit
(5888) [11-APR-2015 09:36:28:396] nas_dis: entry
(5888) [11-APR-2015 09:36:28:396] nas_dis: exit
(5888) [11-APR-2015 09:36:28:396] nau_dis: entry
(5888) [11-APR-2015 09:36:28:396] nau_dis: exit
(5888) [11-APR-2015 09:36:28:396] naeetrm: entry
(5888) [11-APR-2015 09:36:28:396] naeetrm: exit
(5888) [11-APR-2015 09:36:28:396] naectrm: entry
(5888) [11-APR-2015 09:36:28:396] naectrm: exit
(5888) [11-APR-2015 09:36:28:396] nagbltrm: entry
(5888) [11-APR-2015 09:36:28:396] nau_gtm: entry
(5888) [11-APR-2015 09:36:28:396] nau_gtm: exit
(5888) [11-APR-2015 09:36:28:396] nagbltrm: exit
(5888) [11-APR-2015 09:36:28:396] nadisc: exit
(5888) [11-APR-2015 09:36:28:396] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:396] nsvntx_dei: entry
(5888) [11-APR-2015 09:36:28:396] nsvntx_dei: exit
(5888) [11-APR-2015 09:36:28:396] snsbitts_ts: acquired the bit
(5888) [11-APR-2015 09:36:28:396] nsmfr: 2944 bytes at 0x2152400
(5888) [11-APR-2015 09:36:28:396] nsmfr: 1880 bytes at 0x2151ca0
(5888) [11-APR-2015 09:36:28:396] nscall: connecting…
(5888) [11-APR-2015 09:36:28:396] nladget: entry
(5888) [11-APR-2015 09:36:28:396] nladget: exit
(5888) [11-APR-2015 09:36:28:396] nsmfr: 238 bytes at 0x221def0
(5888) [11-APR-2015 09:36:28:412] nsmfr: 304 bytes at 0x20d8200
(5888) [11-APR-2015 09:36:28:412] nladtrm: entry
(5888) [11-APR-2015 09:36:28:412] nladtrm: exit
(5888) [11-APR-2015 09:36:28:412] nioqper: error from nscall
(5888) [11-APR-2015 09:36:28:412] nioqper: ns main err code: 12537
(5888) [11-APR-2015 09:36:28:412] nioqper: ns (2) err code: 12560
(5888) [11-APR-2015 09:36:28:412] nioqper: nt main err code: 507
(5888) [11-APR-2015 09:36:28:412] nioqper: nt (2) err code: 0
(5888) [11-APR-2015 09:36:28:412] nioqper: nt OS err code: 0
(5888) [11-APR-2015 09:36:28:412] niomapnserror: entry
(5888) [11-APR-2015 09:36:28:412] niqme: entry
(5888) [11-APR-2015 09:36:28:412] niqme: reporting ORA-28865 error
(5888) [11-APR-2015 09:36:28:412] niqme: exit
(5888) [11-APR-2015 09:36:28:412] niomapnserror: exit
(5888) [11-APR-2015 09:36:28:412] niotns: Couldn’t connect, returning 28865
(5888) [11-APR-2015 09:36:28:412] niotns: exit
(5888) [11-APR-2015 09:36:28:412] nsbrfr: nsbfs at 0x214d1a0, data at 0x2225ca0.
(5888) [11-APR-2015 09:36:28:412] nsbrfr: nsbfs at 0x214dbf0, data at 0x2227d90.
(5888) [11-APR-2015 09:36:28:412] nsbrfr: nsbfs at 0x214d9e0, data at 0x21531c0.
(5888) [11-APR-2015 09:36:28:412] nigtrm: Count in the NI global area is now 1
(5888) [11-APR-2015 09:36:28:412] nigtrm: Count in the NL global area is now 1CLIENT SQLNET.ORA
TRACE_LEVEL_CLIENT = 10
TRACE_UNIQUE_CLIENT = ON
TRACE_DIRECTORY_CLIENT = C:Oracleappclientproduct12.1.0client_1networktrace
TRACE_FILE_CLIENT = sqlnet_client.trc
LOG_FILE_CLIENT = sqlnet_client.log
LOG_DIRECTORY_CLIENT = C:Oracleappclientproduct12.1.0client_1networklog
DIAG_ADR_ENABLED = OFF
TRACE_TIMESTAMP_CLIENT = ON
SQLNET.AUTHENTICATION_SERVICES = (ALL)
SQLNET.AUTHENTICATION_REQUIRED = FALSE
SSL_CLIENT_AUTHENTICATION = FALSE
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:Oracleappclientproduct12.1.0client_1networkwallets)
ADR_BASE = C:Oracleappclientproduct12.1.0client_1log
SERVER SQLNET.ORA
SQLNET.AUTHENTICATION_SERVICES= (ALL)
SSL_VERSION = 0
SSL_CLIENT_AUTHENTICATION = FALSE
TRACE_UNIQUE_SERVER = ON
TRACE_DIRECTORY_SERVER = /u01/app/grid/product/12.1.0/12.1.0.2/network/trace
TRACE_FILE_SERVER = sqlnet_server.trc
LOG_FILE_SERVER = sqlnet_server.log
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /u01/app/grid/product/12.1.0/12.1.0.2/owm/wallets/grid)
LOG_DIRECTORY_SERVER = /u01/app/grid/product/12.1.0/12.1.0.2/network/log
SQLNET.AUTHENTICATION_REQUIRED = FALSE
DIAG_ADR_ENABLED = OFF
TRACE_TIMESTAMP_SERVER = ON -
SQL Plus error
I’m working with Ubuntu 10.04 Server.
I just installed Oracle XE 11g (11.2.0 specifically)
All I did was download the .rpm file and converted it to a deb (using alien) and then ran the deb (using dpkg). Everything seems to be installed fine however when I try to run sqlplus I get the following message:
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1(lang).msb file not found
SP2-0750: You may need to set your ORACLE_HOME to your Oracle software directory
However the oracle_env.sh states that ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe which is the correct path (at least I think it is). So does anyone know what the issue is?
ThanksI’ve checked all of the log files in the log directory and there doesn’t seem to have been any errors in them.That’s good. So we can assume most things worked as intended.
Path looks wrong… But no idea how it got to be wrong or how to fix it.It does. Did you execute the following from Step 9)
echo «» >>./.profile
echo ‘. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh’ >>./.profileThis should set up your environment as needed. In the guide, this had been done for the «oracle» user only. If you use a different account, you’ll have to either source or include that environment script as well.
Please also check whether it has been created correctly by running
cat /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.shThe output should read
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export PATH=$ORACLE_HOME/bin:$PATHThough possibly not mandatory, you could add
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libto that script. This will set the library path to include the oracle libraries, such as client libraries.
LANG-settings are okay, by the way.
-Udo
Edited by: Udo on 26.03.2012 16:02 -
Im getting this error after trying to laounch SQL*Plus
Hallo, guys!
Help me on this one. I’m new to Oracle on Windows 2000 Professional
Im getting this error after trying to laounch SQL*Plus
Error 6 Initializing SQL*Plus
Message file spl<lang>.msb not found
SP2-0750:You may need to set ORACLE_HOME to your Oracle Software directory
Urgent please respond
Thanks
sridharVerify the contents of the following subkey in your Windows2000 registry:
HKEY_LOCAL_MACHINESOFTWAREORACLEHKEY_LOCAL_MACHINESOFTWAREORACLEKEY_YOUR_HOME_NAME
Your Windows 2000 registry must contain several minimum parameters, defined as registry entries inside the above subkey (See http://download-east.oracle.com/docs/cd/B19306_01/win.102/b14304/registry.htm#i1006544). One of them is ORACLE_HOME, which could have been accidentally removed or changed. ORACLE_HOME must contain the home OS path to the SQL*Plus executable in your machine (For example, C:OracleOraDB10g). I tried changing the name of the ORACLE_HOME registry entry in my machine and received the same exact messages you did when launching SQL*Plus.
In your OS, verify also Control Panel > System Properties > Advanced > Environment Variables > System Variables > Path, and make sure the above ORACLE_HOME’s path is included in the Path variable (preferably in the starting position)
Regards,
Luis Morales
ConsiteNicaragua.com -
SQL Plus Login issue
Please assist…when i am trying to login following error is occuring ….
Enter user-name: / as sysdba
ERROR:
ORA-01031: Message 1031 not found; No message file for product=RDBMS,
facility=ORAMaran thanks for the prompts replies, i have already set the variables & restarted the machine but there is no change. please see below;
C:Documents and SettingsAdministrator>sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
C:Documents and SettingsAdministrator>d:
D:>cd oracle
D:oracle>cd ora92
D:oracleora92>cd bin
D:oracleora92bin>sqlplus
SQL*Plus: Release 9.2.0.6.0 — Production on Fri May 11 17:31:09 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-01031: Message 1031 not found; No message file for product=RDBMS,
facility=ORA
Maybe you are looking for
-
Banner size video — how can I set the canvas to an odd size?
I’m interested in creating web page ad banners that include some looping video. Is there a way to set the canvas size to 350×250 or some other odd size? If not, do you know if any other video editing software can allow this? Thanks, DAN PowerBook G4
-
Compressor job controller, compressor trancoder
After quitting FCP7 my computer refuses to stay in sleep mode. Consulting Activity Monitor, I see that the above mentioned two processes are in red, and I have to force quit them. Are these things related, and is there a fix?
-
What can i do to fix the following : You may need an additional audio decoder to play the soundtrack of this file. This file contains a track in the Dolby AC3 Audio (code «8192») format. You may need to install a DirectShow decoder for this audio format i
You may need an additional audio decoder to play the soundtrack of this file. This file contains a track in the Dolby AC3 Audio (code «8192») format. You may need to install a DirectShow decoder for this audio format in order to hear the soundtrack o
-
ADD a new connection to sql developer
Hi, i downloaded the sql developer from the main site .i tried to adding a new connection.it showed the error no network adapter found . first let me confirm one thing the database name and username,password are predefined ones are should i need to c
-
Logic Pro unavailable!
I’ve tried to download my regularly purchased Logic Pro 9 from the Apple Store. Some time has passed since the last time I’ve used, but now I’d need to get it again. The store now says it’s unavailable! Weird, less than a year has passed since then.