• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 663
  • Last Modified:

alert

SQL> show alert tail
SP2-0158: unknown SHOW option "alert"
SP2-0158: unknown SHOW option "tail"
SQL> SHOW ALERT -TAIL
SP2-0158: unknown SHOW option "ALERT"
SP2-0158: unknown SHOW option "-TAIL"
SQL> select name from v$database;

NAME
---------
ACC

SQL>
0
walkerdba
Asked:
walkerdba
  • 3
  • 3
  • 2
  • +2
1 Solution
 
slightwv (䄆 Netminder) Commented:
The messages are pretty descriptive:
There is no ALERT sqlplus command.   Let along something with -TAIL.

What are you trying to do?

Where did you get that command from?

Are you trying to use the UNIX tail command on the alert log?

tail -f alertACC.log

If so, that is an OS command not a sqlplus command.
0
 
walkerdbaAuthor Commented:
What is this sir

oracle@mac ~]$ SHOW ALERT -TAIL
bash: SHOW: command not found
[oracle@mac ~]$ tail -f alertACC.log
tail: cannot open `alertACC.log' for reading: No such file or directory
tail: no files remaining
[oracle@mac ~]$ su -root
su: invalid option -- r
Try `su --help' for more information.
[oracle@mac ~]$ su - root
Password:

su: incorrect password
[oracle@mac ~]$
[oracle@mac ~]$
[oracle@mac ~]$ su - root
Password:
[root@mac ~]# tail -f alertACC.log
tail: cannot open `alertACC.log' for reading: No such file or directory
tail: no files remaining
[root@mac ~]# SHOW ALERT -TAIL
-bash: SHOW: command not found
[root@mac ~]#
0
 
slightwv (䄆 Netminder) Commented:
Based on your previous questions, I assume you are following some script/blog you found on the Internet.

What are you trying to do?

Where did you get the ALERT -TAIL command from?

For the Unix tail command, check out the map page: man tail

The file you are tailing needs to be in the folder you are setting in or you need to fully qualify it.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Franck PachotCommented:
Hi,
'show alert -tail' is not a sqlplus command, but an ADRCI command.
See: http://nolan-davies.blogspot.ch/2011/01/how-to-tail-oracle-alert-log-with-adrci.html#!/2011/01/how-to-tail-oracle-alert-log-with-adrci.html
Regards,
Franck.
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
First let us know what is that you are looking for?

are you trying to tail the alertACC.log file then as Slightwv mention in is post tail is an OS command, so first go to the path where alertACC.log file exists i.e

SQL>show parameter background_dump_dest;

now use the tail command by going into the path as mention in above o/p.

i.e  [oracle@mac ~]$cd <</diag/rdbms/orcl/orcl/trace>>
 [oracle@trace ~]$ls -ltr
[oracle@trace ~]$tail -f alertACC.log
0
 
DavidSenior Oracle Database AdministratorCommented:
Perhaps, to run a LINUX/UNIX O/S command from within SQL*Plus, use the host command, for example:

SQL> ......
host tail -f alertACC.log
......

Since  the host escape pauses the SQL command flow, you must exit from the O/S session to pop back into SQL*Plus and resume the script.
0
 
walkerdbaAuthor Commented:
good
0
 
DavidSenior Oracle Database AdministratorCommented:
fwiw, the thread suggested that the author was not grasping your use of the tail command, until I added the context of using host to escape from a SQL script.
0
 
slightwv (䄆 Netminder) Commented:
If they were asking about the tail OS command, I agree that your post offered value.  The host command added value to a previous post thus, IMO, should at least have been a split.

Given the context of the original command "SHOW ALERT -TAIL" which isn't even close the the OS tail command and an exact match to the ADCRI command, I truly think this was the correct answer.

It is up to walkerdba to clarify exactly what they were after and determine the correct answer(s) to this question.
0
 
walkerdbaAuthor Commented:
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now