You should switch the subject line when starting a new thread.
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Galletto Anthony
[mailto:oracledba-ezmlmshield-x48058746.[Email address protected]
Sent: Monday, October 29, 2007 5:00 PM
To: LazyDBA Discussion
Subject: RE: cannot connect to database (URGENT)
All,
I am currently tring to restart my oracle db on a HP-HX N4000 system and
currently get the following when attempting to do so;
Enter user-name: connect /as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> recover
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: '/db01/oradata/NSMS/system01.dbf'
Anthony Galletto
Principal Member Technical Staff
[Email address protected]
This e-mail and any files transmitted with it are the property of AT&T
Labs Inc., are confidential, and are intended solely for the use of the
individual or entity to whom this e-mail is addressed. If you are not
one of the named recipient(s) or otherwise have reason to believe that
you have received this message in error, please notify the sender at 512
372-5338 and delete this message immediately from your computer. Any
other use, retention, dissemination, forwarding, printing, or copying of
this e-mail is strictly prohibited.
-----Original Message-----
From: Osborn Jim
[mailto:oracledba-ezmlmshield-x87254204.[Email address protected]
Sent: Monday, October 29, 2007 3:42 PM
To: LazyDBA Discussion
Subject: RE: cannot connect to database (URGENT)
Once the password file is created, I would set the
remote_login_passwordfile=EXCLUSIVE in the init or spfile which should
then allow the SYS user to connect remotely.
Remote_administration init parameter????
__________________________
Jim Osborn
Database Administrator
-----Original Message-----
From: Joel [mailto:oracledba-ezmlmshield-x66900423.[Email address
protected]
Sent: Monday, October 29, 2007 2:30 PM
To: LazyDBA Discussion
Subject: RE: cannot connect to database (URGENT)
You are getting insufficient privileges. Have you recreated your
password file yet? (this is used when the listener is used. The
listener is used when you use a tnsnames.ora entry such as @sid).
Are you logging in from the client? If so is remote_authentication set
to true in your init file?
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
-----Original Message-----
From: Mir Aijaz A
[mailto:oracledba-ezmlmshield-x57573331.[Email address protected]
Sent: Monday, October 29, 2007 2:43 PM
To: LazyDBA Discussion
Subject: RE: cannot connect to database (URGENT)
All variables are set properly. I am getting ora-01031 error.
My show parameter local show "string"
Connect sys/[Email Address Removed] as sysdba
or
Connect /@sid as sysdba
Or
Connect scott/[Email Address Removed] fails
Some one pointed me right listener is not being used .
Regards
Aijaz
-----Original Message-----
From: Jose Viegas
[mailto:oracledba-ezmlmshield-x86386567.[Email address protected]
Sent: Monday, October 29, 2007 9:31 PM
To: LazyDBA Discussion
Subject: Re: cannot connect to database (URGENT)
Are you connecting as oracle user ? What is the error message ?
probably you haven't ORACLE_HOME and ORACLE_SID env variables set.
If you are in unix as oracle owner you can enter as sqlplus "/ as
sysdba"
regards
JAV
Todd Pepling escreveu:
> Did you try?
>
> sqlplus "sys/[Email Address Removed] as sysdba"
>
> And what is the exact error you receive from the database?
> Todd Pepling
> [Email address protected]
> 724-766-3492
>
> -----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 <http://jobs.lazydba.com/> To
> Subscribe : http://www.LazyDBA.com <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 <http://jobs.lazydba.com/> To
> Subscribe : http://www.LazyDBA.com <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 <http://jobs.lazydba.com/> To
> Subscribe : http://www.LazyDBA.com <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
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
---------------------------------------------------------------------
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