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

Recommended Answers

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 ?

Jump to Post

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

Jump to Post

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' …

Jump to Post

All 11 Replies

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 ?

create user scott identified by tiger ;

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

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.

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

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

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

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

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

send me a user name and password

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.