on 10-28-2013 2:43 AM
Hi Team,
We are facing the below issue while performing the backup. Kindly look into this issue and suggest me any solution for this.
OS : HP-UX
DB : Oracle 11g
Error 45 initializing SQL*Plus
Internal Error
Log out
Session remote exec script on host failed . Exit code = 127.
Thanks,
Pavan.
Hi Pavan,
pls check this thread for above error
This error occurs because SQL*Plus could not allocate memory after the OCFS filesystem was incorporated.
The datavolume option ensures that the Oracle processes open these files with the "O_DIRECT" flag. When mounting with "datavolume" option, all the files open will be forced to use "O_DIRECT" flag. SQL*Plus is not aware of this and as a result, reading with O_DIRECT flag fails due to unaligned memory address of the buffer. The memory is already allocated, just the read() fails.
This solution should be completed by the HP-UX/Unix System Administrator.
Solution
========
1. Stop the Database.
2. Unmount the OCFS ORACLE_HOME.
umount [options] filesystem
3. A normal mount would be like the following:
mount -t ocfs -o datavolume /dev/sdc1 /u02/../ocfs
It is suggested to mount the OCFS ORACLE_HOME without the 'datavolume' option
mount -t ocfs -o
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you please try to run the command at os level.
can you try to manually run the command at os level and see if it works.
Try to enable trace and see where it exactly fails.
Hope all the binary related to brtools are fine and have correct permission.
Did you do a kernel upgrade and copied the correct binary.
1780001 - How to increase the trace level for the br*tools jobs which are scheduled in DB13
If you are using any script.
SQL*Plus you could do :
set echo on
@your_script
and check the exact statement it fails on
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavan,
Unable to see the image.
Are you scheduling it using any script?
Regards,
Raja. G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.