Not able to read redo log file on AIX box


 
Thread Tools Search this Thread
Operating Systems AIX Not able to read redo log file on AIX box
# 1  
Old 04-18-2013
Not able to read redo log file on AIX box

I have a oracle 10 G database installed on AIX6.1) server.

The database user creates online redo log files with permissions 640 i.e. read access to group oinstall

I am not able to read the files with another user part of the group oinstall. even tried to copy the files to another location, but it failed with error "filename" invalid argument.

Even the admin person with root login was not able to copy the file to another location.

Please help
# 2  
Old 04-18-2013
Using code tags, can you show what happens when you try to read or copy the file, with the exact error message copy / pasted?

Any chance blanks or other "funny" characters in the file name? Can you show what happens when you "ls" the file, with code tags?
# 3  
Old 04-18-2013
"even tried to copy the files to another location, but it failed with error "filename" invalid argument."

Yeah, sounds like you have an invalid file name - like a space in it!
# 4  
Old 04-19-2013
if you go to the directory - use od -c /some/directory to see the first 14 characters of the filename (ignore the first two characters, they are the inode)
use od -dc /some/directory to see both inode and filename (on separate lines)

or - use
Code:
$ ls -i # to determine the inode number
$ find . -inum XXXX -exec cp {} new_name.log \;

# 5  
Old 04-19-2013
You might be interested in a little primer i wrote about dealing with files with odd characters in their name.

I hope this helps.

bakunin
# 6  
Old 04-19-2013
for the filename with the / character you could try using the find -inum method to hardlink, but better (imho) would be cp to get a new inode and file, then after moving everything else away, delete the filesystem with the malformed file.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read file input in while loop does not work on AIX system

I'm working on Aix 6.1 and using ksh shell. The below works fine on Linux bash or ksh shell . while IFS= read -r dirpath ; do echo "Hi" done <<<"$var" However, any such while loop that reads the input from file or variable using <<< fails on Aix system with the below error: Below... (2 Replies)
Discussion started by: mohtashims
2 Replies

2. How to Post in the The UNIX and Linux Forums

Copying , renaming the file from windox box and ftp to Linux box

Hello my dear friends, Two file are auto generated from mon - fri at different directories on same windows box.Every day i have to copy the file, rename it (specific name)and ftp it to linux box specified directory. is it possible to automate this process,If yes this has to be done from windows... (1 Reply)
Discussion started by: umesh yadav
1 Replies

3. UNIX Desktop Questions & Answers

AIX how to read the file in function again and again

dear friends I have a wrote a shell script which works like this. 1.) a command is executed and the log is moved in the file. 2.) this file is copied in to the other file. 3.) used a grep command to find a particular word. 4.) if a particular word is there then the script will go to next... (4 Replies)
Discussion started by: aboy212u
4 Replies

4. UNIX for Advanced & Expert Users

How UNIX/AIX handles a file deep down, say it's being read while another one tries to rename it?

Hi Thinkers, On AIX 5.3, we have a monitor program that reads the log file and searching for a certain string pattern that we define(say "transactionException"), if it sees it then it will raise an alert by sending an email. Because the log file XXX.log is rolling into XXX.log.0, XXX.log.1,... (2 Replies)
Discussion started by: TheGunMan
2 Replies

5. Shell Programming and Scripting

AIX file read for file name script

Hi al, Im trying to write something to read a date file and append each date to my file output name. Datefile: 20091001 20091015 Final output file I would like is: DATA_20091001_20091015.xls The script Im trying, but not working, is n=`wc -l < dates_yymmdd.txt` i=1 (2 Replies)
Discussion started by: NycUnxer
2 Replies

6. Shell Programming and Scripting

ftp file starting with particular name on Windows box to Unix box using shell script

Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies

7. Shell Programming and Scripting

syntax error, need to redo one line in script :(

I have a script that processes a file with two columns (IDs and Idle session times): # cat /tmp/idle-ids.lst user1 2,390 user2 97 user3 93 user4 67 user5 56 user6 33 user7 22 user8 6 user9 2 user10 0 my script works, but has... (4 Replies)
Discussion started by: mr_manny
4 Replies

8. UNIX for Dummies Questions & Answers

difference between AIX box and Sun Solaris box

Hi, I need a clarification. Is there any difference between AIX box and Sun Solaris box? The bzip command with -c option works in AIX box and the same does not work in Sun Solaris box. Can anyone please explain if there is an implementation difference in both these boxes for the shell... (1 Reply)
Discussion started by: nisha4680
1 Replies

9. AIX

moving AIX ver 4.2.1 to another AIX box

i want to move my AIX os ver 4.2.1 to a new version IBM system. how can i acheive this. (1 Reply)
Discussion started by: gmonix
1 Replies

10. UNIX for Advanced & Expert Users

How to FTP a file generated at UNIX Box to NT Box

Hi all, I am generating a file on the Unix machine , now i want to FTP the same file to the NT machine. how can i do that and the application currently upon which i am working is a JAVA based application. I need your help. regards Ruchir (2 Replies)
Discussion started by: Ruchir
2 Replies
Login or Register to Ask a Question