SharePoint stsadm import – The web application at (URL) cannot be found

We ran into this error: “ORA-00959 tablespace ‘_ deleted$5$0′ does not exist” when we tried to create a materialized view with the tablespace clause specified:
CREATE MATERIALIZED VIEW TABLESPACE
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
START WITH TO_DATE(’30-04-2009 01:00:00′, ‘DD-MM-YYYY HH24:MI:SS’) NEXT TRUNC(SYSDATE)+1/24+1
ENABLE QUERY REWRITE
AS
SELECT CUSTOMER_GUID, SUM(SUBTOTAL_AMT) TOTAL_AMT
FROM .

@
GROUP BY CUSTOMER_GUID

It turned out that the default tablespace for the user which tried to create the materialized view has been set to “_$deleted$5$0″ – a non-existing tablespace. Not sure what caused the default tablespace change.
After the default tablespace for the user has been changed, the materialized view can be created successfully.

Posted by: nkristanto | March 27, 2009

I encountered the following error message when trying to import a WSS 3.0 SharePoint site:

“The web application at (URL) cannot be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.”

This despite the fact that I had created the destination site specified by the URL. I also performed the import from the destination server.

This was resolved after I registered my Windows account (which I used to log on to the destination server) as one of the SharePoint farm administrators (done using SharePoint central administration page). It is not enough to log on using the account that created the destination site

Posted by: nkristanto | October 22, 2008

Restore spfile or controlfile from autobackup beyond 366 days

The restore of spfile and control file from autobackup using maxdays option will fail if the maxdays specified is beyond 366 days:

RMAN> restore controlfile from autobackup maxseq 200 maxdays 500;

Starting restore at 21-oct-08 14:58
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/21/2008 14:58:42
RMAN-06494: MAXDAYS = 500 is out of range (1-366)

So how to restore spfile and control file from a backup taken more than 366 days ago? I found that when RMAN performs restore from autobackup file, it did not check the timestamp of the autobackup file but the timestamp that is stated in the autobackup file name. By changing the autobackup file name so that the timestamp is within the accepted range, it can find and read the autobackup file and restore the controlfile / spfile successfully.

Without the maxdays option, RMAN will only look for autobackup file with timestamp within the last 7 days. So if today is 22 Oct 08 and your autobackup file name in $ORACLE_HOME/dbs is “c-1154185322-20081012-01″, the “restore controlfile from autobackup” command will not be able to find or read the autobackup file.

Change it to “c-1154185322-20081021-01″ and RMAN will be able to restore the control file from autobackup with “restore controlfile from autobackup” command. I don’t have a controlfile autobackup created more than 366 days ago, but I think this trick can also address 366-maxdays limitation.

Posted by: nkristanto | October 16, 2008

On SELECT_CATALOG_ROLE

Granting SELECT_CATALOG_ROLE role to a user gives that user SELECT privilege on dictionary views like DBA_USERS, but not when the SELECT is used in a stored procedure or in creating other objects based on that data dictionary view. For example:

SQL> CREATE OR REPLACE VIEW DBA_USERS_V
AS SELECT * FROM DBA_USERS;
 FROM DBA_USERS
      *
ERROR at line 3:
ORA-00942: table or view does not exist
If SELECT ANY DICTIONARY is not available for the database (like 8.0.5, 8.1.6, 8.1.7), grant SELECT privilege to the user directly using SYS user.

SQL> CONN / AS SYSDBA
SQL> GRANT SELECT ON DBA_USERS TO AUDITUSER;

SQL> CONN AUDITUSER
SQL> CREATE OR REPLACE VIEW DBA_USERS_V
AS SELECT * FROM DBA_USERS;

View created.

Posted by: nkristanto | October 16, 2008

Create Materialized View Fails with Remote View

While creating a materialized view in a 10.2.0.4 database using a view in a remote 10.2.0.3 database as the base table, the creation failed:

SQL> create materialized view db2_dba_ts_quotas_mv
 build immediate
 refresh with rowid complete on demand
 as select tablespace_name, username, max_bytes
 from dba_ts_quotas@db1;

ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at “SYS.DBMS_SNAPSHOT_UTL”, line 1543
ORA-06512: at line 1

The user used in the database link has SELECT ANY DICTIONARY access in the remote database.

Creation of the same materialized views for other 10.2.0.4 database works. To address this issue, instead of creating materialized view based on sys.dba_ts_quotas, I created a view for sys.dba_ts_quotas for the db link user, and create the materialized view based on this view. It worked fine!

Posted by: nkristanto | May 30, 2008

ORA-01034 ORA-27101 SVR4 Error

Today I was not able to connect to 10g Oracle database from SQL*Plus on a client PC.
I tried to connect to the database by running sqlplus apps/apps@oracle

Error message:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

From the db server itself, I was able to connect to the database using OS authentication.
When I run ps -ef, I found that the background process are all using ORACLE instead of “oracle”

oracledb 22187     1  0 10:22:16 ?        0:02 ora_smon_ORACLE
oracledb 22189     1  0 10:22:16 ?        0:00 ora_reco_ORACLE
oracledb 22191     1  0 10:22:16 ?        0:01 ora_cjq0_ORACLE
oracledb 22199     1  0 10:22:17 ?        0:00 ora_p000_ORACLE
oracledb 22181     1  0 10:22:16 ?        0:00 ora_dbw0_ORACLE
oracledb 22179     1  0 10:22:16 ?        0:00 ora_mman_ORACLE
oracledb 22203     1  0 10:22:17 ?        0:00 ora_p002_ORACLE
oracledb 22185     1  0 10:22:16 ?        0:01 ora_ckpt_ORACLE

The listener name was “oracle”. To fix the connection problem, shutdown the listener, edit listener.ora and change occurrence of “oracle” to “ORACLE”. Restart the listener.
Test connection from SQL*Plus on PC client again.

Posted by: nkristanto | May 24, 2008

Oracle settings affecting disk I/O

Oracle database parameters that affect disk I/O:

• db_block_size – the bigger the block size, the less disk I/O
• db_cache_size – the bigger the buffer cache, the less need to perform disk I/O

 

Categories

• Client Connection
• Performance Tuning
  • Disk IO Tuning
• SharePoint
• Uncategorized

 

February 2012

M	T	W	T	F	S	S
« Apr
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29