Page 1 of 2 12 LastLast
Results 1 to 15 of 25
  1. #1
    Join Date
    Sep 2010
    Posts
    31

    Unanswered: DB Connect with W2k8 R2 failed

    Hi

    i installed Oracle Enterprise Linux R5 with Oracle 11.2.0g and i now want to connect over the network from my Windows client to the created database. But i didnīt work i got this error message with both ODCB drivers 32 & 64 bit.

    ORA-12154: TNS: could not resolve the connect identifier specified

    I use the instant client software 11.2 from oracle to connect the db.
    I can ping from the client the DB server and can resolve the hostname with nslookup, also i get a response if i telnet the server on port 1521.

    hereīs my tnsnames.ora
    VCDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vc-db1)(PORT = 1521))
    (CONNECT_DATA =
    (SERVICE_NAME = vcdb)
    )
    )
    i tested it with full HOSTNAME like vc-db1.mydomain and also with SERVICE_NAME vcdb.vmware but the error still exists.

    On the db server the listener works i think

    lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 20:45:15

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vc-db1.vmware.fh-muenster.de)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date 17-SEP-2010 13:54:38
    Uptime 0 days 6 hr. 50 min. 37 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Listener Log File /u01/app/oracle/diag/tnslsnr/vc-db1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vc-db1.vmware.fh-muenster.de)(PORT=1521)))
    Services Summary...
    Service "vcdb.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Service "vcdbXDB.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    The command completed successfully

    I set the oracle enviroment variables correct i think

    env | grep ORA
    ORACLE_SID=VCDB
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOSTNAME=vc-db1.mydomain
    ORACLE_TERM=xterm
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

    tnsping vcdb

    TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 21:24:06

    Copyright (c) 1997, 2009, Oracle. All rights reserved.

    Used parameter files:
    /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vc-db1.mydomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = VCDB.vmware)))
    OK (0 msec)

    So i searched the internet and forums for a while but i canīt find a hint or solution to solve my problem. I hope anyone can help me in this issue.

    THX and kind regards
    ACID1943
    Last edited by ACID1943; 09-17-10 at 16:27.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle in World: ORA-12154: TNS:could not resolve the connect identifier specified

    Please use COPY & PASTE so we can see what you do & how Oracle responds
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2010
    Posts
    31
    Hi

    if i do that sqlplus system/passwort@VCDB

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 17 21:47:25 2010

    Copyright (c) 1982, 2009, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL>

    it works but with sqlplus system/passwort@VCDB as SYSDBA

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 17 21:49:01 2010

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    ERROR:
    ORA-01031: insufficient privileges


    Enter user-name: system
    Enter password:
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    Process ID: 0
    Session ID: 0 Serial number: 0

    So iīm very confused i tested a lot of things but nothing helps....hope you can help me...

    THX IN ADVANCE
    ACID1943

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    probably without realizing it you are mixing & matching numerous different factors in what you did.

    1) when ever you connect to database using "@alias"; then SQL*Net is used to complete connection request.

    2) You can connect to local DB without SQL*Net, but a few conditions need to be correct at OS level.
    2a) OS user must be in OS group "dba"
    2b) ORACLE_SID environmental variable need to be set (ORACLE_SID is CaseSensitive)
    VCDB is different than vcdb
    2c) ORACLE_HOME environmental variable need to be set

    open a terminal window on DB Server

    COPY commands below

    id
    lsnrctl status
    env | sort
    lsnrctl service

    PASTE lines above into terminal window

    COPY commands & results then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2010
    Posts
    31
    ok here the output from the commands

    id
    uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)

    lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 22:11:34

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vc-db1.mydomain)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date 17-SEP-2010 13:54:38
    Uptime 0 days 8 hr. 16 min. 56 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Listener Log File /u01/app/oracle/diag/tnslsnr/vc-db1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vc-db1.mydomain)(PORT=1521)))
    Services Summary...
    Service "vcdb.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Service "vcdbXDB.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    The command completed successfully

    env | sort
    _=/bin/env
    CLASSPATH=/u01/app/oracle/product/11.2.0/dbhome_1/JRE:/u01/app/oracle/product/11.2.0/dbhome_1/jlib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/jlib
    CVS_RSH=ssh
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=vc-db1.mydomain
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36i=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*. sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj =00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00; 31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.t z=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif =00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=0 0;35:*.tif=00;35:
    MAIL=/var/spool/mail/olly
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
    ORACLE_HOSTNAME=vc-db1.mydomain
    ORACLE_SID=VCDB
    ORACLE_TERM=xterm
    PATH=/usr/kerberos/sbin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/olly/bin
    PWD=/home/olly
    SHELL=/bin/bash
    SHLVL=3
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_CLIENT=10.11.235.23 50417 2323
    SSH_CONNECTION=10.11.235.23 50417 172.31.98.173 2323
    SSH_TTY=/dev/pts/3
    TERM=xterm
    TMP=/tmp
    USER=oracle

    lsnrctl service

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 22:12:15

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vc-db1.mydomain)(PORT=1521)))
    Services Summary...
    Service "vcdb.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:44 refused:0 state:ready
    LOCAL SERVER
    Service "vcdbXDB.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: vc-db1.mydomain, pid: 5892>
    (ADDRESS=(PROTOCOL=tcp)(HOST=vc-db1.mydomain)(PORT=24823))
    The command completed successfully

    regards
    ACID1943

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Instance "vcdb", status READY, has 1 handler(s) for this service...
    >ORACLE_SID=VCDB

    They need to match each other above

    export ORACLE_SID=vcdb
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Sep 2010
    Posts
    31
    ok i export the new sid but know the db isnīt starting, i think and i canīt login
    so what i have to change also...sorry but this i blowing my mind today, could you give an other hint what to do now to get it work?


    sqlplus system/passwort@vcdb

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 17 22:40:42 2010

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    ERROR:
    ORA-12514: TNS:listener does not currently know of service requested in connect
    descriptor

    lsnrctl service

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 22:39:31

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vc-db1.mydomain)(PORT=1521)))
    Services Summary...
    Service "VCDB.VMWARE (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1/" has 1 instance(s).
    Instance "vcdb", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    The command completed successfully

    regards
    ACID1943
    Last edited by ACID1943; 09-17-10 at 17:48.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    COPY commands below

    export ORACLE_SID=vcdb
    id
    env | sort
    sqlplus
    / as sysdba
    startup
    select * from v$version;
    exit

    PASTE lines above into terminal window

    COPY commands & results then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    Sep 2010
    Posts
    31
    hereīs the output from the commands


    [oracle@vc-db1 ~]$ id
    uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
    [oracle@vc-db1 ~]$ env | sort
    _=/bin/env
    CVS_RSH=ssh
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=vc-db1.mydomain
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36i=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*. sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj =00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00; 31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.t z=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif =00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=0 0;35:*.tif=00;35:
    MAIL=/var/spool/mail/olly
    OLDPWD=/home/olly
    ORACLE_BASE=/u01/app/oracle/
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/
    ORACLE_SID=vcdb
    PATH=/usr/kerberos/sbin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/olly/bin
    PWD=/home/oracle
    SHELL=/bin/bash
    SHLVL=2
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_CLIENT=10.11.235.25 49622 2323
    SSH_CONNECTION=10.11.235.25 49622 172.31.98.173 2323
    SSH_TTY=/dev/pts/3
    TERM=xterm
    USER=oracle
    [oracle@vc-db1 ~]$ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 18 12:59:56 2010

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup;
    ORA-00845: MEMORY_TARGET not supported on this system
    SQL> select * from v$version;
    select * from v$version
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0


    SQL> exit
    Disconnected

    regards
    ACID1943

  10. #10
    Join Date
    Sep 2010
    Posts
    31
    ok the database is now up and running

    sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 18 13:20:37 2010

    Copyright (c) 1982, 2009, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup;
    ORACLE instance started.

    Total System Global Area 1653518336 bytes
    Fixed Size 2213896 bytes
    Variable Size 956303352 bytes
    Database Buffers 687865856 bytes
    Redo Buffers 7135232 bytes
    Database mounted.
    Database opened.
    SQL> exit

    but from the client the tnsnames error still exists. once again the tnsnames.ora from the windows client

    VCDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vc-db1.mydomain)(PORT = 1521))
    (CONNECT_DATA =
    (SERVICE_NAME = vcdb.vmware)
    )
    )

    i canīt understand what is wrong now...
    regards
    ACID1943

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    COPY commands below

    export ORACLE_SID=vcdb
    id
    env | sort
    lsnrctl status
    sqlplus scott/tiger@vcdb
    lsnrctl service
    cat $ORACLE_HOME/network/admin/tnsnames.ora
    tail -50 $ORACLE_HOME/network/admin/listener.log
    cat /etc/hosts


    PASTE lines above into terminal window

    COPY commands & results then PASTE all back here
    __________________
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  12. #12
    Join Date
    Sep 2010
    Posts
    31
    THX hereīs the output from the commands

    [oracle@vc-db1 olly]$ id
    uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
    [oracle@vc-db1 olly]$ env | sort
    _=/bin/env
    CVS_RSH=ssh
    G_BROKEN_FILENAMES=1
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=vc-db1.mydomain
    INPUTRC=/etc/inputrc
    LANG=en_US.UTF-8
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=no=00:fi=00:di=00;34:ln=00;36i=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*. sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj =00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00; 31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.t z=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif =00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=0 0;35:*.tif=00;35:
    MAIL=/var/spool/mail/olly
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
    ORACLE_HOSTNAME=vc-db1.mydomain
    ORACLE_SID=vcdb
    ORACLE_TERM=xterm
    PATH=/usr/kerberos/sbin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/olly/bin
    PWD=/home/olly
    SHELL=/bin/bash
    SHLVL=2
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_CLIENT=10.11.235.21 49204 2323
    SSH_CONNECTION=10.11.235.21 49204 172.31.98.173 2323
    SSH_TTY=/dev/pts/1
    TERM=xterm
    USER=oracle
    [oracle@vc-db1 olly]$ sqlplus system/4telvor8@vcdb

    SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 18 19:27:34 2010

    Copyright (c) 1982, 2009, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL> exit
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    [oracle@vc-db1 olly]$ lsnrctl status

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2010 19:27:55

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vc-db1.vmware.fh-muenster.de)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
    Start Date 18-SEP-2010 13:20:34
    Uptime 0 days 6 hr. 7 min. 20 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    Listener Log File /u01/app/oracle/diag/tnslsnr/vc-db1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vc-db1.mydomain)(PORT=1521)))
    Services Summary...
    Service "vcdb.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Service "vcdbXDB.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    The command completed successfully
    [oracle@vc-db1 olly]$ lsnrctl service

    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-SEP-2010 19:28:06

    Copyright (c) 1991, 2009, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vc-db1.mydomain)(PORT=1521)))
    Services Summary...
    Service "vcdb.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:1 refused:0 state:ready
    LOCAL SERVER
    Service "vcdbXDB.vmware" has 1 instance(s).
    Instance "vcdb", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1022 state:ready
    DISPATCHER <machine: vc-db1.mydomain, pid: 4695>
    (ADDRESS=(PROTOCOL=tcp)(HOST=vc-db1.mydomain)(PORT=24490))
    The command completed successfully
    [oracle@vc-db1 olly]$ cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    VCDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vc-db1.mydomain)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = vcdb.vmware)
    )
    )

    [oracle@vc-db1 olly]$ tail -50 /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.log
    tail: cannot open `/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.log' for reading: No such file or directory
    [oracle@vc-db1 olly]$ 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
    172.31.98.173 vc-db1.mydomain vc-db1
    ::1 localhost6.localdomain6 localhost6

    kind regards
    ACID1943

  13. #13
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Congratulations!
    Problem is solved.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  14. #14
    Join Date
    Sep 2010
    Posts
    31
    Hi

    not really cause it canīt still connect to the db from the win client....the error is the same before....

    ORA-12154: TNS: could not resolve the connect identifier specified

    and i have one more question, if i create a new tablespace f.e. like "vpx01.dbf" what i have to do, to connect to this tablespace from client?

    Kind reagrds
    ACID 1943

  15. #15
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >not really cause it canīt still connect to the db from the win client....the error is the same before....
    >ORA-12154: TNS: could not resolve the connect identifier specified

    Replace tnsnames.ora on the client with the same file from DB Server

    >and i have one more question, if i create a new tablespace f.e. like "vpx01.dbf"
    Above looks to me that "vpx01.dbf" is a filename; not a tablespace_name.

    >what i have to do, to connect to this tablespace from client?
    One does not "connect to" a tablespace.
    An Oracle USER may require QUOTA to create objects in a tablespace.
    An Oracle USER may require additional privilege(s) to SELECT from a tablespace.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •