OraFAQ Forum: Server Administration » ASM interview question

Home » RDBMS Server » Server Administration » ASM interview question (Oracle 11g,12c, Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ASM interview question [message #677075]

Fri, 16 August 2019 00:06

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi,

What happen if you miss "+" sign while adding datafile in ASM disk group ?

Can someone answer this question been asked in interview?

Regards,
Balaji

Report message to a moderator

Re: ASM interview question [message #677076 is a reply to message #677075]

Fri, 16 August 2019 01:33

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

For example,

orclz>
orclz> alter tablespace jw add datafile 'DATADG' size 1m;

Tablespace altered.

orclz> select name from v$datafile where name like '%DATADG%';

NAME
---------------------------------------------------------------------------------------------------------------------------------------
C:\APP\ORACLE\PRODUCT\19.3.0\DATABASE\DATADG

orclz>

Never mind your question, what does this tell you about problem solving skills?

Report message to a moderator

Re: ASM interview question [message #677077 is a reply to message #677076]

Fri, 16 August 2019 03:08

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

orclz> select name from v$datafile where name like '%DATADG%';

NAME
---------------------------------------------------------------------------------------------------------------------------------------
C:\APP\ORACLE\PRODUCT\19.3.0\DATABASE\DATADG

The datafile 'DATADG' gets added as it was mentioned in alter tablespace command.

Report message to a moderator

Re: ASM interview question [message #677083 is a reply to message #677077]

Fri, 16 August 2019 09:41

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

BalajiDBA wrote on Fri, 16 August 2019 03:08

orclz> select name from v$datafile where name like '%DATADG%';

NAME
---------------------------------------------------------------------------------------------------------------------------------------
C:\APP\ORACLE\PRODUCT\19.3.0\DATABASE\DATADG

The datafile 'DATADG' gets added as it was mentioned in alter tablespace command.

You missed the point when John said "Never mind your question, what does this tell you about problem solving skills?"

Did you notice that your question was about ASM and John's demo was not on ASM?

What did John do to answer your question?
What could you have done to answer your own question?

Report message to a moderator

Previous Topic:	IMPDP gives failed messages in oracle 19c
Next Topic:	ORA-00205: Standby database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:00:35 CST 2025