SOME IMP TIPS

How to encrypt password in informatica:-

 pmpasswd password-e CRYPT_DATA

How To Repair A Corrupted SD Card or USB Flash Drive

How To Repair A Corrupted SD Card or USB Flash Drive

1)Go  to Cmd prompt :
as Administrator

2)write  diskpart cmd in cmd promt

diskpart

3) Now you will be DISKPART>

4) DISKPART>list disk

5) now run clean cmd
Clean

you can run this cmd 2-3 times.


6)Now run
create partition primary 

7)Now run
>active

8) select partition 1 


this partition is pendrive or flesh

9)format fs=fat32


when completed it will auto play

OBIEE 12c logs and Files ,services location.

log Files location in OBIEE 12c:-

File Locations of 11g and 12c  :-

11g:

• Upgrade log: Middleware\Oracle_BI1\upgrade\logs
• Admin Server log files: [MW_HOME]\user_projects\domains\bifoundation_domain\servers\AdminServer\logs
• Managed Server log files: [MW_HOME]\user_projects\domains\bifoundation_domain\servers\bi_server1\logs
• BI Server log files:[MW_HOME]\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
• Presentation Server log file:[MW_HOME]\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

12c:

• Upgrade log: ORACLE_HOME\user_projects\domains\bi\servers\obips1\logs
• Admin Server log files:ORACLE_HOME\user_projects\domains\bi\servers
• Managed Server log files: ORACLE_HOME\user_projects\domains\bi\servers
• BI Server log files:ORACLE_HOME\user_projects\domains\bi\servers\obis1\logs
• Presentation Server log file:ORACLE_HOME\user_projects\domains\bi\servers\obips1\logs

how to start and stop BI services OBIEE12c:-

cd orabi/obiee/Oracle_Home/user_projects/domains/bi/bitools/bin
[oracle@ServerName bin]$./stop.sh

Common scripts bin directory.  This contains the start, stop & status scripts along with the data-model-cmd script for common tasks such as uploading/downloading repositories, updating application roles & users & setting repository variables plus many other utility scripts:

/u01/app/obiee/user_projects/domains/bi/bitools/bin

Weblogic scripting tool – wlst.sh – used for perform backups of the BI content (to ‘bar’ files) and other weblogic tasks:

/u01/app/obiee/oracle_common/common/bin

Service Instances. Where the metadata for each installed BI instance is stored. There is one sub-directory for each instance and if you just performed a basic install there will just be one directory, probably called ‘ssi’

/user_projects/domains/bi/bidata/service_instances

Repository (RPD) files. These are kept beneath the Service Instances directory. Note you cannot directly edit these – or copy them down to your pc and edit them there. You must use the data-model-cmd to upload/download them:

/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations

Web Catalog.  Where the dashboards, reports, prompts and all other user content is stored, along with some catalog config files. The structure of these directories is identify to OBIEE 11g, starting with root, then shared, users etc..

/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/catalog

instanceconfig.xml. Normally you shouldn’t edit this file directly, you should use the mbean browser in enterprise manager, but there are occasions when you might need to.

/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

NQSConfig.INI. Again normally you shouldn’t edit this file directly, you should use the mbean browser in enterprise manager, but there are occasions when you might need to.

/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS/NQSConfig.INI

obis.properties. This file can be used to define environment variables for OBI.

/user_projects/domains/bi/config/fmwconfig/bienv/OBIS/obis.properties

config.xml. Security file containing, amount other items, the security realm details from weblogic – really handy if you have a LDAP issue and weblogic won’t start!

/user_projects/domains/bi/config

fmwconfig. This is a folder contain many security files – system-jazn-data.xml, various SSO, wallet and other security config files.

/user_projects/domains/bi/config/fmwconfig

xmlp-server-config.xml Configuration file for BI Publisher and the Mobile App Designer.

//user_projects/domains/bi/bidata/components/bipublisher/repository/Admin/Configuration/xmlp-server-config.xml

odbc.ini, odbcinst.ini & tnsnames.ora.  All three of the data source connection files are located together:

/user_projects/domains/bi/config/fmwconfig/bienv/core

odbc template files – useful for copying the basic config for new data sources into the actual odbc files used by OBIEE above:

/bi/common/ODBC/Merant/7.1.4

Log files.  There are still separate log files for the five BI components and the Admin & BI managed services within weblogic, but there are now all located together in the same area.

AdminServer Managed Service logs:

/user_projects/domains/bi/servers/AdminServer/logs

bi_server1 Managed Service logs:

/user_projects/domains/bi/servers/bi_server1/logs

BI Server logs:

/user_projects/domains/bi/servers/obis1/logs

Presentation server logs:          

/user_projects/domains/bi/servers/obips1/logs

Java Host logs:

/user_projects/domains/bi/servers/obijh1/logs

Cluster Component logs:

/user_projects/domains/bi/servers/obiccs1/logs

Scheduler logs:

/user_projects/domains/bi/servers/obisch1/logs

[oracle@ServerName]$ cd orabi/obiee/Oracle_Home/user_projects/domains/bi/bitools/bin
[oracle@ServerName bin]$./start.sh

New features in Oracle Database 12c

New features in Oracle Database 12c

Size Limit on Varchar2, NVarchar2, Raw Data Types increased:

The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement

 We can make a column invisible. 

SQL> create table test (column-name column-type invisible);
SQL> alter table table-name modify column-name invisible;
SQL> alter table table-name modify column-name visible;

Oracle Database 12c has new feature called "Identity Columns" 

which are auto-incremented at the time of insertion (like in MySQL).
SQL> create table dept (dept_id number generated as identity, dept_name varchar);
SQL> create table dept (dept_id number generated as identity (start with 1 increment by 1 cache 20 noorder), dept_name varchar);

 Temporary undo (for global temporary tables) will not generate undo. 

We can manage this by using init parameter temp_undo_enabled (=false|true).

Duplicate Indexes - Create duplicate indexes on the same set of columns. Till Oracle 11.2, if we try to create an index using the same columns, in the same order, as an existing index, we'll get an error. In some cases, we might want two different types of index on the same data (such as in a datawarehouse where we might want a bitmap index on the leading edge of a set of columns that exists in a Btree index).

PL/SQL inside SQL: this new feature allows to use DDL inside SQL statements (i.e.: to create a one shot function)

Pagination query:-

SQL keywords to limit the number of records to be displayed, and to replace ROWNUM records.
SQL> select ... fetch first n rows only;
SQL> select ... offset m rows fetch next n rows only;
SQL> select ... fetch first n percent rows only;
SQL> select ... fetch first n percent rows with ties;

select * from employees FETCH FIRST 2 PERCENT ROWS ONLY;

Moving and Renaming datafile is now ONLINE, no need to put data file in offline.
SQL> alter database move datafile 'path' to 'new_path';

The TRUNCATE command :-has been enhanced with a CASCADE option which follows child records.

Windows 10 Some tricks

Windows 10 Some tricks:-
----------------------------------

You can delete shorcut from below folder :-

%ProgramData%\Microsoft\Windows\Start Menu\Programs and
%AppData%\Microsoft\Windows\Start Menu\Programs 

Run the System File Checker tool (SFC.exe)

To do this, follow these steps:

1. Open an elevated command prompt. To do this, do the following as your appropriate:
   Windows 8.1 or Windows 8
   Swipe in from the right edge of the screen, and then tap Search. Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search. Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

         Windows 10, Windows 7, or Windows Vista

          To do this, click Start, type Command Prompt or cmd in the Search box, right-            click Command Prompt, and then click Run as administrator. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

At the command prompt, type the following command, and then press ENTER:

sfc /scannow

After the process is finished, you may receive one of the following messages:

• Windows Resource Protection did not find any integrity violations.
  
  This means that you do not have any missing or corrupted system files.
• Windows Resource Protection could not perform the requested operation.
  
  To resolve this problem, perform the System File Checker scan in safe mode, and make sure that the PendingDeletes and PendingRenames folders exist under %WinDir%\WinSxS\Temp.
• Windows Resource Protection found corrupt files and successfully repaired them. Details are included in the CBS.Log %WinDir%\Logs\CBS\CBS.log.
  
  To view the detail information about the system file scan and restoration, go to How to view details of the System File Checker process.
• Windows Resource Protection found corrupt files but was unable to fix some of them. Details are included in the CBS.Log %WinDir%\Logs\CBS\CBS.log.
  
  To repair the corrupted files manually, view details of the System File Checker process to find the corrupted file, and then manually replace the corrupted file with a known good copy of the file.

Unix commands

Best site for Unix:-
http://www.grymoire.com/Unix/Sed.html

1) SED:
Sed Command :-
1) s for substitution:-
sed s/day/night/ new
echo day | sed s/day/night/
o/p=night

single quote
echo Sunday | sed 's/day/night/'

Another important concept is that sed is line oriented. Suppose you have the input file:

one two three, one two three
four three two one
one hundred

and you used the command

sed 's/one/ONE/'
The output would be

ONE two three, one two three
four three two ONE
ONE hundred


Note that this changed "one" to "ONE" once on each line. The first line had "one" twice, but only the first occurrence was changed. 
That is the default behavior. If you want something different, you will have to use some of the options that are available. I'll explain them later.
s  Substitute command
/../../  Delimiter
one  Regular Expression Pattern Search Pattern
ONE  Replacement string


2)The slash as a delimiter:-

The character after the s is the delimiter. It is conventionally a slash, because this is what ed, more, and vi use. It can be anything you want, however.
If you want to change a pathname that contains a slash - say /usr/local/bin to /common/bin - you could use the backslash to quote the slash:


sed 's/\/usr\/local\/bin/\/common\/bin/' new

Gulp. Some call this a 'Picket Fence' and it's ugly. It is easier to read if you use an underline instead of a slash as a delimiter:

sed 's_/usr/local/bin_/common/bin_' new
Some people use colons:

sed 's:/usr/local/bin:/common/bin:' new
Others use the "|" character.

sed 's|/usr/local/bin|/common/bin|' new

3)Using & as the matched string:-

Sometimes you want to search for a pattern and add some characters, like parenthesis, around or near the pattern you found. It is easy to do this if you are looking
for a particular string:

sed 's/abc/(abc)/' new

This won't work if you don't know exactly what you will find. How can you put the string you found in the replacement string if you don't know what it is?

The solution requires the special character "&." It corresponds to the pattern found.

sed 's/[a-z]*/(&)/' new

4:-Using \1 to keep part of the pattern:-

The "\1" is the first remembered pattern, and the "\2" is the second remembered pattern. Sed has up to nine remembered patterns.

If you wanted to keep the first word of a line, and delete the rest of the line, mark the important part with the parenthesis:

sed 's/\([a-z]*\).*/\1/'

echo abcd123 | sed 's/\([a-z]*\).*/\1/'

This will output "abcd" and delete the numbers.

If you want to switch two words around, you can remember two patterns and change the order around:

sed 's/\([a-z]*\) \([a-z]*\)/\2 \1/'
If you want to detect duplicated words, you can use

sed -n '/\([a-z][a-z]*\) \1/p'

5:-/g - Global replacement:-

Most UNIX utilities work on files, reading a line at a time. Sed, by default, is the same way. If you tell it to change a word, it will only change the first
occurrence of the word on a line. You may want to make the change on every word on the line instead of the first. For an example, 
let's place parentheses around words on a line. Instead of using a pattern like "[A-Za-z]*" which won't match words like "won't," 
we will use a pattern, "[^ ]*," that matches everything except a space. Well, this will also match anything because "*" means zero or more.
The current version of Solaris's sed (as I wrote this) can get unhappy with patterns like this, and generate errors like "Output line too long" or even run forever. 
I consider this a bug, and have reported this to Sun. As a work-around, you must avoid matching the null string when using the "g" flag to sed.
A work-around example is: "[^ ][^ ]*." The following will put parenthesis around the first word:

sed 's/[^ ]*/(&)/' new
If you want it to make changes for every word, add a "g" after the last delimiter and use the work-around:

sed 's/[^ ][^ ]*/(&)/g' new


6:-/p - print:-

By default, sed prints every line. If it makes a substitution, the new text is printed instead of the old one. If you use an optional argument to sed,
"sed -n," it will not, by default, print any new lines. I'll cover this and other options later. When the "-n" option is used, the "p" flag will cause 
the modified line to be printed. Here is one way to duplicate the function of grep with sed:

sed -n 's/pattern/&/p'