| Error [message #146514] |
Thu, 10 November 2005 21:04  |
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
|
Junior Member |
|
|
Error connecting through OEM,
same errors comes when connecting thro sqlplus with service name
withouth service name I can connect.PL help, pl see bitmap
-
Attachment: OEM.bmp
(Size: 1.57MB, Downloaded 1221 times)
|
|
|
|
| Re: Error [message #146655 is a reply to message #146514] |
Fri, 11 November 2005 16:57  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I had seen your attachment from that i come to know your database is zen1
go at oracle_home and see is connection is there or not
Oracle_home\bin>tnsping zen1
Try to set your sid to zen1
Oracle_home\bin>set oracle_sid=zen1
& then try to connect to db.
Regards
Always Friend Sunilkumar
|
|
|
|
| Re: Error [message #146696 is a reply to message #146514] |
Sat, 12 November 2005 07:37 |
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
|
Junior Member |
|
|
Thanks for the reply.
Sending the output, Why connection using service name not working
SQL> Select INSTANCE_NAME from v$instance;
INSTANCE_NAME
----------------
zen1
SQL> Connect scott@zen1
Enter password: *****
ERROR:
ORA-12535: TNS:operation timed out
Warning: You are no longer connected to ORACLE.
SQL> connect scott
Enter password: *****
Connected.
SQL> Set set oracle_sid=zen1
SP2-0158: unknown SET option "set"
on command prompt
C:\oracle\ora92\BIN>tnsping zen1
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-NOV-20
05 19:02:22
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST =zen)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =
zen1)))
OK (30 msec)
C:\oracle\ora92\BIN>
|
|
|
|
| Re: Error [message #146735 is a reply to message #146696] |
Sun, 13 November 2005 10:07 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Oracle_techi i think u r not fine coz of this error take it lightly buddy..
See below to know how to use set command
C:\oracle\ora92\BIN>set ORACLE_SID=zen1
To check your sid is set
C:\oracle\ora92\BIN>echo %ORACLE_SID%
Note :- As per your post i come to know that you are working witn windows based o/s (i.e. operating system)
Now to check the connetion to your database
C:\oracle\ora92\BIN>tnsping zen1
I hope you have proper memory==> RAM on your system,,,,
now if all is fine try to connect to your db zen1 through sql prompt
C:\oracle\ora92\BIN>sqlplus "sys/change_on_install@zen1 as sysdba"
Note :- I consider your password for sys as change_on_install, b'coz it is default password. but if you have db authenticated by o/s then no need to give password.
If your db is started and open for user then try below written thing
sql> conn scott/tiger@zen1
One thing more when u r connected as sysdba you check which instance is runnig by below written query.. note:- scott dont have right of sysdba..
SQL> select instance_name from V$instance;
and also check the db name
SQL> select name from V$database;
thats it ....Try it
Regards
Always Friend sunilkumar..
[Updated on: Sun, 13 November 2005 10:11] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
