1,105,585 Community Members

SQL*Plus username password

Member Avatar
pranavdv
Light Poster
26 posts since Mar 2007
Reputation Points: -2 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
-2
 

Hello friends,

i m trying to input user : scott and pass : tiger
also trying user : system pass : manager

but even though its not going to start. i m getting following error

SQL*Plus: Release 3.3.4.0.0

ERROR: ORA-12154: TNS:could not resolve service name


Enter user-name:
Enter password:
ERROR: ORA-03121: no interface driver connected - function not performed


Enter user-name:

please help me to solve this problem

Member Avatar
debasisdas
Posting Genius
6,542 posts since Feb 2007
Reputation Points: 580 [?]
Q&As Helped to Solve: 476 [?]
Skill Endorsements: 25 [?]
Featured
 
0
 

to solve your problem i need few information from you.

1. is the database installed on your PC ?
2. are you trying to log in to a database in a network ?
3.is the scott user exists and and is unlocked ?

Member Avatar
amr_tot
Newbie Poster
1 post since Mar 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

create user scott identified by tiger ;

Member Avatar
debasisdas
Posting Genius
6,542 posts since Feb 2007
Reputation Points: 580 [?]
Q&As Helped to Solve: 476 [?]
Skill Endorsements: 25 [?]
Featured
 
0
 

to do that you need to log in first and normal users can't create another user .

Member Avatar
vimotaru
Newbie Poster
17 posts since Oct 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

This error

ERROR: ORA-12154: TNS:could not resolve service name

only appears when you don't have an instance of a database or you don't have the listener on.

Make sure you have the DB online and the listener.

You can view the listener status with: 'lsnrctl status' and start it with 'lsnrctl start'.

When the listener is running, you can enter as sysdba (defined when the DB is installed) and type an 'startup' command to start the database you have define. Use 'startup db_sid' if you have more than one.

Hope it helped.

Member Avatar
gautam610
Newbie Poster
13 posts since Jul 2008
Reputation Points: -5 [?]
Q&As Helped to Solve: 3 [?]
Skill Endorsements: 0 [?]
 
0
 

check scott is unlock or not ............
& for system ...........
did you change the password at the time of installation or not.......

Member Avatar
mirfan00
Light Poster
29 posts since May 2009
Reputation Points: -19 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

At the end of instalation programs diplay a screen with name password managemant. You just go to password management screen anf unblock all the users anf=d just fix your user and password.

Member Avatar
manuhar
Newbie Poster
11 posts since May 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

Hey this is surely a problem of uncloking the users bt once check out if u have enabled the serices of oracle installed

Member Avatar
alit2002
Junior Poster in Training
52 posts since Dec 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 3 [?]
Skill Endorsements: 0 [?]
 
0
 

Er guys, SqlPlus 3.3.4.0.0? Isn't this from the days of Oracle 7?

I would think we would need to know more about your config before we could really help!

client / server, versions of oracle and client, where components are installed etc.

Your error suggests that the oracle client components are not installed / not in the path / wrong oracle_home selected - to name but a few possibilities!

Alistair

Member Avatar
sagarsb
Newbie Poster
2 posts since Nov 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Oracle 11g sql plus it show account is locked it showing enter user name &password

Member Avatar
sagarsb
Newbie Poster
2 posts since Nov 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

send me a user name and password

Member Avatar
debasisdas
Posting Genius
6,542 posts since Feb 2007
Reputation Points: 580 [?]
Q&As Helped to Solve: 476 [?]
Skill Endorsements: 25 [?]
Featured
 
0
 

in oracle 11g credentials are case sensitive unlike any of the previous versions.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article