Forum Stats

  • 3,851,977 Users
  • 2,264,055 Discussions
  • 7,904,923 Comments

Discussions

ContentServerExplorer and CatalogMover

user1254328
user1254328 Member Posts: 856 Bronze Badge
edited Nov 12, 2018 4:43PM in WebCenter Sites

Hello Experts - i have sites 12.2.1.3 installed on Oracle VM ( Linux). I want browse the sites tables.

1> I do have the client extracted and see ContentServerExplorer .exe  Obviously, I cannot run this .exe on linux. where is the  ContentServerExplorer.sh  ?   What is best way to open ContentServerExplorer ?

2> I did not find  CatalogMover.sh ...  does it come by default site install. how can I get hold of this utility ?

3> i found new MVC ( controller ) in 12.2.1.3 much cleaner and efficient. Is using MVC way to go for any ( and ALL ) sites programming going ahead ? Like a standard.

Thx

Best Answer

  • Graham L
    Graham L Member Posts: 69 Blue Ribbon
    edited Nov 12, 2018 6:55AM Answer ✓

    You could use something like Wine which I did years ago or run a Windows VM but I don't see why anybody would go to the trouble of using either of these now. As already mentioned use one of the following.

    1. SQL client (Oracle SQL Developer, SQuirrel, Toad etc)
    2. Support Tools
    3. Your IDE's ability to make SQL connections like Eclipse DTP

Answers

  • Graham L
    Graham L Member Posts: 69 Blue Ribbon
    edited Nov 11, 2018 7:51AM
    1. ContentServerExplorer is a windows executable so it will not run on any flavour of Unix natively. There are ways to run using Windows emulators etc but more trouble than it is worth.
    2. CatalogMover is part of every install and can be found in Sites/home/bin/catalogmover.sh
    3. MVC is a well known design pattern and helps separate the different concerns. I am not sure what you mean by any and ALL sites programming?. Design patterns are just that and are well tested ways of solving a commonly occurring problems in software development. MVC is not a one size fits all approach though. Many other design patterns might be exploited in building your website. Do what makes sense for each individual problem.
  • user1254328
    user1254328 Member Posts: 856 Bronze Badge
    edited Nov 11, 2018 8:40PM

    anybody using successfully and knows a good Windows Emulator for opening ContentServerExplorer ?

    I am able to locate the   catalogmover.sh when executed gives following and did not fully open the catalogmover. anybody faced similar issue ?

                                          chmod -x  catalogmover.sh

    [[email protected] bin]$ ./catalogmover.sh

    SLF4J: Class path contains multiple SLF4J bindings.

    SLF4J: Found binding in [jar:file:/u01/userhome/oracle/Middleware/wcsites/wcsites_common/lib/integrations-slf4j-odl.jar!/org/slf4j/impl/StaticLoggerBinder.class]

    SLF4J: Found binding in [jar:file:/u01/userhome/oracle/Middleware/wcsites/wcsites_common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

    SLF4J: Found binding in [jar:file:/u01/userhome/oracle/Middleware/oracle_common/modules/thirdparty/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

    SLF4J: Found binding in [jar:file:/u01/userhome/oracle/Middleware/oracle_common/modules/thirdparty/slf4j-jcl-1.7.12.jar!/org/slf4j/impl/StaticLoggerBinder.class]

    SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

    SLF4J: Actual binding is of type [org.slf4j.impl.ODLLoggerFactory]

    [email protected] Using the following ODL configuration file: /u01/userhome/oracle/Middleware/wcsites/webcentersites/sites-home/template/config/logging-config.xml

    Exception in thread "main" java.lang.ExceptionInInitializerError

        at org.slf4j.impl.ODLLoggerFactory.getLogger(ODLLoggerFactory.java:32)

        at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:277)

        at org.apache.commons.logging.impl.SLF4JLogFactory.getInstance(SLF4JLogFactory.java:156)

        at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:671)

        at COM.FutureTense.Util.ftUtil.<clinit>(ftUtil.java:56)

        at COM.FutureTense.Apps.CatalogMoverEngine.<init>(CatalogMoverEngine.java:253)

        at COM.FutureTense.Apps.CatalogMover.main(CatalogMover.java:26)

    Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle.core.ojdl.logging.LoggingConfiguration

        at com.oracle.sites.cos.logging.odl.ODLLoggingConfiguration.<clinit>(ODLLoggingConfiguration.java:34)

        ... 7 more

    Caused by: java.lang.ClassNotFoundException: oracle.core.ojdl.logging.LoggingConfiguration

        at java.net.URLClassLoader.findClass(URLClassLoader.java:381)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

        at java.lang.Class.forName0(Native Method)

        at java.lang.Class.forName(Class.java:264)

        at com.oracle.sites.cos.logging.odl.ODLLoggingConfiguration.<clinit>(ODLLoggingConfiguration.java:30)

        ... 7 more

  • Graham L
    Graham L Member Posts: 69 Blue Ribbon
    edited Nov 11, 2018 10:46PM

    Almost nobody uses ContentServerExplorer anymore. Why not just use and SQL client like Squirrel or Oracle SQL Developer? You can even use something like DTP (Data Tools Platform) in Eclipse and connect from inside your IDE.

    Why are you doing chmod -x? That removes the executable permission on the script.

    I have never seen that specific error when running CatalogMover but it is definitely a classpath problem. Check your classpath. Maybe run using sh -x catalogmover.sh and see what the classpath is when it is executed.

  • Nirav Varma
    Nirav Varma Member Posts: 484 Gold Badge
    edited Nov 12, 2018 5:14AM

    Sorry, there is no other emulator. If you just want to browse db tables, may be you can use either Support Tools (utility tools available in Oracle Support) or some db tools like Oracle SQL Developer.

  • Graham L
    Graham L Member Posts: 69 Blue Ribbon
    edited Nov 12, 2018 6:55AM Answer ✓

    You could use something like Wine which I did years ago or run a Windows VM but I don't see why anybody would go to the trouble of using either of these now. As already mentioned use one of the following.

    1. SQL client (Oracle SQL Developer, SQuirrel, Toad etc)
    2. Support Tools
    3. Your IDE's ability to make SQL connections like Eclipse DTP