Home » Other » Client Tools » Not able to launch sql prompt after entering user name and pwd (Oracle 10g)
Not able to launch sql prompt after entering user name and pwd [message #527295] Mon, 17 October 2011 06:55 Go to next message
hari1
Messages: 5
Registered: October 2011
Junior Member
Hi,
Please help me with regard to
I have installed Oracle 10 g and also changed the password of Scott,System users during installation via password management.
When I am click on sql plus icon to launch sql and entering user name : Scoot
pwd :Tiger

It get closed and nothing is coming up.

please help me regarding this as I am new to database
Re: Not able to launch sql prompt after entering user name and pwd [message #527302 is a reply to message #527295] Mon, 17 October 2011 07:47 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try with operating system's command prompt; it won't close and might reveal some useful information. Here's how it looks like for me - copy/paste YOUR session so that we could see what's going on:
M:\>sqlplus scott/tiger@ora10

SQL*Plus: Release 10.2.0.1.0 - Production on Pon Lis 17 14:46:23 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


Session altered.


Session altered.

SQL>
Re: Not able to launch sql prompt after entering user name and pwd [message #527304 is a reply to message #527302] Mon, 17 October 2011 07:51 Go to previous messageGo to next message
hari1
Messages: 5
Registered: October 2011
Junior Member

Thanks for reply

M:\>sqlplus scott/tiger@ora10
What does it refer to : Does it means that on the command prompt i need to give the path wheateve path for sql installation i have given.

Re: Not able to launch sql prompt after entering user name and pwd [message #527306 is a reply to message #527302] Mon, 17 October 2011 07:56 Go to previous messageGo to next message
hari1
Messages: 5
Registered: October 2011
Junior Member
Upon executing C:\>sqlplus scott/tiger@orcle

I am getting the following error
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
Re: Not able to launch sql prompt after entering user name and pwd [message #527308 is a reply to message #527304] Mon, 17 October 2011 07:58 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
sqlplus scott/tiger@ora10
=
login using scott
with password tiger
use connection ora10 (usually defined in tnsnames.ora or sincd oracle 10 it is possible to use an instant-client connection)

sqlplus /?
the internet
official documentation for more info

[Updated on: Mon, 17 October 2011 07:59]

Report message to a moderator

Re: Not able to launch sql prompt after entering user name and pwd [message #527311 is a reply to message #527308] Mon, 17 October 2011 08:06 Go to previous messageGo to next message
hari1
Messages: 5
Registered: October 2011
Junior Member
I have used the same but not responding.
Re: Not able to launch sql prompt after entering user name and pwd [message #527312 is a reply to message #527311] Mon, 17 October 2011 08:07 Go to previous messageGo to next message
hari1
Messages: 5
Registered: October 2011
Junior Member
Hi Little foot,
I have seen some help from your side , Can you please elobrate more on this as I am getting the error which I have specified.
Re: Not able to launch sql prompt after entering user name and pwd [message #527360 is a reply to message #527312] Mon, 17 October 2011 14:56 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does this help? (pay attention to @ziarkowski's message)
Previous Topic: Oracle User Management
Next Topic: Spool out hangs after successful execution. How to avoid it?
Goto Forum:
  


Current Time: Thu Mar 28 15:26:00 CDT 2024