ÖzgürBlog

Monday, May 11, 2015

Starbucks Yiyecek besin değerleri tablosu

STARBUCKS YİYECEK BESİN ÖĞELERİ TABLOSU Ocak 2015

	1 Porsiyon Yiyecek İçin
No	Ürün Adı	Karbonhidrat (g)	Protein (g)	Yağ (g)	Diyet Lif (g)	Kalori(kcal)
	Hamur İşleri
1	Peynirli Croissant	26,30	13,28	24,07	6,18	371
2	Kepekli Puf	44,58	11,96	26,73	7,40	467
3	Zeytinli Açma	34,96	6,30	9,90	5,16	254
4	Peynirli Simit	42,60	10,34	24,77	9,35	435
5	Kepekli Poğaça	15,03	7,13	23,47	3,92	300
6	Nutella'lı Açma	51,63	8,36	26,62	5,76	491
7	Tahıllı Peynirli Poğaça	29,63	8,32	22,41	3,99	353
8	Tulum Peynirli Domatesli Poğaça	25,29	8,96	19,00	6,11	320
	Cookie
1	Misto Cookie	33,94	5,71	16,72	3,12	309
	Muffinler
1	Çok Çikolatalı Muffin	59,15	9,13	27,61	8,90	522
2	Very Berry Muffin	54,78	7,89	29,16	5,02	514
	Kekler ve Tartlar
1	Profiterollü Pasta	42,02	6,71	13,13	3,45	313
2	Starbucks Brovvnie	51,92	13,02	58,50	12,82	786
3	Bella Vista	44,32	6,62	7,78	6,24	274
4	Çikolatalı-Yer Fıstıklı Pasta	63,00	9,00	44,40	3,00	680
5	Granola Bar	41,57	6,12	22,02	4,34	398
6	Glutensiz Çikolatalı Islak Kek	37,37	2,95	22,82	1,87	370
7	Ahududu&Beyaz Çikolatalı Cheesecake	76,11	9,78	24,71	0,34	565
8	Havuçlu Kek	56,30	8,37	30,39	5,68	532
9	Kepekli Havuçlu Kek	47,17	6,89	19,37	6,24	390
10	Mozaik Kek	59,94	8,25	24,54	5,85	494
11	Mozaik Pasta	67,78	7,68	26,31	2,74	486
12	Limonlu Cheesecake	83,39	14,05	34,31	-	699
13	Brovvnie Cheesecake	64,50	14,92	48,86	-	758
14	Balkabaklı Cheesecake	59,68	8,76	30,90	4,32	561
15	Kahveli Pasta	55,44	8,55	19,02	1,74	431
16	Tiramisu	36,60	3,10	13,00	-	276
17	Ananaslı Bademli Tart	40,25	11,50	32,75	5,88	514
	Sandviçler
1	Ezine Peynirli Sandviç	36,75	16,60	16,27	8,20	376
2	Roast Beef Sandviç	63,45	21,62	4,96	5,41	395
3	Haşhaşlı- Peynirli Sandviç	35,13	20,00	14,28	5,75	360
4	Ton Balıklı Sandviç	38,49	22,87	18,16	11,28	408
5	Çavdarlı Mini Hindi	28,04	12,40	5,38	0,22	214
6	Fiesta Sandviç	26,86	26,18	26,64	0,79	452
7	Mistik Sandviç	39,90	19,29	15,87	3,79	380
8	Hindi Fümeli&Jambonlu	41,20	25,17	16,15	25,17	411
9	Mozarella Sandviç	4,27	16,90	40,74	5,27	450
10	Roast Beef Croissant	23,94	16,38	21,00	3,64	358
	Paketli Sandviçler
1	Sebzeli-Cheddar Peynirli Tost	41,48	15,93	11,74	7,35	350
2	Jambonlu-Kaşar Peynirli Tost	57,60	24,75	18,05	5,85	504
3	Zeytinli-Beyaz Peynirli Tost	41,06	11,62	9,21	5,98	306
	Diğer
1	Sezar Salata	1,30	33,00	32,30	2,54	432
2	Ton Balıklı Salata	3,50
3	Tulum Peynirli Salata	19,30	14,60	22,20	6,60	349
4	Meyve Salatası	24,00	2,90	1,74	1,90	123
5	Limonlu parfe	101,38	7,96	18,44	6,72	615
6	Meyveli ve yoğurtlu parfe	58,41	15,43	16,65	2,64	449
7	Domates çorbası	7,54	3,20	9,48	2,46	133
8	Meyveli Çıtır Müsli	50,24	8,71	8,78	6,52	326

Monday, May 4, 2015

Oracle Dblink from 11g to 8i

How to connect 8i database from 11g database:

After upgrading the production system from 10g to 11G, our dblinks to 8i databases are not working. All the custom codes has dblinks to 8i system. ( @OLDY) We needed to keep this dblink alive.

Since 11g to 8i dblinks are not supported as MOS note: 207303.1 We have to use a bridged connection through 10g database:

Client Version	Server Version
Client Version	12.1.0	11.2.0	11.1.0	10.2.0	10.1.0	9.2.0
12.1.0	Yes	Yes	ES	LES #7	No #3	No #3
11.2.0	Yes	Yes	ES	LES #7	No	Was #5
11.1.0	ES	ES	ES	LES #7	Was #6	Was #5
10.2.0	LES #7	LES #7	LES #7	LES	Was	Was #5
10.1.0(#4)	No	Was #6	Was #6	Was	Was	Was
9.2.0	No#8	Was #5	Was #5	Was #5	Was	Was

Key:

Yes Supported

LES Limited Extended Support

ES Supported but fixes only possible for customers with Extended Support .

Was Was a supported combination but one of the releases is no longer covered by any of Premier Support , Primary Error Correct support , Extended Support nor Extended Maintenance Support so fixes are no longer possible.

No Has never been Supported

11g --> 10g(SID=BRIDGE) --> 8i (SID=OLDY)

Example setup:

On 10g database (BRIDGE) we shoud create a dblink to 8i database(OLDY): (10g-->8i)

CREATE PUBLIC DATABASE LINK "OLDY"
CONNECT TO username
IDENTIFIED BY <Password>
USING '(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=oldy_8i_hardware)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SID=OLDY)
)
)';

On 11g database (PRODUCTION) we should create a database link to 10G database, However we will name it as "OLDY". (Note that this OLDY dblink was pointing to 8i database before upgrading to 11g.)

CREATE PUBLIC DATABASE LINK "OLDY"
CONNECT TO bridge_user
IDENTIFIED BY <Password>
USING '(DESCRIPTION=
(SDU=32768)
(ADDRESS=(PROTOCOL=tcp)(HOST=10g_hardware_server)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=BRIDGE))
)';

Then we need to create synonyms on "bridege_user" (on 10g BRIDGE database) for every single table on OLDY database.

example:

> login to BRIDGE 10G database as bridge_user:

run:

SQL> CREATE OR REPLACE SYNONYM table1 FOR hr.table1@OLDY

Now:

SQL> select * from table1@OLDY;

it works.

It goes firstly to 10g database with user bride_user, then bridge_user selects from its synonym pointing to 8i database.

Yoy have to create synonyms for all table you need to connect from 10g to 8i.

Hope this helps. We are using this method on PROD system that is 11g.

Thursday, December 18, 2014

How to change subnet mask in Oracle Clusterware (grid infrastructure)

Change subnet mask on RAC databases:

Task: Changing Subnet Mask from 255.255.255.0 to 255.255.254.0 on 10gR2 2-node RAC database running on HP-UX 11.31 boxes.

We followed Note: Doc ID 276434.1. However Case III was not clear for our case.

Case III says :

"If the change involves different subnet(netmask) or interface, delete the existing interface information from OCR and add it back with the correct information is required. In the example here, the subnet is changed from 10.2.156.0 to 10.2.166.0 via two separate commands - first a 'delif' followed by a 'setif':
% $CRS_HOME/bin/oifcfg/oifcfg delif -global <if_name>[/<subnet>] % $CRS_HOME/bin/oifcfg/oifcfg setif -global <if_name>/<subnet>:public
For example: % $CRS_HOME/bin/oifcfg delif -global eth0/10.2.156.0 % $CRS_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public"

However, changing subnet mask from 255.255.255.0 to 255.255.254.0 is not changing public network. So, we raise an SR and we suggested to skip Case III and apply Case IV.

Here is the steps that we use:

1. First gather the existing setup:

racdb1> srvctl config nodeapps -n racdb1 -a

VIP exists.: /racdb1-vip/10.255.0.167/255.255.255.0/lan900

racdb1> srvctl config nodeapps -n racdb2 -a

VIP exists.: /racdb2-vip/10.255.0.168/255.255.255.0/lan900

racdb1> crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....E1.inst application ONLINE ONLINE racdb1

ora....E2.inst application ONLINE ONLINE racdb2

ora.prod.db application ONLINE ONLINE racdb2

ora....SM1.asm application ONLINE ONLINE racdb1

ora....B1.lsnr application ONLINE ONLINE racdb1

ora.racdb1.gsd application ONLINE ONLINE racdb1

ora.racdb1.ons application ONLINE ONLINE racdb1

ora.racdb1.vip application ONLINE ONLINE racdb1

ora....SM2.asm application ONLINE ONLINE racdb2

ora....B2.lsnr application ONLINE ONLINE racdb2

ora.racdb2.gsd application ONLINE ONLINE racdb2

ora.racdb2.ons application ONLINE ONLINE racdb2

ora.racdb2.vip application ONLINE ONLINE racdb2

racdb1> netstat -in

Name Mtu Network Address Ipkts Ierrs Opkts Oerrs Coll

lo0 32808 127.0.0.0 127.0.0.1 1973468007 0 1973470399 0 0

lan900:8 1500 10.255.0.0 10.255.0.167 25546968404 0 59117886 0 0

Warning: The above name 'lan900:801' is truncated, use -w to show the output in wide format

lan901 1500 192.168.56.0 192.168.56.160 95623379768 82 42023362181 0 0

lan900 1500 10.255.0.0 10.255.0.160 42141072728 0 95058720682 0 0

racdb1> ./crs_stat -p ora.racdb1.vip

NAME=ora.racdb1.vip

TYPE=application

ACTION_SCRIPT=/u01/oraprod/prod/proddb/crshome/bin/racgwrap

ACTIVE_PLACEMENT=1

AUTO_START=1

CHECK_INTERVAL=30

DESCRIPTION=CRS application for VIP on a node

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=racdb1

OPTIONAL_RESOURCES=

PLACEMENT=favored

REQUIRED_RESOURCES=

RESTART_ATTEMPTS=0

SCRIPT_TIMEOUT=60

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=lan900

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=255.255.255.0

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=10.255.0.167

2. Stop the resources:

racdb1> srvctl stop instance -d prod -i prod1

racdb1> ps -ef|grep pmon

oraprod 5136 1 0 Dec 8 ? 161:51 asm_pmon_+ASM1

oraprod 5277 27140 1 22:07:17 pts/2 0:00 grep pmon

racdb1> srvctl stop instance -d prod -i prod2

racdb1> srvctl stop asm -n racdb1

racdb1> ps -ef|grep pmon

oraprod 7266 27140 0 22:10:50 pts/2 0:00 grep pmon

racdb1> srvctl stop asm -n racdb2

racdb1> srvctl stop nodeapps -n racdb1

racdb1> ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....E1.inst application OFFLINE OFFLINE

ora....E2.inst application OFFLINE OFFLINE

ora.prod.db application OFFLINE OFFLINE

ora....SM1.asm application OFFLINE OFFLINE

ora....B1.lsnr application OFFLINE OFFLINE

ora.racdb1.gsd application OFFLINE OFFLINE

ora.racdb1.ons application OFFLINE OFFLINE

ora.racdb1.vip application OFFLINE OFFLINE

ora....SM2.asm application OFFLINE OFFLINE

ora....B2.lsnr application OFFLINE OFFLINE

ora.racdb2.gsd application OFFLINE OFFLINE

ora.racdb2.ons application OFFLINE OFFLINE

ora.racdb2.vip application OFFLINE OFFLINE

3. Modify VIP

Run as root:

#./srvctl modify nodeapps -n racdb1 -A racdb1-vip/255.255.254.0/lan900

#./srvctl modify nodeapps -n racdb2 -A racdb2-vip/255.255.254.0/lan900

Verify:

racdb1:/u01/oraprod/prod/proddb/crshome/bin#./crs_stat -p ora.racdb2.vip

NAME=ora.racdb2.vip

TYPE=application

ACTION_SCRIPT=/u01/oraprod/prod/proddb/crshome/bin/racgwrap

ACTIVE_PLACEMENT=1

AUTO_START=1

CHECK_INTERVAL=30

DESCRIPTION=CRS application for VIP on a node

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

HOSTING_MEMBERS=racdb2

OPTIONAL_RESOURCES=

PLACEMENT=favored

REQUIRED_RESOURCES=

RESTART_ATTEMPTS=0

SCRIPT_TIMEOUT=60

START_TIMEOUT=0

STOP_TIMEOUT=0

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=0

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=0

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=lan900

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=255.255.254.0

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=0

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=0

USR_ORA_VIP=10.255.0.168

racdb1:/u01/oraprod/prod/proddb/crshome/bin#./srvctl config nodeapps -n racdb1 -a

VIP exists.: /racdb1-vip/10.255.0.167/255.255.254.0/lan900

racdb1:/u01/oraprod/prod/proddb/crshome/bin#./srvctl config nodeapps -n racdb2 -a

VIP exists.: /racdb2-vip/10.255.0.168/255.255.254.0/lan900

4. Start resources:

racdb1> srvctl start nodeapps -n racdb1

racdb1> srvctl start nodeapps -n racdb2

racdb1> srvctl start asm -n racdb1

racdb1> srvctl start asm -n racdb2

racdb1> srvctl start instance -d prod -i prod1

racdb1> srvctl start instance -d prod -i prod2

racdb1> ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....E1.inst application ONLINE ONLINE racdb1

ora....E2.inst application ONLINE ONLINE racdb2

ora.prod.db application ONLINE ONLINE racdb2

ora....SM1.asm application ONLINE ONLINE racdb1

ora....B1.lsnr application ONLINE ONLINE racdb1

ora.racdb1.gsd application ONLINE ONLINE racdb1

ora.racdb1.ons application ONLINE ONLINE racdb1

ora.racdb1.vip application ONLINE ONLINE racdb1

ora....SM2.asm application ONLINE ONLINE racdb2

ora....B2.lsnr application ONLINE ONLINE racdb2

ora.racdb2.gsd application ONLINE ONLINE racdb2

ora.racdb2.ons application ONLINE ONLINE racdb2

ora.racdb2.vip application ONLINE ONLINE racdb2

Yes	Supported
LES	Limited Extended Support
ES	Supported but fixes only possible for customers with Extended Support .
Was	Was a supported combination but one of the releases is no longer covered by any of Premier Support , Primary Error Correct support , Extended Support nor Extended Maintenance Support so fixes are no longer possible.
No	Has never been Supported

Sayfalar

Monday, May 11, 2015

Starbucks Yiyecek besin değerleri tablosu

STARBUCKS YİYECEK BESİN ÖĞELERİ TABLOSU Ocak 2015

Monday, May 4, 2015

Oracle Dblink from 11g to 8i

Thursday, December 18, 2014

How to change subnet mask in Oracle Clusterware (grid infrastructure)