Visit Our UNIX and Linux User Community

Search Results

Search: Posts Made By: admin_db
Forum: Red Hat 09-08-2016
1,630
Posted By admin_db
Hi Robin, There were plenty of these...
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...
Forum: Red Hat 09-08-2016
1,630
Posted By admin_db
Server reboot
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...
4,001
Posted By admin_db
Flow control state changed in server logs
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...
1,762
Posted By admin_db
Thanks Sir! Best regards, Vishal
Thanks Sir!

Best regards,
Vishal
3,384
Posted By admin_db
Thanks ! Now all is good and I want to copy...
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...
1,762
Posted By admin_db
Thanks! Since this is manual entry in...
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...
1,762
Posted By admin_db
Hi, This is not working as expected.I am...
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}:...
3,384
Posted By admin_db
Passing sqlplus output to shell variable
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...
1,237
Posted By admin_db
Grep with variable not working
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...
Forum: Red Hat 02-02-2016
1,436
Posted By admin_db
Thanks ! This is Oracle linux and from one of our...
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...
1,762
Posted By admin_db
Please allow me to rephrase here . We have a...
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...
Forum: Red Hat 02-01-2016
1,436
Posted By admin_db
Upgrade from OL 6.3 to 6.5
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...
1,762
Posted By admin_db
Thanks RudiC and Ravinder ! Both script are...
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...
1,762
Posted By admin_db
Need to get word after a specific word
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...
10,530
Posted By admin_db
We have been doing this using OEM(oracle...
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...
10,530
Posted By admin_db
Pass the password to su in shell script
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
Forum: Red Hat 12-02-2015
1,693
Posted By admin_db
Server shutdown- /var/log/messages copied over here
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...
3,558
Posted By admin_db
Error of Snapshot origin volumes can be resized only while inactive
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...
7,616
Posted By admin_db
Thank you very much! This worked ...
Thank you very much!

This worked


Best regards,
Vishal
7,616
Posted By admin_db
Unable to obtain lock on NFS files
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
...
3,541
Posted By admin_db
There was issue in permission of...
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]:...
1,489
Posted By admin_db
Hello, This doesn't seem to be a supported...
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...
3,541
Posted By admin_db
Unable to mount NFS
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...
1,489
Posted By admin_db
Hello, I am unable to mount fs ...
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,
...
1,489
Posted By admin_db
Thanks Ravinder! I created snap 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 ...
Showing results 1 to 25 of 42

 

Featured Tech Videos

All times are GMT -4. The time now is 02:13 PM.
Unix & Linux Forums Content Copyright 1993-2021. All Rights Reserved.
Privacy Policy