oracle11g - How do I create a new Connection in Oracle SQL Developer? -

-

i've installed oracle database 11g release 2 on windows 7.

i'm in oracle sql developer , i'm trying create new connection, when click in "connect", got message: "status: failure -test failed: network adapter not establish connection".

in connection window, i've tried changing role sysdba, os authentication, port, , sid, when changing values got same message.

tnsnames.ora contents:

# tnsnames.ora network configuration file: f:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # generated oracle configuration tools.  oraclr_connection_data =   (description =     (address_list =       (address = (protocol = ipc)(key = extproc1521))     )     (connect_data =       (sid = clrextproc)       (presentation = ro)     )   )  orcl =   (description =     (address = (protocol = tcp)(host = 192.168.0.104)(port = 1521))     (connect_data =       (server = dedicated)       (service_name = orcl.168.0.104)     )   )

listener.ora:

# listener.ora network configuration file: f:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora # generated oracle configuration tools.  sid_list_listener =   (sid_list =     (sid_desc =       (sid_name = clrextproc)       (oracle_home = f:\oracle\product\11.2.0\dbhome_1)     )   )  listener =   (description_list =     (description =       (address = (protocol = ipc)(key = extproc1521))       (address = (protocol = tcp)(host = 192.168.0.104)(port = 1521))     )   )  adr_base_listener = f:\oracle

alert log:

<msg time='2015-06-02t19:28:12.428-05:00' org_id='oracle' comp_id='tnslsnr'  type='unknown' level='16' host_id='kk-pc'  host_addr='fe80::986b:9a38:5c9f:fc06%10' version='1'>  <txt>02-jun-2015 19:28:12 * (connect_data=(sid=clrextproc)(cid=(program=sql developer)(host=__jdbc__)(user=kk))) * (address=(protocol=tcp)(host=192.168.0.104)(port=51332)) * establish * clrextproc * 0  </txt> </msg>

lsnrctl status:

services summary... service "orcl.168.0.104" has 1 instance(s).   instance "orcl", status ready, has 1 handler(s) service... service "orclxdb.168.0.104" has 1 instance(s).   instance "orcl", status ready, has 1 handler(s) service... command completed

how can solve this?

thanks.

so i'll answer own question hehe.

what did stop listener service, removed listener.ora admin folder, , started service again.

then did lsnrctl status in command prompt , got service name , sid. connect orcl sid , orcl.168.0.104 service name, works perfect. lot.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more