Search Results

Hi Robin,

There were plenty of these messages which I copied in the last post and ultimately Oracle clusterware caused the node to evict


Sep 7 10:52:56 minersville logger: Oracle clsomon...

Hi,

The server got rebooted and below messages can be seen in /var/log/messages

Sep 7 10:49:12 minersville kernel: Call Trace: <IRQ> <ffffffff80167420>{__alloc_pages+796}
Sep 7 10:49:12...

Hi,

We observe below logs from switch - the database servers rebooted becaause they couldn't do I/O on vfiler -Any pointers looking at below logs please?

Switch logs:

2016 Apr 30...

Thanks Sir!

Best regards,
Vishal

Thanks !

Now all is good and I want to copy password file of primary to standby -I am using something like below and looks like this is not working.

for i in `ps -ef|grep pmon|awk {' print $8...

Thanks!

Since this is manual entry in tnsnames.ora file so somewhere this would be like

HOST=
HOST =
host =
host=

Can we get all these possibilities covered in the script ?

Best...

Hi,

This is not working as expected.I am looking for hostname from tnsping output.

c456veq {/home/oracle}: tnsping ora426b |sed -n 's/\(.*HOST=\)\([^)]*\)\(.*\)/\2/p'
c456veq {/home/oracle}:...

Hi ,

I am using below code :

for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading...

Hello,

I am using below code :

export ORAR=orp712z.int.thomsonreuters.com
#echo $ORAR;
if echo $ORAR|grep -i "_"
then
ORACLE_SID1= echo $ORAR|cut -f2 -d "_"
echo $ORACLE_SID1...

Thanks ! This is Oracle linux and from one of our engineers this is what we got the reply - I was just wondering if this is the actual scenario in OL 6.3 to 6.5 upgrade?

It is not possible to...

Please allow me to rephrase here .

We have a task of password change activity for databases and servers every quarter.
Now, in case I need to change db sys user password at primary I have to...

Hello,

For upgrading from OL 6.3 to 6.5 is this possible to upgrade without rebuild?

What should be the generic steps in migration to OL 6.5. IS this like building up from scratch ?


Best...

Thanks RudiC and Ravinder ! Both script are working fine.

Now,I have task as follows :
I get standby tnsentry from primary database like I get destination from below query:

SQL> select...

Hi,

I need hostname from below entry.How do I write a script on this?tnsping is utility in oracle -if I do tnsping ora11gb then it would give one output and I want to extract hostname from this...

We have been doing this using OEM(oracle monitoring tool) .There we can login to each target(host) in the group with ggs user
Here my main target was to first login with oracle user and see if...

Hello,

I am using below command but this is asking for tty

c42dba {/home/oracle}: echo sersnp | su -c ggs
standard in must be a tty



Best regards,
Vishal

Hi,

Please share your thought what could make the server shutdown:

Dec 1 10:20:05 powellton syslog-ng[3916]: syslog-ng version 1.6.8 starting
Dec 1 10:20:06 powellton kdump[4038]: Loaded...

Hello,

I am trying to increase lvsize however it gives below error what's the way that I can increase this size?

[root@ta ~]# lvextend -L +20G /dev/VGExaDb/volsnap
Snapshot origin volumes...

Thank you very much!

This worked


Best regards,
Vishal

Hello ,

I am creating a controlfile of database in linux and below is the error coming:

SQL> CREATE CONTROLFILE REUSE set DATABASE "newdbcln" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 5
...

There was issue in permission of /etc/hosts.allow and /etc/hosts.deny
I changed this to 644 from 600.
After changing this gave another error as below:

Feb 5 15:11:23 cindb1003a mountd[30834]:...

Hello,

This doesn't seem to be a supported command.

[root@cindb1002a ~]# lsb_release -a
-bash: lsb_release: command not found


Best regards,
Vishal

---------- Post updated at 03:49 PM...

Hello,

While mounting NFS below error is coming:

[root@cindb1002a ~]# mount -t nfs 10.65.150.69:/lvsnap /lvsnap
mount: mount to NFS server '10.65.150.69' failed: RPC Error: Program not...

Hello,

I am unable to mount fs

[root@cindb1004a VGExaDb]# mount -t ext3 /dev/VGExaDb/data_snap /snap_db
mount: wrong fs type, bad option, bad superblock on /dev/VGExaDb/data_snap,
...

Thanks Ravinder!

I created snap data_snap but unable to see in df -h
[root@cindb1004a onecommand]# lvs
LV VG Attr LSize Origin Snap% Move Log Copy% Convert
LVDbOra1 ...