Send us the exact error message you got when you connect the DB.
Regards,
Siva.P
Bangalore
-----Original Message-----
From: Joel
[mailto:oracledba-ezmlmshield-x93861963.[Email address protected]
Sent: Monday, October 29, 2007 10:19 PM
To: LazyDBA Discussion
Subject: RE: cannot connect to database (URGENT)
You can connect as scott/[Email Address Removed] but not sys/[Email Address Removed] as sysdba?
Do you have a password file $ORACLE_HOME/dbs/orapwd will help you
create it. You may want to check how your remote_authentication init
parameter is set.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Woodruff Daniel
[mailto:oracledba-ezmlmshield-x40256314.[Email address protected]
Sent: Monday, October 29, 2007 10:23 AM
To: LazyDBA Discussion
Subject: RE: cannot connect to database (URGENT)
Can you tnsping the database you are trying to connect to?
If you are on your PC check the tnsnames.ora file, it should contain a
link to your database.
Also check to see if your PC hosts file it lists the server names.
Can you ping and tracert/traceroute to the server?
Also try sqlplus system/[Email Address Removed] to connect. with a fully
qualified host name hostname.network.com
ie:: sqlplus system/[Email address protected]
Did you figure out how to re-analyze your tables yet?
You can do it from the OEM.
-----Original Message-----
From: Mir Aijaz A
[mailto:oracledba-ezmlmshield-x85454362.[Email address protected]
Sent: Monday, October 29, 2007 9:38 AM
To: LazyDBA Discussion
Subject: cannot connect to database (URGENT)
hi all,
please treat this mail very very urgent .
i am not able to connect to the database using connect sys/[Email Address Removed] as
sysdba while as i am able to connect using connect sys/sys as sysdba or
connect / as sysdba or connect scott/tiger or connect scott/[Email Address Removed]
I am on HP unix
what is the reason i am not able to connect using sid in the connect
string
Thanks and Regards,
Aijaz
DISCLAIMER:
Notice : This e-mail and any attachments may contain information which
is confidential to the addressee and may also be privileged. If you are
not the intended recipient of this e-mail, you may not copy, forward,
disclose or otherwise use it in any way whatsoever. If you have received
this e-mail by mistake, please e-mail the sender by replying to this
message, and deleting the original and any printout thereof.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page