[Amit Bansal]

Mic,

Why are there two entries for Description in tns entry

<br />
(DESCRIPTION=(DESCRIPTION=<br />

You have mentioned that this entries are mentioned in alert log. Have you checked the client from which it is coming. Also as Suvv sugested try checking local_listener and remote_listener value. Note that if you are using scan (11gr2), remote_listener should be scanname:<port>

-Amit

[Amit Bansal]

Hi Bhatia,

I do not think that there are separate pre-requisites for ASM . You need to ensure that you apply all packages mentioned in OS pre-requisite for oracle installation. Also check for MOS (Metalink) to ensure that your version is certified to run on AIX 6.1

Cheers

Amit

[Amit Bansal]

HI, Looking like a interesting thread going on. Its good that people are actually willing to share their views on this topic.

[Amit Bansal]

Permissions on init+ASM2.ora is right.I am only facing this problem when i was starting ASM through srvctl command otherwise it’s working fine.

Please note this point.

[Amit Bansal]

Download demo ost recovery software to convert .OST files to .PST file. Saved .PST file can be accessed with MS Outlook with other save options including .EML and .MSG which can be accessed with Outlook Express and MS Outlook.

[Amit Bansal]

you have a standby database and the standby needs a log that likely you already removed where it thinks it should be /u05/arch/

[Amit Bansal]

If ‘Shutdown Normal’ hangs

Symptom:

‘Shutdown normal’ has been issued to the Oracle database, but Oracle will not shutdown.

Possible Causes and Remedies:

There are two likely causes:

1. ‘Shutdown Normal’ will only shutdown Oracle when there are no remaining connections to Oracle. It is likely therefore that an application still has an active session.

Possible Remedies:

* close all open sessions

* or issue a ‘shutdown immediate’.

2. If using Oracle Parallel Server issuing ‘Shutdown normal’ on more than one node at a time can cause the system to hang. This is a recognised Oracle problem (Oracle 8.0.5).

Possible remedies:

* Only issue ‘Shutdown normal’ on one node at a time, and only issue it on the next node when the previous node has completed its shutting down.

* Alternately, use ‘shutdown immediate’ instead.

[Amit Bansal]

Hi,

I think this is not possible. Since I presume you will also change the hostnames. If it is only OCR and voting disk it is possible. But you cannot change hostnames.

[Amit Bansal]

Hi Tsswamy,

I have not done this kind of migration. I believe that starting a database with non-rac binary and removing the cluster* parameters should allow you to do same. I would recommend you to contact My Oracle Support for exact steps to do same.

[Amit Bansal]

Hi,

As per your statement, you are observing memory statistics from TOP command. Please note that TOP output contains component of shared+private memory, so you cannot rely on that figure ( to confirm if you add memory for all processes it will exceed the total memory on system). There are some Metalink/MOS docs regarding same. You can use pmap (solaris and linux) or svmon to know the exact memory usage of process.

I would suggest digging into Statspack/AWR report to find the bottleneck.

w.r.t to a process consuming high CPU, check if it is a Background process. You can look at program column in V$process

select s.sid,p.spid,s.username “SUSER”,p.username “PUSER”,s.osuser,p.program,s.status from v$session s ,v$process p where s.paddr=p.addr

[Amit Bansal]

I assume you are using windows server. But don’t have sufficient information to help. Are you facing database hang or slow database? If it is hang then there could be some blocking session. If it’s a slow database, it could be query issue or sth else.

-Amit

[Amit Bansal]

Hi,

Sorry for late reply. Didn’t get time to reply earlier.

In case of RAC database (10.2) you need to perform following steps

1)Start CRS (as root)

#crsctl start crs

Actually if you have enabled automatic startup of resources and configured asm-instance dependency correctly, then it will start all resources automatically. Otherwise go to below steps

2)Start Nodeapps

$srvctl start nodeapps -n <noden>

3)Start ASM instance

srvctl start asm -n <noden>

Repeat steps on other node. You can use srvctl command from any node

4) Now start cluster database

$srvctl start database -d <dbname>

You can also start a single instance using following command

srvctl start instance -d <db_name> -i <inst_name>

[Amit Bansal]

As per upgrade guide, you had to add a user to password file before upgrading ASM instance.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#BABEJBFD

Did you try recreating password file for ASM?Use orapwd to do same.

If it still doesn’t work, then would recommend you to raise SR.

[Amit Bansal]

1. There is no asm command to find the devices part of particular diskgroup. You can use the query to find the diskgroup devices.

2. Yes, you can have multiple diskgroups

3. No, you can allocate only one diskgroup to FRA.

4. Yes, you can have multiple databases using same diskgroup

5. I cant answer this. You need to read Database Concepts and Admin guide.

6. No. Can’t be done.

Deepika , I think it would be better to get a DBA for managing your site as RAC DB’s are much complex then single instance databases on filesystem.

[Amit Bansal]

Deepika,

Please find response below

1) Your first script has mistake. Should be like

export ORACLE_SID=+ASM1

sqlplus / as sysdba <<EOF

select name, path from v$asm_disk;

exit

EOF

2)

node_list=olsnodes

node1=echo $node_list|awk '{print $1}'

node2=echo $node_list|awk '{print $2}'

echo “Node 1 is ” $node1

echo “Node 2 is ” $node2

Hope this helps

[Author]

Posts