Posted on 2013-06-14
Last Modified: 2013-07-13
SQL> show alert tail
SP2-0158: unknown SHOW option "alert"
SP2-0158: unknown SHOW option "tail"
SP2-0158: unknown SHOW option "ALERT"
SP2-0158: unknown SHOW option "-TAIL"
SQL> select name from v$database;


Question by:walkerdba
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +2
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39250670
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.

Author Comment

ID: 39250944
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

su: incorrect password
[oracle@mac ~]$
[oracle@mac ~]$
[oracle@mac ~]$ su - root
[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 ~]#
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39251563
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.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 15

Accepted Solution

Franck Pachot earned 500 total points
ID: 39252788
'show alert -tail' is not a sqlplus command, but an ADRCI command.
LVL 12

Expert Comment

by:Praveen Kumar Chandrashekatr
ID: 39252819
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
LVL 23

Expert Comment

ID: 39256929
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.

Author Comment

ID: 39282740
LVL 23

Expert Comment

ID: 39283183
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.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39283212
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.

Author Closing Comment

ID: 39324243

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Error querying database link from Oracle 10g to Postgresql 7 133
Help with Oracle IF statment 5 47
Oracle performance tuning 2 52
Performance Issue in Oracle 3 43
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question