Oracle has announced an extended maintenance period for Oracle 10.2 from August 01, 2010, until July 31, 2013.
During the first year (from August 01, 2010 to July 31, 2011), Oracle will provide this extended maintenance at no extra cost.
During the period from August 01. 2011 to July 31, 2013, extended maintenance for Oracle 10.2 is subject to an additional fee.
For more information, see SAP Note 1110995 and SAP Note 1339724.
SAP Note 1110995 - Extended maintenance for Oracle Version 10.2
SAP Note 1339724 - Oracle 10.2 Extended Support free until July 31, 2011
Monday, June 13, 2011
Heterogeneous Environment - DBCI on unix and Apps on Windows or Linux
Check these notes for further information:
1067221 - Composite note for heterogeneous installation
531069 - Heterogeneous Unix - Unix Systems
1067221 - Composite note for heterogeneous installation
531069 - Heterogeneous Unix - Unix Systems
CIFS CONFIGURATION ON HPUX.
1. Configured Samba configuration files.
cd /etc/opt/samba
vi smb.conf
Change below lines
Enter as per your requirement
workgroup = HPUXSERVER
remove comment and change as per requirement
netbios name = tstmig
go to shared directory settings and configured as per your requirement.
[homes]
comment = Home Directories
path = /home/%U
browseable = yes
writable = yes
create mask = 0700
directory mask = 0700
2. Add user into samba user ( this user should be created in operating system before creating here )
# /opt/samba/bin/smbpasswd -a ituser
New SMB password:
Retype new SMB password:
Added user ituser.
Password = ituser123
3. Start / stop samba server
/opt/samba/bin/startsmb
/opt/samba/bin/stopsmb
4. Accessing HPUX server and samba directory from windows.
\\10.32.1.30\homes
\\10.32.1.30\ -> in this case it prompt for username and password, specify username and password which created in step 2
5. As per my requirement I shared directory with below details.
Reason for 777 is samba user can able to add, modify and remove files.
Reason for force user and group is the files are transfer here is going to be used by SAP application server hence owner should beadm.
[dataupload]
comment = data upload directories
path = /home/dataupload
browseable = yes
writable = yes
create mask = 0777
directory mask = 0777
force user = pipadm
force group = sapsys
valid users = ituser
6. Configuring Automatic Start at System Boot
When the HP CIFS Server is first installed, it will not automatically start when the system boots.
You can enable the HP CIFS Server and related daemons to do so by editing the
/etc/rc.config.d/samba file.This configuration file contains two variables:
RUN_SAMBA=0
RUN_WINBIND=0
The RUN_SAMBA variable controls whether HP CIFS Server daemons, smbd and nmbd, will start at system startup. The RUN_WINBIND variable controls whether the winbind daemon, winbindd, will start at system startup. The two variables function independently.
To configure HP CIFS Server to start automatically, set RUN_SAMBA to a non-zero value. To configure Winbind to start automatically, set RUN_WINBIND to a non-zero value. For example,
if you want HP CIFS Server and Winbind to start automatically at system startup, edit the
variables in the /etc/rc.config.d/samba file as follows:
RUN_SAMBA=1
RUN_WINBIND=1
7. Other Sambha validation parameters
valid users = %S
• hosts allow
• hosts deny
• hosts equiv
• preload modules
• wins server
• vfs objects
• idmap backend
netbios aliases
• interfaces
• auth methods
• passdb backend
• invalid users
• valid users
• admin users
• read list
• write list
• printer admin
cd /etc/opt/samba
vi smb.conf
Change below lines
Enter as per your requirement
workgroup = HPUXSERVER
remove comment and change as per requirement
netbios name = tstmig
go to shared directory settings and configured as per your requirement.
[homes]
comment = Home Directories
path = /home/%U
browseable = yes
writable = yes
create mask = 0700
directory mask = 0700
2. Add user into samba user ( this user should be created in operating system before creating here )
# /opt/samba/bin/smbpasswd -a ituser
New SMB password:
Retype new SMB password:
Added user ituser.
Password = ituser123
3. Start / stop samba server
/opt/samba/bin/startsmb
/opt/samba/bin/stopsmb
4. Accessing HPUX server and samba directory from windows.
\\10.32.1.30\homes
\\10.32.1.30\ -> in this case it prompt for username and password, specify username and password which created in step 2
5. As per my requirement I shared directory with below details.
Reason for 777 is samba user can able to add, modify and remove files.
Reason for force user and group is the files are transfer here is going to be used by SAP application server hence owner should be
[dataupload]
comment = data upload directories
path = /home/dataupload
browseable = yes
writable = yes
create mask = 0777
directory mask = 0777
force user = pipadm
force group = sapsys
valid users = ituser
6. Configuring Automatic Start at System Boot
When the HP CIFS Server is first installed, it will not automatically start when the system boots.
You can enable the HP CIFS Server and related daemons to do so by editing the
/etc/rc.config.d/samba file.This configuration file contains two variables:
RUN_SAMBA=0
RUN_WINBIND=0
The RUN_SAMBA variable controls whether HP CIFS Server daemons, smbd and nmbd, will start at system startup. The RUN_WINBIND variable controls whether the winbind daemon, winbindd, will start at system startup. The two variables function independently.
To configure HP CIFS Server to start automatically, set RUN_SAMBA to a non-zero value. To configure Winbind to start automatically, set RUN_WINBIND to a non-zero value. For example,
if you want HP CIFS Server and Winbind to start automatically at system startup, edit the
variables in the /etc/rc.config.d/samba file as follows:
RUN_SAMBA=1
RUN_WINBIND=1
7. Other Sambha validation parameters
valid users = %S
• hosts allow
• hosts deny
• hosts equiv
• preload modules
• wins server
• vfs objects
• idmap backend
netbios aliases
• interfaces
• auth methods
• passdb backend
• invalid users
• valid users
• admin users
• read list
• write list
• printer admin
APA CONFIGURATION ON HPUX
1. Login with management console.
2. Start smh
Choose Networking and communication.
3. Choose network interface configuration
4. Choose network interface card
Check both network card should not contain any ip address.
Select network card and press enter.
On this card ip address already configured.
Press Cntrl o – Other Actions.
Choose D-Delete IP
Select delete again.
5. Choose Auto port Aggregation
6. Choose c - create link aggregate.
7. Select Mode = LACP_AUTO and choose both network card and select OK.
Click on OK
8. Now you get aggregated network interface name.
9. Press Enter and assign IP address and other details.
Choose p – View / Modify IP Attributes
2. Start smh
Choose Networking and communication.
3. Choose network interface configuration
4. Choose network interface card
Check both network card should not contain any ip address.
Select network card and press enter.
On this card ip address already configured.
Press Cntrl o – Other Actions.
Choose D-Delete IP
Select delete again.
5. Choose Auto port Aggregation
6. Choose c - create link aggregate.
7. Select Mode = LACP_AUTO and choose both network card and select OK.
Click on OK
8. Now you get aggregated network interface name.
9. Press Enter and assign IP address and other details.
Choose p – View / Modify IP Attributes
Activate and Configure SAP ITS Webgui on SAP ECC 6.0
Since SAP ECC 5.0 and ECC 6.0, SAP has integrates its SAP Internet Transaction Server (ITS) on its server. You don’t need to install separate ITS server. You just need to activate and configure it. Follow this procedure:
1. Check if you have activated and your webgui is working for not.
First you have to know your http server port.
Call transaction SMICM
Click on services.
Check HTTP service, port number and host name.
Open internet explorer and call SAP Web GUI.
http://:8000/sap/bc/gui/sap/its/webgui/
Come across error message means its not yet configured.
2. Check if not acivated then need to activate:
With transaction SICF and locate the services by path
/sap/public/bc/its/mimes
/sap/bc/gui/sap/its/webgui
/sap/public/bc/ur
3. With Transaction SE80 locate from the menu, Utilities –> Settings–>Internet Transaction Server (Tab)–>Publish (Tab) and set “On Selected Site” = INTERAL.
This restricts the publication in the next step to the integrated (internal) ITS.
4. In SE80 only, Locate the Internet Services: SYSTEM and WEBGUI.
Publish these services with the Context Menu -> Publish -> Complete Service
5. Open internet explorer http://:8000/sap/bc/gui/sap/its/webgui/
Please enter username and password.
This will start SAP GUI for HTML.
SAPGUI get opened.
Effects on System Administration
You can administer SAP Integrated ITS using the following SAP Transactions:
1. RZ10 – definition of parameters
2. SICF – configuration of the ITS service
3. ST11 – traces
4. SITSPMON – status of integrated ITS
My integrated ITS doesn't work. What should I do?
See note 698329 in order to find out what is wrong with your integrated ITS. If you get memory errors when you start an ITS application, see also SAP note 742048
for more information.
How to prefill fields and skip first screen with webgui?
Often it is desired to prefill fields of a screen and skip this screen by triggering an okcode. The SAP kernel provides a special okcode functionality which can be used with webgui and SAP GUI. You have to create a okcode with the following syntax:
*FIELD_1=VALUE_1;FIELD_2=VALUE_2.......FIELD_N=VALUE_N;DYNP_OKCODE=OKCODE
If you i.e. use this with the ABAP editor SE38 and enter
*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
in the transaction code field of webgui or SAP GUI, the ABAP editor will be started with directly showing the ABAP code of RSPARAM. You can also make use of this in the URL with the well known ~transaction parameter.
For ITS 6.20 standalone with i.e. R/3 Enterprise 4.7 the URL would be
http://ITS_HOST:ITS_PORT/scripts/wgate/webgui/!?~transaction=*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
If you use SAP Netweaver 2004 or higher with integrated ITS the URL would be
http://WAS_HOST:WAS_PORT/sap/bc/gui/sap/its/webgui?~transaction=*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
After authenticating the user, the SAP system will automatically process the transaction and skip the first screen.
Parameter ~okcode is obsolete for skipping screens
Many of you may know, that the parameter ~okcode provides a similar functionality with ITS 6.20. However it is not recommended anymore to use it for skipping screens. One reason is, that the solution discussed above provides much more performance because it avoids superfluous roundtrips between the SAP kernel an ITS 6.20. The other is that with SAP Netweaver 2004 and above the ~okcode syntax no longer works in any case. Therefore just forget screen skipping with ~okcode and make use of the method described above.
How to terminate a user session with integrated ITS when the transaction ends?
This tutorial describes how to delete the user session with the parameter ~singletransaction when the transaction started with ~transaction ends.
When calling a transaction with ITS 6.20 using the parameter ~transaction, ITS takes care to delete the session when the transaction ends. With SAP Netweaver and integrated ITS this don't work because session handling is not longer done by ITS but by the SAP kernel itself. When a transaction ends the system shows the transaction selection screen with the "Start Easy Access Menu" button.
In a portal environment this is often not desired. SAP therefore enhanced the kernel to provide a similar functionality as with ITS 6.20. To activate this functionality you have to set the parameter ~singletransaction=1 in the ICF service. This parameter tells ITS to ask the SAP kernel to logoff a user session at the end of transaction. SAP note 959417 describes the kernel and support package requirements. For those who do not currently have access to the SAP service marketplace:
SAP Netweaver 2004, aka 640:
Kernelpatch: 136
ABAP Support-Package: SAPKB64018
SAP Netweaver 2004s, aka 700:
Kernelpatch: 66
ABAP Support-Package: SAPKB70009
The parameter has the limitation that it doesn't work if the transaction is terminated with LEAVE TO TRANSACTION. You should therefore not use this parameter with the standard webgui service but create an own z-service in SICF with ~transaction set to the tcode you want to provide your users.
How to customize the login screen?
Many customers would like to customize the ITS login page, so that it fits to their corporate standards. If you search information about how to customize the login page either in ITS 6.20 or with SAP Netweaver 2004/2004s/2007 with integrated ITS read this tutorial.
ITS 6.20 standalone
If you want to customize ITS system templates (and login page is one of these), ITS provides an easy way to do this. The system folder below SAP/ITS/6.20//templates contains two folders dm and pm. dm stands for development mode, pm for production mode. By default ITS stores the system templates in the dm folder. If you want to customize one of the ITS system templates just copy it to the pm folder. There you can modify it as you like. When ITS looks for a system template, it will at first look in pm. If it finds the template there it will use it. Otherwise it will look in dm. To modify the login page just copy the login.html from dm to pm and change it according to your requirement. From now on ITS will use this template for login. If you want to use a service specific login page create a template with the name login.html and store it beside your other service templates. When a user wants to login to this service, ITS will use this template for the login screen. For ITSmobile ITS 6.20 of patchlevel 27 or higher contains a special login page for ITSmobile which fits to the small display of mobile devices. The name is of the template is loginmobile.html. If you want to modify the mobile login page proceed as described above and copy loginmobile.html to pm or to your service directory.
SAP Netweaver
With SAP Netweaver 2004 ITS is part of the SAP kernel. The login page is therefore no longer a functionality of ITS but of the Web Application Server (WAS). By default ITS Services uses the standard system login pages that WAS provides. You can customize in transaction SICF what login procedure should be used and which fields should be available on system login page. This can be done global or per service. The documentation on the SAP help portal contains information how this can be done. It is even possible to create an own login page by inheriting an own login class from CL_ICF_SYSTEM_LOGIN. You can find detailed information about how to do this on the SAP help portal System Logon. For mobile devices Netweaver provides the CL_MOBILE_SYSTEM_LOGIN class.
1. Check if you have activated and your webgui is working for not.
First you have to know your http server port.
Call transaction SMICM
Click on services.
Check HTTP service, port number and host name.
Open internet explorer and call SAP Web GUI.
http://
Come across error message means its not yet configured.
2. Check if not acivated then need to activate:
With transaction SICF and locate the services by path
/sap/public/bc/its/mimes
/sap/bc/gui/sap/its/webgui
/sap/public/bc/ur
3. With Transaction SE80 locate from the menu, Utilities –> Settings–>Internet Transaction Server (Tab)–>Publish (Tab) and set “On Selected Site” = INTERAL.
This restricts the publication in the next step to the integrated (internal) ITS.
4. In SE80 only, Locate the Internet Services: SYSTEM and WEBGUI.
Publish these services with the Context Menu -> Publish -> Complete Service
5. Open internet explorer http://
Please enter username and password.
This will start SAP GUI for HTML.
SAPGUI get opened.
Effects on System Administration
You can administer SAP Integrated ITS using the following SAP Transactions:
1. RZ10 – definition of parameters
2. SICF – configuration of the ITS service
3. ST11 – traces
4. SITSPMON – status of integrated ITS
My integrated ITS doesn't work. What should I do?
See note 698329 in order to find out what is wrong with your integrated ITS. If you get memory errors when you start an ITS application, see also SAP note 742048
for more information.
How to prefill fields and skip first screen with webgui?
Often it is desired to prefill fields of a screen and skip this screen by triggering an okcode. The SAP kernel provides a special okcode functionality which can be used with webgui and SAP GUI. You have to create a okcode with the following syntax:
*
If you i.e. use this with the ABAP editor SE38 and enter
*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
in the transaction code field of webgui or SAP GUI, the ABAP editor will be started with directly showing the ABAP code of RSPARAM. You can also make use of this in the URL with the well known ~transaction parameter.
For ITS 6.20 standalone with i.e. R/3 Enterprise 4.7 the URL would be
http://ITS_HOST:ITS_PORT/scripts/wgate/webgui/!?~transaction=*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
If you use SAP Netweaver 2004 or higher with integrated ITS the URL would be
http://WAS_HOST:WAS_PORT/sap/bc/gui/sap/its/webgui?~transaction=*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
After authenticating the user, the SAP system will automatically process the transaction and skip the first screen.
Parameter ~okcode is obsolete for skipping screens
Many of you may know, that the parameter ~okcode provides a similar functionality with ITS 6.20. However it is not recommended anymore to use it for skipping screens. One reason is, that the solution discussed above provides much more performance because it avoids superfluous roundtrips between the SAP kernel an ITS 6.20. The other is that with SAP Netweaver 2004 and above the ~okcode syntax no longer works in any case. Therefore just forget screen skipping with ~okcode and make use of the method described above.
How to terminate a user session with integrated ITS when the transaction ends?
This tutorial describes how to delete the user session with the parameter ~singletransaction when the transaction started with ~transaction ends.
When calling a transaction with ITS 6.20 using the parameter ~transaction, ITS takes care to delete the session when the transaction ends. With SAP Netweaver and integrated ITS this don't work because session handling is not longer done by ITS but by the SAP kernel itself. When a transaction ends the system shows the transaction selection screen with the "Start Easy Access Menu" button.
In a portal environment this is often not desired. SAP therefore enhanced the kernel to provide a similar functionality as with ITS 6.20. To activate this functionality you have to set the parameter ~singletransaction=1 in the ICF service. This parameter tells ITS to ask the SAP kernel to logoff a user session at the end of transaction. SAP note 959417 describes the kernel and support package requirements. For those who do not currently have access to the SAP service marketplace:
SAP Netweaver 2004, aka 640:
Kernelpatch: 136
ABAP Support-Package: SAPKB64018
SAP Netweaver 2004s, aka 700:
Kernelpatch: 66
ABAP Support-Package: SAPKB70009
The parameter has the limitation that it doesn't work if the transaction is terminated with LEAVE TO TRANSACTION. You should therefore not use this parameter with the standard webgui service but create an own z-service in SICF with ~transaction set to the tcode you want to provide your users.
How to customize the login screen?
Many customers would like to customize the ITS login page, so that it fits to their corporate standards. If you search information about how to customize the login page either in ITS 6.20 or with SAP Netweaver 2004/2004s/2007 with integrated ITS read this tutorial.
ITS 6.20 standalone
If you want to customize ITS system templates (and login page is one of these), ITS provides an easy way to do this. The system folder below SAP/ITS/6.20/
SAP Netweaver
With SAP Netweaver 2004 ITS is part of the SAP kernel. The login page is therefore no longer a functionality of ITS but of the Web Application Server (WAS). By default ITS Services uses the standard system login pages that WAS provides. You can customize in transaction SICF what login procedure should be used and which fields should be available on system login page. This can be done global or per service. The documentation on the SAP help portal contains information how this can be done. It is even possible to create an own login page by inheriting an own login class from CL_ICF_SYSTEM_LOGIN. You can find detailed information about how to do this on the SAP help portal System Logon. For mobile devices Netweaver provides the CL_MOBILE_SYSTEM_LOGIN class.
SAP STANDARD JOB CHECK AND SCHEDULE for SAP ECC / R3 Server
Refer SAP Note 16083 - Standard jobs, reorganization jobs
| Job | Job Info | In my system | As per SAP Note |
| SAP_REORG_JOBS | Deletes old background jobs | Present and scheduled at 04:15:00 | Need to schedule daily with Variant yes |
| SAP_REORG_SPOOL | Deletes old spool data | Present and scheduled at 03:30:00 | Need to schedule daily with Variant yes |
| SAP_REORG_BATCHINPUT | Deletes old batch input sessions | Present and scheduled at 04:15:00 | Need to schedule daily with Variant yes |
| SAP_REORG_ABAPDUMPS | Deletes old ABAP short dumps | Present and scheduled at 03:00:00 | Need to schedule daily with Variant yes |
| SAP_REORG_JOBSTATISTIC | Deletes old data from the job runtime statistics | Not present and not scheduled | Need to schedule monthly with Variant yes |
| SAP_COLLECTOR_FOR_JOBSTATISTIC | Generates runtime statistics for background jobs | Not present and not scheduled | Need to schedule daily |
| SAP_COLLECTOR_FOR_PERFMONITOR | Collects data for the performance monitor | Present and scheduled | Need to schedule hourly |
| SAP_CCMS_MONI_BATCH_DP | Dispatches monitoring architecture methods | Present and scheduled | Need to schedule hourly |
Below are recommended as per sap note and http://help.sap.com/saphelp_nw70/helpdata/en/24/b884388b81ea55e10000009b38f842/frameset.htm but not scheduled by me.
| SAP_REORG_UPDATERECORDS | Deletes old update requests |
|
|
| SAP_SPOOL_CONSISTENCY_CHECK |
| Not present and not scheduled | Need to schedule daily with Variant yes |
| SAP_REORG_PRIPARAMS |
|
| Need to schedule monthly |
| SAP_REORG_ORPHANED_JOBLOGS |
| Not present and not scheduled | Need to schedule weekly with Variant yes |
| SAP_CHECK_ACTIVE_JOBS |
| Not present and not scheduled | Need to schedule hourly with Variant yes |
| SAP_DELETE_ORPHANED_IVARIS |
| Not present and not scheduled | Need to schedule weekly with Variant ja |
| SAP_REORG_ORPHANED_TEMSE_FILES |
| Not present and not scheduled | Need to schedule weekly with Variant ja |
SAP_CCMS_MONI_BATCH_DP is not a reorganization job but is needed to start tools / methods in the system monitoring area in the background -> transaction RZ20/RZ21.
Function fopen() failed for '/oracle/PIP/sapbackup/befyqyra.tib' at location main-9
Come across below error message during executing of br commands.
BR0252E Function fopen() failed for '/oracle/PRD/sapbackup/befyqyra.tib' at location main-9
Post patch update permission are not correcting set of BRTools files.
SERVER:oraprd 6> ls -la /sapmnt/PRD/exe/br*
-rwxrwxr-x 1 oraprd dba 15409552 Jan 29 21:14 /sapmnt/PRD/exe/brarchive
-rwxrwxr-x 1 oraprd dba 15916368 Jan 29 21:18 /sapmnt/PRD/exe/brbackup
-rwxrwxr-x 1 oraprd dba 20199200 Jan 29 21:36 /sapmnt/PRD/exe/brconnect
-rwxrwxr-x 1 oraprd dba 16622720 Jan 29 21:39 /sapmnt/PRD/exe/brrecover
-rwxrwxr-x 1 oraprd dba 6909792 Jan 29 21:41 /sapmnt/PRD/exe/brrestore
-rwxrwxr-x 1 oraprd dba 22033288 Jan 29 21:57 /sapmnt/PRD/exe/brspace
-rwxrwxr-x 1 oraprd dba 9044344 Jan 29 22:01 /sapmnt/PRD/exe/brtools
As Per
brarchive, brbackup, and brconnect have permission 4775:
-rwsrwxr-x ora sapsys ...
These can be started by the ora or the adm OS user.
brrestore, brrecover, brspace, brtools, and sapdba have permission 755:
-rwxr-xr-xadm sapsys ...
These should only be started by the ora OS user.
SERVER:oraprd 7> cd /sapmnt/PRD/exe/
SERVER:oraprd 8> chmod 4775 /sapmnt/PRD/exe/brarchive
SERVER:oraprd 10> chmod 4775 /sapmnt/PRD/exe/brbackup
SERVER:oraprd 11> chmod 4775 /sapmnt/PRD/exe/brconnect
SERVER:oraprd 13> chmod 755 /sapmnt/PRD/exe/brrecover
SERVER:oraprd 15> chmod 755 /sapmnt/PRD/exe/brrestore
SERVER:oraprd 16> chmod 755 /sapmnt/PRD/exe/brspace
SERVER:oraprd 17> chmod 755 /sapmnt/PRD/exe/brtools
SERVER:oraprd 18> ls -la /sapmnt/PRD/exe/br*
-rwsrwxr-x 1 oraprd dba 15409552 Jan 29 21:14 /sapmnt/PRD/exe/brarchive
-rwsrwxr-x 1 oraprd dba 15916368 Jan 29 21:18 /sapmnt/PRD/exe/brbackup
-rwsrwxr-x 1 oraprd dba 20199200 Jan 29 21:36 /sapmnt/PRD/exe/brconnect
-rwxr-xr-x 1 oraprd dba 16622720 Jan 29 21:39 /sapmnt/PRD/exe/brrecover
-rwxr-xr-x 1 oraprd dba 6909792 Jan 29 21:41 /sapmnt/PRD/exe/brrestore
-rwxr-xr-x 1 oraprd dba 22033288 Jan 29 21:57 /sapmnt/PRD/exe/brspace
-rwxr-xr-x 1 oraprd dba 9044344 Jan 29 22:01 /sapmnt/PRD/exe/brtools
SERVER:oraprd 19>
BR0252E Function fopen() failed for '/oracle/PRD/sapbackup/befyqyra.tib' at location main-9
Post patch update permission are not correcting set of BRTools files.
SERVER:oraprd 6> ls -la /sapmnt/PRD/exe/br*
-rwxrwxr-x 1 oraprd dba 15409552 Jan 29 21:14 /sapmnt/PRD/exe/brarchive
-rwxrwxr-x 1 oraprd dba 15916368 Jan 29 21:18 /sapmnt/PRD/exe/brbackup
-rwxrwxr-x 1 oraprd dba 20199200 Jan 29 21:36 /sapmnt/PRD/exe/brconnect
-rwxrwxr-x 1 oraprd dba 16622720 Jan 29 21:39 /sapmnt/PRD/exe/brrecover
-rwxrwxr-x 1 oraprd dba 6909792 Jan 29 21:41 /sapmnt/PRD/exe/brrestore
-rwxrwxr-x 1 oraprd dba 22033288 Jan 29 21:57 /sapmnt/PRD/exe/brspace
-rwxrwxr-x 1 oraprd dba 9044344 Jan 29 22:01 /sapmnt/PRD/exe/brtools
As Per
-rwsrwxr-x ora
These can be started by the ora
brrestore, brrecover, brspace, brtools, and sapdba have permission 755:
-rwxr-xr-x
These should only be started by the ora
SERVER:oraprd 7> cd /sapmnt/PRD/exe/
SERVER:oraprd 8> chmod 4775 /sapmnt/PRD/exe/brarchive
SERVER:oraprd 10> chmod 4775 /sapmnt/PRD/exe/brbackup
SERVER:oraprd 11> chmod 4775 /sapmnt/PRD/exe/brconnect
SERVER:oraprd 13> chmod 755 /sapmnt/PRD/exe/brrecover
SERVER:oraprd 15> chmod 755 /sapmnt/PRD/exe/brrestore
SERVER:oraprd 16> chmod 755 /sapmnt/PRD/exe/brspace
SERVER:oraprd 17> chmod 755 /sapmnt/PRD/exe/brtools
SERVER:oraprd 18> ls -la /sapmnt/PRD/exe/br*
-rwsrwxr-x 1 oraprd dba 15409552 Jan 29 21:14 /sapmnt/PRD/exe/brarchive
-rwsrwxr-x 1 oraprd dba 15916368 Jan 29 21:18 /sapmnt/PRD/exe/brbackup
-rwsrwxr-x 1 oraprd dba 20199200 Jan 29 21:36 /sapmnt/PRD/exe/brconnect
-rwxr-xr-x 1 oraprd dba 16622720 Jan 29 21:39 /sapmnt/PRD/exe/brrecover
-rwxr-xr-x 1 oraprd dba 6909792 Jan 29 21:41 /sapmnt/PRD/exe/brrestore
-rwxr-xr-x 1 oraprd dba 22033288 Jan 29 21:57 /sapmnt/PRD/exe/brspace
-rwxr-xr-x 1 oraprd dba 9044344 Jan 29 22:01 /sapmnt/PRD/exe/brtools
SERVER:oraprd 19>
Wednesday, August 08, 2007
ORA-12560: TNS:protocol adapter error
I am receiving below error message when i try to connect to ORACLE through sqlplus.
sqlplus "/nolog"
connect sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
to resolved this i set ORACLE_SID parameter
set ORACLE_SID=EP6
sqlplus "/nolog"
connect sys as sysdba
this time i succeed with login.
sqlplus "/nolog"
connect sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
to resolved this i set ORACLE_SID parameter
set ORACLE_SID=EP6
sqlplus "/nolog"
connect sys as sysdba
this time i succeed with login.
Wednesday, June 13, 2007
Datafile usage in tablespace
select substr(a.file_name,1,30),
substr(a.tablespace_name,1,20),
a.bytes allocated,
nvl(b.free,0) free,
a.bytes-nvl(b.free,0) used,
(nvl((a.bytes-nvl(b.free,0)),0)*100)/a.bytes usage_perc
from dba_data_files a,
( select file_id, sum(bytes) free
from dba_free_space
group by file_id ) b
where a.file_id = b.file_id (+)
AND a.tablespace_name='&tablespace'
/
substr(a.tablespace_name,1,20),
a.bytes allocated,
nvl(b.free,0) free,
a.bytes-nvl(b.free,0) used,
(nvl((a.bytes-nvl(b.free,0)),0)*100)/a.bytes usage_perc
from dba_data_files a,
( select file_id, sum(bytes) free
from dba_free_space
group by file_id ) b
where a.file_id = b.file_id (+)
AND a.tablespace_name='&tablespace'
/
Saturday, February 24, 2007
Mount USB Pen Drive in to Linux.
Before plug in USB pen see /var/log/messages kernel through which you get device name and path. Here I get sdc as device name (or sda0, sda1 like that.).
Now mount it.
Mount for FAT file system
mount –t vfat /dev/sdc /mnt/mounttemp/
Mount for NTFS file system
mount –t ntfs /dev/sdc /mnt/mounttemp/
access your device
Subscribe to:
Posts (Atom)