SEO

Dear All,

I have big problems trying to access a database using SQL*Plus through
command prompt. I am a beginner DBA, and my first challenge is to make
a backup and recovery of an Oracle9i database.
I tried to access through SQL*Plus windows but it showed me "TSNames
No listener"...and accessing using SQL*Plus through command prompt I
could, but now...I can do anything else, I can't use RMAN, V$ .... I
got completely lost..and I will appreciate so much any help.

Thanks in advance for your time.

Bets regards,
BeginnerDBA

On May 8, 11:17*am, hpcasal...@gmail.com wrote:
> Dear All,
>
> I have big problems trying to access a database using SQL*Plus through
> command prompt. I am a beginner DBA, and my first challenge is to make
> a backup and recovery of an Oracle9i database.
> I tried to access through SQL*Plus windows but it showed me "TSNames
> No listener"...and accessing using SQL*Plus through command prompt I
> could, but now...I can do anything else, I can't use RMAN, V$ .... I
> got completely lost..and I will appreciate so much any help.
>
> Thanks in advance for your time.
>
> Bets regards,
> BeginnerDBA

Since you won't supply the command you attempted to use to access an
Oracle database through SQL*Plus tell us why we should take our time
to try and solve an issue where no real information is available.

Post what you did and what error messages you received.


David Fitzjarrell

On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
> On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>
> > Dear All,
>
> > I have big problems trying to access a database using SQL*Plus through
> > command prompt. I am a beginner DBA, and my first challenge is to make
> > a backup and recovery of an Oracle9i database.
> > I tried to access through SQL*Plus windows but it showed me "TSNames
> > No listener"...and accessing using SQL*Plus through command prompt I
> > could, but now...I can do anything else, I can't use RMAN, V$ .... I
> > got completely lost..and I will appreciate so much any help.
>
> > Thanks in advance for your time.
>
> > Bets regards,
> > BeginnerDBA
>
> Since you won't supply the command you attempted to use to access an
> Oracle database through SQL*Plus tell us why we should take our time
> to try and solve an issue where no real information is available.
>
> Post what you did and what error messages you received.
>
> David Fitzjarrell

Ok, I apologize....this is my first day as a real DBA after I finished
college, no more practice...nothing ...this is real. Also, this is the
first time using this tool to try to contact someone who could help
me.
Well, after I launch SQLPlus in the command prompt I tried to see the
blocks that I got corrupted after a hot backup, and I ran v
$backup_corruption...and the only message I got was "unknown
command"..... the thing is that if you could help me giving me some
help what should I do...or may be some link where I can read ...I will
do it....I just want to know which is the best way to make a backup
and recovery by using the SQLPlus through command prompt
window.........
Thanks

On Thu, 8 May 2008 09:58:56 -0700 (PDT), hpcasalino@gmail.com wrote:

>On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>> On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>>
>> > Dear All,
>>
>> > I have big problems trying to access a database using SQL*Plus through
>> > command prompt. I am a beginner DBA, and my first challenge is to make
>> > a backup and recovery of an Oracle9i database.
>> > I tried to access through SQL*Plus windows but it showed me "TSNames
>> > No listener"...and accessing using SQL*Plus through command prompt I
>> > could, but now...I can do anything else, I can't use RMAN, V$ .... I
>> > got completely lost..and I will appreciate so much any help.
>>
>> > Thanks in advance for your time.
>>
>> > Bets regards,
>> > BeginnerDBA
>>
>> Since you won't supply the command you attempted to use to access an
>> Oracle database through SQL*Plus tell us why we should take our time
>> to try and solve an issue where no real information is available.
>>
>> Post what you did and what error messages you received.
>>
>> David Fitzjarrell
>
>Ok, I apologize....this is my first day as a real DBA after I finished
>college, no more practice...nothing ...this is real. Also, this is the
>first time using this tool to try to contact someone who could help
>me.
>Well, after I launch SQLPlus in the command prompt I tried to see the
>blocks that I got corrupted after a hot backup, and I ran v
>$backup_corruption...and the only message I got was "unknown
>command"..... the thing is that if you could help me giving me some
>help what should I do...or may be some link where I can read ...I will
>do it....I just want to know which is the best way to make a backup
>and recovery by using the SQLPlus through command prompt
>window.........
>Thanks

I'm not sure you are real DBA. I would be frigthened to death by a DBA
who assumes you can make a backup of a database through sqlplus.
I would be frightened to death by a DBA who doesn't know SQL, and who
doesn't know v$backup_corruption is a view, which you need to SELECT
from.

I would you advise you to quit your job, before you create havoc and
are laid off, and go back to college, and ask your money back.

--
Sybrand Bakker
Senior Oracle DBA

On May 8, 12:18*pm, sybra...@hccnet.nl wrote:
> On Thu, 8 May 2008 09:58:56 -0700 (PDT), hpcasal...@gmail.com wrote:
> >On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
> >> On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>
> >> > Dear All,
>
> >> > I have big problems trying to access a database using SQL*Plus through
> >> > command prompt. I am a beginner DBA, and my first challenge is to make
> >> > a backup and recovery of an Oracle9i database.
> >> > I tried to access through SQL*Plus windows but it showed me "TSNames
> >> > No listener"...and accessing using SQL*Plus through command prompt I
> >> > could, but now...I can do anything else, I can't use RMAN, V$ .... I
> >> > got completely lost..and I will appreciate so much any help.
>
> >> > Thanks in advance for your time.
>
> >> > Bets regards,
> >> > BeginnerDBA
>
> >> Since you won't supply the command you attempted to use to access an
> >> Oracle database through SQL*Plus tell us why we should take our time
> >> to try and solve an issue where no real information is available.
>
> >> Post what you did and what error messages you received.
>
> >> David Fitzjarrell
>
> >Ok, I apologize....this is my first day as a real DBA after I finished
> >college, no more practice...nothing ...this is real. Also, this is the
> >first time using this tool to try to contact someone who could help
> >me.
> >Well, after I launch SQLPlus in the command prompt I tried to see the
> >blocks that I got corrupted after a hot backup, and I ran v
> >$backup_corruption...and the only message I got was "unknown
> >command"..... the thing is that if you could help me giving me some
> >help what should I do...or may be some link where I can read ...I will
> >do it....I just want to know which is the best way to make a backup
> >and recovery by using the SQLPlus through command prompt
> >window.........
> >Thanks
>
> I'm not sure you are real DBA. I would be frigthened to death by a DBA
> who assumes you can make a backup of a database through sqlplus.
> I would be frightened to death by a DBA who doesn't know SQL, and who
> doesn't know v$backup_corruption is a view, which you need to *SELECT
> from.
>
> I would you advise you to quit your job, before you create havoc and
> are laid off, and go back to college, and ask your money back.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

Look, I am trying to put in practice what I studied, you could be a
little more kind in giving me some advise. Or you just forgot when you
studied and when you were at your first day in some place???? I think
you did.......
What I just want to do is try to start working as a real DBA..When I
said real DBA, is that I left my daily classes and I want to start
working to becoming as good as others..I know is a long way, but I
deserve the opportunity...... May be you misunderstood my
question....you have to be more patience...I don't know how you are a
Senior DBA with this selfish and antipatic behavior....

On May 8, 9:58*am, hpcasal...@gmail.com wrote:
> On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>
> > > Dear All,
>
> > > I have big problems trying to access a database using SQL*Plus through
> > > command prompt. I am a beginner DBA, and my first challenge is to make
> > > a backup and recovery of an Oracle9i database.
> > > I tried to access through SQL*Plus windows but it showed me "TSNames
> > > No listener"...and accessing using SQL*Plus through command prompt I
> > > could, but now...I can do anything else, I can't use RMAN, V$ .... I
> > > got completely lost..and I will appreciate so much any help.
>
> > > Thanks in advance for your time.
>
> > > Bets regards,
> > > BeginnerDBA
>
> > Since you won't supply the command you attempted to use to access an
> > Oracle database through SQL*Plus tell us why we should take our time
> > to try and solve an issue where no real information is available.
>
> > Post what you did and what error messages you received.
>
> > David Fitzjarrell
>
> Ok, I apologize....this is my first day as a real DBA after I finished
> college, no more practice...nothing ...this is real. Also, this is the
> first time using this tool to try to contact someone who could help
> me.
> Well, after I launch SQLPlus in the command prompt I tried to see the
> blocks that I got corrupted after a hot backup, and I ran v
> $backup_corruption...and the only message I got was "unknown
> command"..... the thing is that if you could help me giving me some
> help what should I do...or may be some link where I can read ...I will
> do it....I just want to know which is the best way to make a backup
> and recovery by using the SQLPlus through command prompt
> window.........
> Thanks

Well, one thing about being a DBA is you are expected to know all
about these things, or be able to find them out in a timely manner.
The _one thing_ you cannot get wrong is recovery!

First of all, RMAN is a separate tool from SQL*Plus. There are many
varieties of Oracle and means of controlling it, you need to be much
more specific about your platform, version and so on. I wrote a
minifaq for this group to help newbies: http://www.dbaoracle.net/readme-cdos.htm

There are online resources to help you out, including a "2-day DBA" to
get you started, and the docs are searchable at http://tahiti.oracle.com,
including a basic backup book for some versions. Some of the Oracle
training varies from the real world, so online fora help you reconcile
that. But few people will hold your hand completely, you need to show
effort and a grasp of the basics. So be sure and read that Concepts
manual!

As far as your listener issue, that may mean your listener isn't
running, and may mean your environment is incorrect. Do you have a
senior DBA or even developer there to help you get started? I'm sure
some people are curious how you could manage to get a DBA job with no
experience, too.

The command you perhaps wanted to run from sqlplus was:
select * from v$backup_corruption;

But why are you running that command?

You probably want to (from the OS command line):
echo $ORACLE_BASE $ORACLE_HOME $PATH $ORACLE_SID $TNS_ADMIN
lsnrctl status

You probably want to search your client machine for tnsnames.ora, you
may have been using one misconfigured for your server and listener.
Or maybe you just haven't started the listener. Hard to say without
knowing exactly what your configuration is.

jg
--
@home.com is bogus.
Hmmm, I remember the spoiled rich kid coke dealer at my high school
getting shot in the face, 35 years ago.
http://www.signonsandiego.com/uniont...c8jenkins.html

On May 8, 12:33*pm, joel garry <joel-ga...@home.com> wrote:
> On May 8, 9:58*am, hpcasal...@gmail.com wrote:
>
>
>
>
>
> > On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
> > > On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>
> > > > Dear All,
>
> > > > I have big problems trying to access a database using SQL*Plus through
> > > > command prompt. I am a beginner DBA, and my first challenge is to make
> > > > a backup and recovery of an Oracle9i database.
> > > > I tried to access through SQL*Plus windows but it showed me "TSNames
> > > > No listener"...and accessing using SQL*Plus through command prompt I
> > > > could, but now...I can do anything else, I can't use RMAN, V$ .... I
> > > > got completely lost..and I will appreciate so much any help.
>
> > > > Thanks in advance for your time.
>
> > > > Bets regards,
> > > > BeginnerDBA
>
> > > Since you won't supply the command you attempted to use to access an
> > > Oracle database through SQL*Plus tell us why we should take our time
> > > to try and solve an issue where no real information is available.
>
> > > Post what you did and what error messages you received.
>
> > > David Fitzjarrell
>
> > Ok, I apologize....this is my first day as a real DBA after I finished
> > college, no more practice...nothing ...this is real. Also, this is the
> > first time using this tool to try to contact someone who could help
> > me.
> > Well, after I launch SQLPlus in the command prompt I tried to see the
> > blocks that I got corrupted after a hot backup, and I ran v
> > $backup_corruption...and the only message I got was "unknown
> > command"..... the thing is that if you could help me giving me some
> > help what should I do...or may be some link where I can read ...I will
> > do it....I just want to know which is the best way to make a backup
> > and recovery by using the SQLPlus through command prompt
> > window.........
> > Thanks
>
> Well, one thing about being a DBA is you are expected to know all
> about these things, or be able to find them out in a timely manner.
> The _one thing_ you cannot get wrong is recovery!
>
> First of all, RMAN is a separate tool from SQL*Plus. *There are many
> varieties of Oracle and means of controlling it, you need to be much
> more specific about your platform, version and so on. *I wrote a
> minifaq for this group to help newbies: *http://www.dbaoracle.net/readme-cdos.htm
>
> There are online resources to help you out, including a "2-day DBA" to
> get you started, and the docs are searchable athttp://tahiti.oracle.com,
> including a basic backup book for some versions. *Some of the Oracle
> training varies from the real world, so online fora help you reconcile
> that. *But few people will hold your hand completely, you need to show
> effort and a grasp of the basics. *So be sure and read that Concepts
> manual!
>
> As far as your listener issue, that may mean your listener isn't
> running, and may mean your *environment is incorrect. *Do you have a
> senior DBA or even developer there to help you get started? *I'm sure
> some people are curious how you could manage to get a DBA job with no
> experience, too.
>
> The command you perhaps wanted to run from sqlplus was:
> select * from v$backup_corruption;
>
> But why are you running that command?
>
> You probably want to (from the OS command line):
> echo $ORACLE_BASE $ORACLE_HOME $PATH $ORACLE_SID $TNS_ADMIN
> lsnrctl status
>
> You probably want to search your client machine for tnsnames.ora, you
> may have been using one misconfigured for your server and listener.
> Or maybe you just haven't started the listener. *Hard to say without
> knowing exactly what your configuration is.
>
> jg
> --
> @home.com is bogus.
> Hmmm, I remember the spoiled rich kid coke dealer at my high school
> getting shot in the face, 35 years ago.http://www.signonsandiego.com/uniont...8jenkins.html- Hide quoted text -
>
> - Show quoted text -

Yes, you are right.. I don't have much experience on this....I am
level 1, I am really new...I have just left college...and I know
things...but they looks different when you have to work in the real
life..and not just doing some homework ..... yes...but I want to
learn...and I think that I have to start with something...I am so
nervous..and may be that why I get lost..I have to get practice on
this......is my first day....
Thank you for understand.

Comments embedded.
On May 8, 11:58*am, hpcasal...@gmail.com wrote:
> On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>
> > > Dear All,
>
> > > I have big problems trying to access a database using SQL*Plus through
> > > command prompt. I am a beginner DBA, and my first challenge is to make
> > > a backup and recovery of an Oracle9i database.
> > > I tried to access through SQL*Plus windows but it showed me "TSNames
> > > No listener"...

And the command you attempted which produced that output was ...

To verify if you're using a correct TNS alias you would type, at the
command prompt:

tnsping <whatever alias you want to use>

and see what tnsping reports. Some sample successful output follows:

c:\sql>tnsping smudgepot

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production
on 08-MAY-2008 13:06:39

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
\\apps\database\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(Host = ZINGBOT.COM)(Port = 1529))) (CONNECT_DATA =
(SID = SMUDGEPOT)))
OK (10 msec)

As you can see a successful ping returns a plethora of information; an
unsuccessful ping produces:

c:\sql>tnsping smort

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production
on 08-MAY-2008 13:09:55

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
\\apps\database\sqlnet.ora

TNS-03505: Failed to resolve name

which should be telling you the alias isn't defined in the
tnsnames.ora file. This informative bit of text:

Used parameter files:
\\apps\database\sqlnet.ora

provides the networked location of a common tnsnames.ora file (the
sqlnet.ora and tnsnames.ora files are located in the same directory).
One would then investigate the tnsnames.ora file with any common text
editor and find the proper alias for the database in question.

> > > and accessing using SQL*Plus through command prompt I
> > > could, but now...I can do anything else, I can't use RMAN, V$ .... I
> > > got completely lost..and I will appreciate so much any help.
>
> > > Thanks in advance for your time.
>
> > > Bets regards,
> > > BeginnerDBA
>
> > Since you won't supply the command you attempted to use to access an
> > Oracle database through SQL*Plus tell us why we should take our time
> > to try and solve an issue where no real information is available.
>
> > Post what you did and what error messages you received.
>
> > David Fitzjarrell
>
> Ok, I apologize....this is my first day as a real DBA after I finished
> college, no more practice...nothing ...this is real. Also, this is the
> first time using this tool to try to contact someone who could help
> me.

Understood.

> Well, after I launch SQLPlus in the command prompt I tried to see the
> blocks that I got corrupted after a hot backup, and I ran v
> $backup_corruption...and the only message I got was "unknown
> command".....

You cannot simply 'launch' SQL*Plus and expect to be able to do
anything worthwhile as you have yet to connect to a database. One
presumes this is a client machine, and that your database of interest
is NOT local:

c:\sql>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Thu May 8 12:57:22 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> connect ####/*********@smudgepot
Connected.
SQL>

At this point you are successfully connected to a database; one
wonders how you passed your courses without knowing HOW to connect to
an Oracle database.

Queries can now be executed from the SQL> prompt:

SQL> select * from v$backup_corruption;

no rows selected

SQL>

I am concerned that you are convinced that a database backup can be
taken from SQL*Plus; nothing could be further from the truth. RMAN,
a separate utility, is used for such tasks; it would be a wise person
who bookmarks the following link:

http://tahiti.oracle.com

and uses it religiously to learn the various aspects of Oracle and its
management.
.
> the thing is that if you could help me giving me some
> help what should I do...or may be some link where I can read ...I will
> do it....I just want to know which is the best way to make a backup
> and recovery by using the SQLPlus through command prompt
> window.........

The best way is to not make such an attempt; RMAN is the supplied tool
of choice for backups.

> Thanks- Hide quoted text -
>
> - Show quoted text -


David Fitzjarrell

On Thu, 8 May 2008 09:58:56 -0700 (PDT), hpcasalino@gmail.com wrote:

>On May 8, 11:34*am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>> On May 8, 11:17*am, hpcasal...@gmail.com wrote:
>>
>> > Dear All,
>>
>> > I have big problems trying to access a database using SQL*Plus through
>> > command prompt. I am a beginner DBA, and my first challenge is to make
>> > a backup and recovery of an Oracle9i database.
>> > I tried to access through SQL*Plus windows but it showed me "TSNames
>> > No listener"...and accessing using SQL*Plus through command prompt I
>> > could, but now...I can do anything else, I can't use RMAN, V$ .... I
>> > got completely lost..and I will appreciate so much any help.
>>
>> > Thanks in advance for your time.
>>
>> > Bets regards,
>> > BeginnerDBA
>>
>> Since you won't supply the command you attempted to use to access an
>> Oracle database through SQL*Plus tell us why we should take our time
>> to try and solve an issue where no real information is available.
>>
>> Post what you did and what error messages you received.
>>
>> David Fitzjarrell
>
>Ok, I apologize....this is my first day as a real DBA after I finished
>college, no more practice...nothing ...this is real. Also, this is the
>first time using this tool to try to contact someone who could help
>me.
>Well, after I launch SQLPlus in the command prompt I tried to see the
>blocks that I got corrupted after a hot backup, and I ran v
>$backup_corruption...and the only message I got was "unknown
>command"..... the thing is that if you could help me giving me some
>help what should I do...or may be some link where I can read ...I will
>do it....I just want to know which is the best way to make a backup
>and recovery by using the SQLPlus through command prompt
>window.........
>Thanks

Don't panic, you'll get up to speed. Everyone has to start somewhere.
This newsgroup, regrettably, is anything but newbie friendly.
Nonetheless, read the replies that have been posted. There are good
suggestions scattered in among the abuse. Try to make future
questions more specific, include version info and precise error
messages. "It doesn't work" is rarely a helpful description of a
problem.

There is a tremendous wealth of Oracle information on various web
sites and blogs. Google, google, google. Oracle itself publishes some
of the best. Read through everything on Oracle's web site marked
"Concept". They also publish an excellent tutorial/reference called
"The 2 Day DBA". A link is below, check it out.

http://www.oracle.com/technology/obe...dba/index.html

Good luck,
Arch