Hi folks, Hope u can help me her

[KOG]

Hi folks,

Hope u can help me here

I accidently typed

#savevg oracle_2 instead of #smit savevg oracle_2

and now can't connect to oracle via client machine

What shall I do .. how do I abort this process?

I am using root to run this command

Regards

Katherine (kogrady@birmingham.businesslink.co.uk)

 

[bjverzal]

Can't imagine what would be the case. Are you sure the server is still up?

Can you log in via another telnet session and kill the "savevg" command will a "kill -9" ?

Bill.

 

[KOG]

I ran

ps -u root

but can't find a process with something like savevg

will that cause major probs to oracle?

 

[bjverzal]

Doing a savevg outside of smit should cause no Oracle problems at all. This is a rather perplexing problem, and I suggest that the Oracle outage may be unrelated to the savevg, but rather a symptom of a problem elsewhere.

Bill.

 

[KOG]

I do hope you are right,we have had new PCs installed this afternoon and I could run sqlplus from the server but not the client machine which was worrying.

I am now wondering if it is something to do with what I did earlier

after I realised I mistyped the command #savevg oracle_2 instead of #smit savevg oracle_2, tried to abort it using ctrl-c.

The screen is still frozen, nothing is happening so guess it is still trying to run the command?

What should I do pls?

 

[bjverzal]

It is possible that the terminal is frozen. From another telnet session, do a "fuser -k /dev/???" where "???" is the "pts/#" number of the original session.

Bill.

 

[KOG]

I'm sorry I do not understand that my AIX is so basic. how do I find the original session?

 

[KOG]

Did ps -u root|pg

only three list I can find with pts/0 etc are as follows

pts/0 ksh
pts/0 ps
pts/0 pg

I am assuimg the one with pts/0 ps is my current process

So should I kill the pts/0 ksh?

 

[bjverzal]

Is this from the "savevg" session, or another telnet session?

If it is the same session as the "savevg" session, just do a "exit". If it is a separate telnet session, don't kill it. It won't do any good.

Post the output of a "who" command.

Bill.

 

[bi]

No. If you do that, you'll be thrown off. type who to see if you have more than one login. If you don't, you were thrown off the system.

Do this: ps -ef | grep savevg
That should show you if the savevg process is still running.

Check on the AIX system if the Oracle instance is up: ps -ef | grep pmon. the return will show you the name of your instance if it is running.

then check to make sure the listener is running: ps -ef | grep tnslsnr. The return will show you if the listener is up.

The command you typed by mistake should not have done anything to Oracle.

 

[Yegolev]

Side note...

If CTRL-C does not work, you can usually get CTRL-Z to work. Prompt returns and you can do as you will with the stopped process.

 

[KOG]

One of the NT technican just switched the monitor off and on, and it seems to have done the trick !

I dont know if that is highly recommended but I would not do this.

The odd thing is if the monitor is frozed it affects client machine connecting to the server? That should not happen?

Any suggestions folks and many thanks for all your help and inputs.

Regards

Katherine