Skip to content

catalog start with rman hangs

When I am trying to restore the full database to target new host,  I have used to catalog the backup piece but It took more time but not complete

RMAN> catalog start with ‘/u02/backup/backup/’;

Starting implicit crosscheck backup at 26-FEB-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 26-FEB-16

Starting implicit crosscheck copy at 26-FEB-16
using channel ORA_DISK_1

 

Solution :

Disable the recovery file destination, and then tried to catalog the backuppiece, Its okay now.

SQL> alter system set db_recovery_file_dest=” scope=both;

 

Setup DNS for RAC 12c implementation in virtual Box

If you are plan to implement rac setup in virtul box for your lab practise, you need to setup a dns configuration necessary steps to use single client access name (SCAN) introduced in 11gR2 RAC.

The DNS setup may be a separate server, or you can make it on any one of the nodes you’re preparing for rac implementation.

Here I have chosed to setup on rac first node, so you need to do some setup here

RAC First node :

Step 1:

Below rpm package need to installed on rac first node.

[root@racnode1 ~]# rpm -qa|grep bind
bind-libs-9.3.6-20.P1.el5_8.6
bind-9.3.6-20.P1.el5_8.6
system-config-bind-4.0.3-6.el5
bind-utils-9.3.6-20.P1.el5_8.6

 

Step 2:

check named.conf file available in /etc/ and also /var/named, If it’s not available, Please copy those files from

[root@racnode1 etc]# pwd
/usr/share/doc/bind-9.3.6/sample/etc
[root@racnode1 etc]# ls
named.conf named.conf.bkp named.rfc1912.zones named.root.hints rndc.conf
[root@racnode1 etc]# cp * /etc

 

[root@racnode1 etc]# cd ..
[root@racnode1 sample]# cd var
[root@racnode1 var]# ls
named var
[root@racnode1 var]# cp -r named /var

 

Step 3: edit the file like below

[root@racnode1 var]# cat /etc/named.conf
//
// Sample named.conf BIND DNS server ‘named’ configuration file
// for the Red Hat BIND distribution.
//
// See the BIND Administrator’s Reference Manual (ARM) for details, in:
// file:///usr/share/doc/bind-*/arm/Bv9ARM.html
// Also see the BIND Configuration GUI : /usr/bin/system-config-bind and
// its manual.
//
options
{
// Those options should be used carefully because they disable port
// randomization
// query-source port 53;
// query-source-v6 port 53;

// Put files that named is allowed to write in the data/ directory:
directory “/var/named”; // the default
dump-file “data/cache_dump.db”;
statistics-file “data/named_stats.txt”;
// memstatistics-file “data/named_mem_stats.txt”;
forwarders {192.168.1.1;};

};
key ddns_key
{
algorithm hmac-md5;
secret “gTsUbdMeXIAIOfeSUO6abZ2LkFqwOu3gKHih1Y4jqNEJeQXnnBM8S1xx”;
};

zone “racnode.com” IN {
type master;
file “racnode.com.zone”;
allow-update { none; };
};

zone “1.168.192.in-addr.arpa.” IN {
type master;
file “1.168.192.in-addr.arpa”;
allow-update { none; };
};

Step 4:  Create entries in zone file

[root@racnode1 named]# cat 1.168.192.in-addr.arpa

$TTL 86400
$ORIGIN 1.168.192.in-addr.arpa.

@ IN SOA racnode1.racnode.com. root.racnode.com.( 2
3H
1H
1W
1H )
IN NS 192.168.1.101
IN NS 192.168.1.1
101 IN PTR racnode1.racnode.com.
102 IN PTR racnode2.racnode.com.
111 IN PTR racnode1-vip.racnode.com.
112 IN PTR racnode2-vip.racnode.com.
201 IN PTR rac-scan.racnode.com.
202 IN PTR rac-scan.racnode.com.
203 IN PTR rac-scan.racnode.com.

 

[root@racnode1 named]# cat racnode.com.zone
$TTL 86400
@ IN SOA racnode.com. racnode.com.(
42 ; serial (d. adams)
3H ; refresh
15M ; retry
1W ; expiry
1D ) ; minimum
racnode.com. IN NS 192.168.1.101
localhost IN A 127.0.0.1
racnode1.racnode.com. IN A 192.168.1.101
racnode2.racnode.com. IN A 192.168.1.102
racnode1-vip.racnode.com. IN A 192.168.1.111
racnode2-vip.racnode.com. IN A 192.168.1.112
rac-scan.racnode.com. IN A 192.168.1.201
rac-scan.racnode.com. IN A 192.168.1.202
rac-scan.racnode.com. IN A 192.168.1.203

 

Step 5: Start the named service

 

[root@racnode1 named]# service named start
Starting named: [ OK ]

[root@racnode1 named]# chkconfig named on

Step 6: resolv.conf looks like below

[root@racnode1 named]# cat /etc/resolv.conf

search racnode.com
nameserver 192.168.1.101
options timeout:1
options attempts:2

Step 6:

[root@racnode1 named]# nslookup rac-scan
Server: 192.168.1.101
Address: 192.168.1.101#53

Name: rac-scan.racnode.com
Address: 192.168.1.203
Name: rac-scan.racnode.com
Address: 192.168.1.201
Name: rac-scan.racnode.com
Address: 192.168.1.202

Step 7:  Go to  second node

[root@racnode2 ~]# service named status
named is stopped
[root@racnode2 ~]# cat /etc/resolv.conf
search racnode.com

nameserver 192.168.1.101

options timeout:1
options attempts:2

[root@racnode2 ~]# nslookup rac-scan
Server: 192.168.1.101
Address: 192.168.1.101#53

Name: rac-scan.racnode.com
Address: 192.168.1.201
Name: rac-scan.racnode.com
Address: 192.168.1.202
Name: rac-scan.racnode.com
Address: 192.168.1.203

 

Step 8: /etc/hosts file look like below on each node but don’t added scan address here

[root@racnode1 named]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost.localdomain localhost6 localhost
# Public
192.168.1.101 racnode1.racnode.com racnode1 racnode1
192.168.1.102 racnode2.racnode.com racnode2
# Private
10.10.1.1 racnode1-priv.racnode.com racnode1-priv
10.10.1.2 racnode2-priv.racnode.com racnode2-priv
# Virtual
192.168.1.111 racnode1-vip.racnode.com racnode1-vip
192.168.1.112 racnode2-vip.racnode.com racnode2-vip

 

Step 9:

[root@racnode1 named]# grep ^hosts /etc/nsswitch.conf
hosts: files dns

Backup the Siebel Gateway name server data

Its necessary to take the backup of siebel gateway name server data before or after making any configuration changes.  So you should take the backup of siebns.dat file

Application :

Administration-  system configuration –> Enterprises

Click Backup enterprise ( it will generate siebns.dat along with date in gateway server).

or Command prompt

[siebel@premiadb siebsrvr]$  srvrmgr /g premiadb /e MigEnt /u SADMIN /p  password

srvrmgr> backup nameserver
Command completed successfully.

We can use below command also

srvrmgr> backup namesrvr
Command completed successfully.

 

Backup location in linux :

[siebel@premiadb admin]$ pwd
/premia/siebel/siebent/gtwysrvr/admin
[siebel@premiadb admin]$ ls -ltr siebns*
-rw-r–r– 1 siebel siebapp 117 Feb 4 10:34 siebns.dat
-rw-r–r– 1 siebel siebapp 1192361 Feb 23 14:45 siebns.dat_20160223_144538
-rw-r–r– 1 siebel siebapp 1192361 Feb 23 14:46 siebns.dat_20160223_144614

 

Step by step Siebel 15.0 Industry applications installation guide on Redhat Linux 6.2

Hello Guys, If you are looking the siebel installation guide on redhat linux 6 , this document will guide you to install  siebel 15.o industry application on redhat linux 6.2.  This document may be useful for you when you’re going to deployment siebel on your environment.

Download the document :

Step by step Siebel 15.0 industry applications installation guide on Redhat linux 6.2

User creation with particular directory access through FTP

Requirements :

Create a user

The user should not able to access through terminal like putty…etc

The user Should able to access his custom report directory path only with ftp client

the user need that directory path read and write permission

OS: Redhat 5.6 64bit

Step 1:

check below package are installed or not
[root@ebsdev ~]# rpm -qa|grep vsftpd

Step2 : If its not installed, install below rpm package

[root@ebsdev install]# ls
vsftpd-2.0.5-16.el5_5.1.x86_64.rpm
[root@ebsdev install]# rpm -ivh vsftpd-2.0.5-16.el5_5.1.x86_64.rpm
warning: vsftpd-2.0.5-16.el5_5.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:vsftpd ########################################### [100%]
Step 3:

[root@ebsdev install]# service vsftpd restart
Shutting down vsftpd: [FAILED]
Starting vsftpd for vsftpd: [ OK ]

Step 4: User creation

[root@ebsdev install]# useradd -g dba ftpuser
[root@ebsdev install]# passwd ftpuser

Step 5: Provide that directory path only access this to ftp user

[root@ebsdev ~]# chmod o+w /u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US

[root@ebsdev install]# usermod -d /u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US ftpuser

step 6: Disabled signon access for terminals

modified the line

[root@ebsdev install]# vi /etc/passwd

from

ftpuser:x:504:500::/u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US:/bin/bash

to
ftpuser:x:504:500::/u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US:/sbin/nologin

Step 7: allow chroot local user in ftp

[root@ebsdev vsftpd]# pwd
/etc/vsftpd
[root@ebsdev vsftpd]# vi vsftpd.conf

Add below Bolded line

# You may specify an explicit list of local users to chroot() to their home
# directory. If chroot_local_user is YES, then this list becomes a list of
# users to NOT chroot().
#chroot_list_enable=YES
chroot_local_user=YES

Step 8: restart vsftpd service

[root@ebsdev vsftpd]#service vsftpd restart

step 9: Try to login with credentials in ftp and also putty terminal

You can’t login in putty but you can able to login FTP with home path which directory you configured, you can’t go other directory. you have only that directory access.

 

Siebel ERP Integration performance issue

Users are always complaint about siebel erp integration performance issue when they are doing push the approval data to erp r12. It will take approximately 2 to 4 minutes.

So I took the awr reports from both database  and crosschecked both with some interval, the siebel database performance is good but erp database saying there is integration related packages sql elasped time little bit more.

So i just went to siebel application and look the all components group log level ,How about ? Yes I found out there some of the components groups logging was enabled to 5, It should not be like always,  So I have decreased the default log level to 1 and clear that web service cache, and then I tried to push the transaction, it completed within 10 seconds.

And also i have disabled SOA auditing feature from ERP, Now data came within 4 seconds.

 

ORA-24247: network access denied by access control list (ACL)

 

SQL> begin
send_mail(‘test’,’azarmohds@gmail.com’);
end;
2 3 4
5 /
begin
*
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 19
ORA-06512: at “SYS.UTL_TCP”, line 280
ORA-06512: at “SYS.UTL_SMTP”, line 163
ORA-06512: at “SYS.UTL_SMTP”, line 199
ORA-06512: at “SCOTT.SEND_MAIL”, line 8
ORA-06512: at line 2

This error message means that no access control list has been assigned to the host you (your application) are trying to access, or no required privileges have been granted to the user by adding user to the ACL.

Solution :

Step 1:

SQL> grant execute on utl_http to scott;

Grant succeeded.

Step 2:  Conn as sysdba

BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => ‘scottdev.xml’,
description => ‘Permissions to access  mail’,
principal => ‘SCOTT’,
is_grant => TRUE,
privilege => ‘connect’,
start_date => SYSTIMESTAMP,
end_date => NULL);
COMMIT;
END;
/

PL/SQL procedure successfully completed.

Step 3:

SQL> begin
2 DBMS_NETWORK_acl_ADMIN.ADD_PRIVILEGE(
3 acl => ‘scottdev.xml’,
4 principal => ‘SCOTT’,
5 is_grant => true,
6 privilege => ‘resolve’
7 );
8 COMMIT;
9 END;
10 /

PL/SQL procedure successfully completed.

Step 4:

SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => ‘scottdev.xml’,
host => ‘*’);
COMMIT;
END;
/

 

Step 5:

select acl , host , lower_port , upper_port from DBA_NETWORK_ACLS;

select acl , principal , privilege , is_grant from DBA_NETWORK_ACL_PRIVILEGES

Step 6: Send mail as scott user

SQL> begin
send_mail(‘test’,’azarmohds@gmail.com’);
end; 2 3
4 /

PL/SQL procedure successfully completed.

 

Drop ACL :

BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => ‘scottdev.xml”);
COMMIT;
END;
/

failed to create user while installing oracle 12c in windows server 2012 R2

When  I am trying to install oracle 12c software in windows server 2012 r2, Its asking the windows user credentials. So I had given the windows new user “Test” and password like ” Test@123″ . Oracle installer accepted this password but windows not accepted this password because of password poilcy.

  • Atleast 8 characters inlcude letter, number, symbol
  • Also Don’t put your password letter as same like user name. It should not be identical.

Example :

User : Test

password : P@ssw0rd

Oracle 12c forms is released

Oracle 12c forms is released now. Please find the download link here

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object

Please follow the note id

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object (Doc ID 1619940.1)

Generate WSDL Command Errors With Inserted value too large for column (Doc ID 1913216.1)

Note : please check translator.jar file permission ,If It doesn’t have group permission , please

chmod g+w translator.jar

Follow

Get every new post delivered to your Inbox.

Join 171 other followers