| No SQL-Prompt [message #60991] |
Thu, 18 March 2004 03:34  |
Manfred Himmler
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
On each of 3 UNIX-Servers (AIX4.3.3, Oracle8i) I created a new user with the same environment as user oracle.
After connect with SQLPLUS on 2 Servers I get no SQL-Prompt back, with user oracle no problem.
Any idea?
Thanks a lot for help.
|
|
|
|
| Re: No SQL-Prompt [message #60994 is a reply to message #60991] |
Thu, 18 March 2004 03:54  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
This is either a UNIX problem or you are running SQL*Plus is silent mode. Do a "SHOW USER" to see it sqlplus is responding. If not, ask your Unix sysadmin to trace the process (truss or the AIX equivalent).
Best regards.
Frank
|
|
|
|
| Re: No SQL-Prompt [message #60998 is a reply to message #60994] |
Thu, 18 March 2004 04:43 |
Manfred Himmler
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
I tried on several unix-servers (AIX433). creating a new os-user, setting oracle-environment, connecting as os-user, starting sqlplus, type userid and passwort.
On some server I get a sql-prompt, on others I get no prompt. No matter, what version of Oracle.
|
|
|
|
| Re: No SQL-Prompt [message #61007 is a reply to message #60991] |
Fri, 19 March 2004 05:18 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
did you try
% which sqlplus
should be $ORACLE_HOME/bin/sqlplus
I use AIX (4.3.3 and now 5L) and have had no problems. I have used Oracle 816, 817, 920 on these OS.
Can you show the sys variables listed below:
ORACLE_SID
ORACLE_HOME
LD_LIBRARY_PATH
SHLIB_PATH
LIBPATH
and PATH ??
|
|
|
|
| Re: No SQL-Prompt [message #61009 is a reply to message #61007] |
Fri, 19 March 2004 05:31 |
Manfred Himmler
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
I tried the same on different other AIX-servers with different Oracle-Versions (7.3.3, 8.1.5, 8.1.6, 8.1.7) but this problem exists only on one server. When I connect with string "sqlplus user/password@db.world" then it curiously ;-) works. At this moment I do a new installation of my ORACLE_HOME. I let you know what happens then.
Thanks and best regards
Manfred
|
|
|
|
| Re: No SQL-Prompt [message #61013 is a reply to message #60998] |
Fri, 19 March 2004 08:54 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
Try to view and setup the file login.sql in directory ${ORACLE_HOME}/sqlplus/admin. sqlplus execute this script every time when starts and set prompt as you want.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
