Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I am an oracle newbie, I should sqlplus connection to oracle

972829Nov 6 2012 — edited Nov 8 2012

I want to do: Open the oracle, create a Test database.

System: redhat 6.2 / / Oracle version: 11g r2

Here is my oracle log file, please help me, thank.

=============================================

Sun Oct 14 00:18:53 2012
Create Relation ADR_CONTROL
Create Relation ADR_INVALIDATION
Create Relation INC_METER_IMPT_DEF
Create Relation INC_METER_PK_IMPTS
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Trace information written to /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/ora_2185_3078911680.trc
Trace level is currently 0

Started with pid=2185
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
14-OCT-2012 00:18:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Sun Oct 14 00:21:59 2012
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on stop
14-OCT-2012 00:21:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * stop * 0
Thu Nov 01 23:04:51 2012
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Trace information written to /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/ora_3372_3079083712.trc
Trace level is currently 0

Started with pid=3372
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
01-NOV-2012 23:04:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Thu Nov 01 23:05:08 2012
WARNING: Subscription for node down event still pending
01-NOV-2012 23:05:08 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Thu Nov 01 23:08:14 2012
WARNING: Subscription for node down event still pending
01-NOV-2012 23:08:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Thu Nov 01 23:10:51 2012
Trace information written to /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/ora_3372_3079083712.trc
Trace level is currently 0
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
01-NOV-2012 23:10:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * reload * 0
Thu Nov 01 23:11:27 2012
01-NOV-2012 23:11:27 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * services * 0
Thu Nov 01 23:33:14 2012
WARNING: Subscription for node down event still pending
01-NOV-2012 23:33:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Thu Nov 01 23:45:33 2012
01-NOV-2012 23:45:33 * (CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=sqlplus)(HOST=localhost.localdomain)(USER=oracle))) * establish * 12504
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Thu Nov 01 23:52:12 2012
01-NOV-2012 23:52:12 * (CONNECT_DATA=(SERVICE_NAME=oracle)(CID=(PROGRAM=java)(HOST=localhost.localdomain)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=14409)) * establish * oracle * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Thu Nov 01 23:55:32 2012
WARNING: Subscription for node down event still pending
01-NOV-2012 23:55:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Thu Nov 01 23:56:01 2012
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on stop
01-NOV-2012 23:56:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * stop * 0
Tue Nov 06 22:24:37 2012
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Trace information written to /u01/app/oracle/diag/tnslsnr/localhost/listener/trace/ora_2674_3077985984.trc
Trace level is currently 0

Started with pid=2674
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
06-NOV-2012 22:24:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Tue Nov 06 22:26:40 2012
WARNING: Subscription for node down event still pending
06-NOV-2012 22:26:40 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Tue Nov 06 22:49:34 2012
WARNING: Subscription for node down event still pending
06-NOV-2012 22:49:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Tue Nov 06 23:02:20 2012
WARNING: Subscription for node down event still pending
06-NOV-2012 23:02:20 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Tue Nov 06 23:07:20 2012
06-NOV-2012 23:07:20 * (CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=sqlplus)(HOST=localhost.localdomain)(USER=oracle))) * establish * 12504
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Tue Nov 06 23:08:44 2012
06-NOV-2012 23:08:44 * (CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=sqlplus)(HOST=localhost.localdomain)(USER=oracle))) * establish * 12504
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Tue Nov 06 23:09:23 2012
06-NOV-2012 23:09:23 * (CONNECT_DATA=(SERVICE_NAME=oracle)(CID=(PROGRAM=sqlplus)(HOST=localhost.localdomain)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=22109)) * establish * oracle * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Tue Nov 06 23:10:20 2012
WARNING: Subscription for node down event still pending
06-NOV-2012 23:10:20 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Tue Nov 06 23:47:51 2012
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on stop
06-NOV-2012 23:47:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * stop * 0

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2012

Added on Nov 6 2012

#11g, #general-database-discussions, #oracle

8 comments

1,856 views