Connect to database

[qqq]

Hello,
I have gote a problem to connect to database. When I try to open SQLPlus8 or Enterprize Manager using username "system" and password "manager" it produce error :no listener found or cannot resolve service name. This server and databases were created long time ago by someone who does not work for this company any more . He left user name and passwords which does not work.
I'll be really appreciate any ideas.

 

[sem]

This error does not mean wrong username/password, but wrong [tnsnames|sqlnet|listener].ora files.

 

[karluk]

It's also possible that you gave an incorrect SID when connecting. That's the likely explanation if you are using machines that were working properly when the previous DBA was there. If you are trying to install a new client, on the other hand, I would suspect a problem with tnsnames.ora or sqlnet.ora

 

[qqq]

Thankyou for reply,
but it is not clear for me what I should do to fix this problem?
I'm sorry but I'm new in Oracle.
Regards

 

[hoctro]

Error: could not resolve service name meaning you need to check your ORACLE_SID environment and the Service name in TNSNAMES.ORA file in $ORACLE_HOME/network directory

Make sure your environments esp ORACLE_SID is set correctly (is it the Sid you want to use ? )
Try stop and start the listener using lsnrctl in $ORACLE_HOME/bin directory
Start "svrmgrl" in bin directory
Type "connect system/manager"


Hope it helps

 

[girimak123]

I have similar problem, some one kept username/password and left the org. It dosn't work now. How did you solve this issue? Your experience will be very valuable.
Thanks in advance,

 

[sem]

You may connect as any other "poweruser", who is granted "alter user" or DBA and change password for that account.

Regards, Dima

 

[kenneth007]

your listener may not be up
logon to your server as oracle
lsnrctl>stop
lsnrctl>start

[ try connecting if fails ]

goto /network/admin directory
vi tnsnames.ora
see if you can find the connect string for the database. eg abc.world

on the client side.
you need to configure your tnsnames.ora on your pc as well.
network dir in your client software.
make sure your client knows where to find abc.world

abc.world = (DESCRIPTION=
(ADDRESS=
(COMMUNITY=tcp.world)
(PROTOCOL=TCP)
(HOST=<hostname or ip address where db sits>)
(PORT=1521)
)
(CONNECT_DATA=
(SID=<your database sid>)
)
)

if you are unsure of your sid logon to your server.
[echo $ORACLE_SID on your server to find out ]

[try connecting again]

solution not exhaustive.

if you need further information try

http://support.oracle.com.sg

regards

 

[vikmen]

ur listener is not up.
Run the listner service and try connecting...